JSP+DAO实现登陆模块

package stone.hit.edu.daoImpl; import java.sql.PreparedStatement; import java.sql.ResultSet; import stone.hit.edu.dao.PersonDAO; import stone.hit.edu.db.DataBaseConnection; import stone.hit.edu.vo.Person; public class PersonDAOImple implements PersonDAO { public boolean login(Person person) throws Exception { boolean flag = false; String sql="select name from person where id=? and password=?"; PreparedStatement pstmt = null; DataBaseConnection dbc = new DataBaseConnection(); try { pstmt = dbc.getConn().prepareStatement(sql); pstmt.setString(1, person.getId()); pstmt.setString(2, person.getPassword()); ResultSet rs = pstmt.executeQuery(); if(rs.next()) { flag = true; person.setName(rs.getString(1)); } rs.close(); pstmt.close(); } catch(Exception e) { throw new Exception("操作出现错误"); } finally { dbc.close(); } return flag; } }