关于jsp网上考试系统

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package com.common; import java.sql.*; /** * * @author Administrator */ public class connectUserInfo { String classforname="org.gjt.mm.mysql.Driver"; String url="jdbc:mysql://localhost:3306/exam"; String user="root"; String passwordofDB="root"; public Connection conn=null; ResultSet rs; public Statement stmt;//对象用于执行不带参数的简单sql语句 String page=null; public static String username3; public static String password3; public static String body3; public connectUserInfo() { try{ Class.forName(classforname); conn=DriverManager.getConnection(url,user,passwordofDB); }catch(Exception e) { e.printStackTrace(); } } //注册方法 public void Register(String user1,String nickNM,String pw,String email,String per) throws Exception { //String classforname="org.gjt.mm.mysql.Driver"; //加载mysql数据库驱动 Class.forName("org.gjt.mm.mysql.Driver"); conn=DriverManager.getConnection(url,user,passwordofDB); PreparedStatement psmt; try{ psmt=conn.prepareStatement("insert into userinfo(username,nickname,password,email,permit) values(?,?,?,?,?)"); psmt.setString(1,user1); psmt.setString(2,nickNM); psmt.setString(3,pw); psmt.setString(4,email); psmt.setString(5,per); //更新数据库 psmt.execute(); stmt=(Statement)conn.createStatement(); rs=(ResultSet)stmt.executeQuery("select * from userinfo where username='"+user1+"'"); while(rs.next()) { username3=rs.getString(1); password3=rs.getString(2); body3=rs.getString(3); } }catch(Exception e) { e.printStackTrace(); } } //验证登陆方法 public boolean checkLogin(String user2,String pass2,String body2) { boolean flag=false; try { try{ Class.forName("org.gjt.mm.mysql.Driver"); conn=DriverManager.getConnection(url,user,passwordofDB); }catch(Exception e) { e.printStackTrace(); } stmt=(Statement)conn.createStatement(); //用户名为主键，保持唯一， rs=(ResultSet)stmt.executeQuery("select * from userinfo"); while(rs.next()) { String username1=rs.getString(1); String password1=rs.getString(2); String body1=rs.getString(3); if(username1.equals(user2)&&password1.equals(pass2)&&body1.equals(body2)) { //page="success.jsp"; //System.out.println("-----------"); flag=true; break; } else { flag=false; //break; } //System.out.println(username1); } } catch(SQLException e) { } return flag; } public ResultSet checkLogin2(String user,String ps) { try{ stmt=conn.createStatement(); ResultSet result=stmt.executeQuery("select * from userinfo"); return result; }catch(Exception e) { return null; } } }