java_web里面的代码，想复习一下曾经写过的代码_style:'text-align:right;padding-right:25px;-优快云博客

本文链接：https://blog.youkuaiyun.com/Small_madman/article/details/7677538

本文介绍了一个Java程序如何通过使用JDBC连接到Oracle数据库的方法，并提供了一个基于JSP的简单用户登录页面示例，该页面包含了基本的验证逻辑。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//dbhelp里面的

import java.sql.CallableStatement;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
* 封装对数据库的访问及对数据库资源的管理
* @author matrix
*
*/
public class DBHelp{
   private String className = "oracle.jdbc.driver.OracleDriver";
   private String url = "jdbc:oracle:thin:@localhost:1521:ORCL";
   private String username = "crm";
   private String password = "crm";

   public Connection getConnection(){
       Connection con = null;
       try {
           Class.forName(className);
           con = DriverManager.getConnection(url,username,password);

       } catch (ClassNotFoundException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }
       return con;
   }

   public static void close(ResultSet rs, Statement st, PreparedStatement ps, Connection con,CallableStatement cs){
       if(rs != null){
           try {
               rs.close();
           } catch (SQLException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }
       }
       if(st != null){
           try {
               st.close();
           } catch (SQLException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }
       }
       if(ps != null){
           try {
               ps.close();
           } catch (SQLException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }
       }
       if(con != null){
           try {
               con.close();
           } catch (SQLException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }
       }
       if(rs != null){
           try {
               rs.close();
           } catch (SQLException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }
       }
       if(cs != null){
           try {
               cs.close();
           } catch (SQLException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }

       }
   }

}

//login.jsp里面的

<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<HTML>
<HEAD>
<TITLE>login_</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=GB2312">
<style>
   th{
       font-size:12px;
       text-align:right;
       font-weight:normal;
   }
   td{
       font-size:12px;
       text-align:left;
   }
   input{
       width:100px;
       font-size:12px;
       border:solid 1px lightblue;
   }
</style>
<script type="text/javascript">
   function checkTable()
   {
       var name=document.myform.userName.value;
       var pwd=document.myform.passWord.value;
       if(name==null)
       {
          alert("用户名不可以为空");
          return false；
       }
       if(pwd==null)
       {
          alert("密码不可以为空");
          return false；
       }
   return true;
   }
   </script>
</HEAD>
<BODY BGCOLOR=#FFFFFF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 style="text-align:center;padding-top:20px;">
<TABLE WIDTH=800 BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
       <TD COLSPAN=7>
           <IMG SRC="html/images/login/login_01.jpg" WIDTH=800 HEIGHT=71 ALT=""></TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=1 HEIGHT=71 ALT=""></TD>
   </TR>
   <TR>
       <TD COLSPAN=7> 

       </TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=1 HEIGHT=66 ALT=""></TD>
   </TR>
   <TR>
       <TD COLSPAN=7>
           <IMG SRC="html/images/login/login_03.jpg" WIDTH=800 HEIGHT=6 ALT=""></TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=1 HEIGHT=6 ALT=""></TD>
   </TR>
   <TR>

    <TD COLSPAN=3>  </TD>
       <TD COLSPAN=3 ROWSPAN=2>
           <IMG SRC="html/images/login/login_05.jpg" WIDTH=426 HEIGHT=83 ALT=""></TD>

    <TD ROWSPAN=3> </TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=1 HEIGHT=44 ALT=""></TD>
   </TR>
   <TR>

    <TD ROWSPAN=4>  </TD>
       <TD COLSPAN=2>
           <IMG SRC="html/images/login/login_08.jpg" WIDTH=94 HEIGHT=39 ALT=""></TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=1 HEIGHT=39 ALT=""></TD>
   </TR>
   <TR>
       <TD ROWSPAN=3>
           <IMG SRC="html/images/login/login_09.jpg" WIDTH=15 HEIGHT=141 ALT=""></TD>

    <TD COLSPAN=2 ROWSPAN=2 background="html/images/login/login_10.jpg" >
<form action="<%=basePath%>servlet/sys_useControl?code=1" method="post" name="myform" onSubmit="return checkTable()" >
   <table width="100%">
        <tr>
          <th>用户名</th>
          <td><input class="input-text" type="text" name="userName" /></td>
        </tr>
        <tr>
          <th>密码</th>
          <td><input class="input-text" type="password" name="passWord" /></td>
        </tr>
        <tr>
          <td> </td>
          <td><input class="input-btn" type="submit" name="submit" value="登陆" /></td>
        </tr>
      </table>
</form>
    </TD>
       <TD COLSPAN=2>
           <IMG SRC="html/images/login/login_11.jpg" WIDTH=304 HEIGHT=86 ALT=""></TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=1 HEIGHT=86 ALT=""></TD>
   </TR>
   <TR>
       <TD ROWSPAN=2>
           <IMG SRC="html/images/login/login_12.jpg" WIDTH=19 HEIGHT=55 ALT=""></TD>

    <TD COLSPAN=2 ROWSPAN=3>  </TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=1 HEIGHT=28 ALT=""></TD>
   </TR>
   <TR>
       <TD COLSPAN=2>
           <IMG SRC="html/images/login/login_14.jpg" WIDTH=201 HEIGHT=27 ALT=""></TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=1 HEIGHT=27 ALT=""></TD>
   </TR>
   <TR>

    <TD COLSPAN=5>  </TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=1 HEIGHT=67 ALT=""></TD>
   </TR>
   <TR>

    <TD COLSPAN=7 background="html/images/login/login_16.jpg" style="text-align:right;padding-right:25px;">
           © 2012
    </TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=1 HEIGHT=55 ALT=""></TD>
   </TR>
   <TR>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=150 HEIGHT=1 ALT=""></TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=15 HEIGHT=1 ALT=""></TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=79 HEIGHT=1 ALT=""></TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=122 HEIGHT=1 ALT=""></TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=19 HEIGHT=1 ALT=""></TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=285 HEIGHT=1 ALT=""></TD>
       <TD>
           <IMG SRC="html/images/login/spacer.gif" WIDTH=130 HEIGHT=1 ALT=""></TD>
       <TD></TD>
   </TR>
</TABLE>
</BODY>
</HTML>