JSP+Servlet+JavaBean

package com.login; import java.sql.*; public class UserLoginBean { private Connection con; private ResultSet rs; private Statement stmt; private static final String DRIVER_NAME= "org.gjt.mm.mysql.Driver"; private static final String URL_STR= "jdbc:mysql://localhost/test"; //UserLoginBean构造函数 public UserLoginBean() { try {//加载驱动程序 Class.forName(DRIVER_NAME); //获取数据库连接 con=DriverManager.getConnection( URL_STR,"root","tangtaibin"); } catch (SQLException se) { se.printStackTrace(); } catch (ClassNotFoundException cnfe) { cnfe.printStackTrace(); } } //业务方法 public boolean login(String userName,String passWord) { boolean b=false; try { stmt=con.createStatement(); //SQL语句，通过用户名从数据库中查询到密码 String sql= "SELECT user_pwd FROM userLogin WHERE user_name='" +userName+"'"; rs=stmt.executeQuery(sql); while(rs.next()) { String pwd=rs.getString(1); if(pwd.equals(passWord)) { b=true; } } } catch (SQLException se) { se.printStackTrace(); b=false; } finally { this.close(con,rs,stmt); } return b; } //close方法用于关闭相应资源 public void close(Connection con,ResultSet rs,Statement stmt) { try {//关闭数据库连接 if(con!=null) { con.close(); }//关闭结果集 if(rs!=null) { rs.close(); }//关闭Statement if(stmt!=null) { stmt.close(); } } catch (SQLException se) { se.printStackTrace(); } } }