regok.jsp

JSP 办公系统 eclipse+MYSQL

<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*"%>

<%@ page import="java.text.ParsePosition" %>


<%
String username=request.getParameter("username");
String sex=request.getParameter("sex");
String pass=request.getParameter("pass");
String confirmPassword=request.getParameter("confirmPassword");
String cardNum=request.getParameter("cardNum");
String cardPass=request.getParameter("cardPass");
String id=request.getParameter("id");

Connection con = null;
Statement sm = null;
ResultSet rs = null;
PreparedStatement psm = null;
//调用cardlogin数据库，查找是否存在用户注册的银行卡号和密码时候正确
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
 String url = "jdbc:mysql://localhost/mydb";
  con = DriverManager.getConnection(url,"root","111");
  sm = con.createStatement();
  rs = sm.executeQuery("select * from cardlogin where 身份证号 ='"+id+"'");
  
  if (rs.next())
  {
  if((rs.getString("银行卡卡号").equals(cardNum))&&(rs.getString("银行卡密码").equals(cardPass)))
  {
  //添加用户名和登陆密码到userlogin数据库中
  try
{
  Class.forName("com.mysql.jdbc.Driver").newInstance();
 con = DriverManager.getConnection(url,"root","111");
  psm = con.prepareStatement("insert into userlogin value(?,?)");
  
  psm.setString(1,username);
  
  psm.setString(2,pass);
  
  psm.executeUpdate();
  session.setAttribute("userName",username);
  response.sendRedirect("userlogin.jsp");
    
}
catch(Exception e)
{
response.sendRedirect("reg.jsp");
}
finally
{
if(rs!=null){
try{
rs.close();}
catch(Exception e)
{
e.printStackTrace();}
}
if(psm!=null){
try{
psm.close();}
catch(Exception e)
{
e.printStackTrace();}
}
if(con!=null){
try{
con.close();}
catch(Exception e)
{
e.printStackTrace();}
}
}
  }
  else
  {
  
  %>
  <script> 
  alert("银行卡卡号错误或银行卡密码错误！");
  </script>
  <%  
   }
  }
  else
  {
  %>
  <script>
  alert("用户不存在");
  </script>
  <%;}
  }
  catch(Exception e)
{
e.printStackTrace();
}
finally 
{
if(rs!=null){try{rs.close();}catch(Exception e)
{
e.printStackTrace();
}}
}
if(sm!=null){try{sm.close();}catch(Exception e)
{
e.printStackTrace();
}}

if(con!=null){try{con.close();}catch(Exception e)
{
e.printStackTrace();
}}

  


%>