新闻发布系统（java web ）

package DAO; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.Collection; import java.util.List; import bean.adminbean; import bean.userbean; public class userdao implements DAO{ public static boolean isExist(userbean bean) throws ClassNotFoundException, IllegalAccessException, InstantiationException{ boolean existence = false; try{ databasedao database=new databasedao(); Connection conn =database.getConn(); String strsql = "select * from t_user where F_USERNAME=? AND F_PASSWORD=?"; List<Object> list = new ArrayList<Object>() ; list.add(bean.getUSERID()); list.add(bean.getPASSWORD()); ResultSet RS =database.executePstmtQuery(strsql,list); if(RS.next()){ existence = true; } database.closeConn(); }catch (SQLException e){ // TODO Auto-generated catch block e.printStackTrace(); } return existence; } public static boolean isExistusername(String bean) throws ClassNotFoundException, IllegalAccessException, InstantiationException{ boolean existence = false; try{ databasedao database=new databasedao(); Connection conn =database.getConn(); String strsql = "select * from t_user where F_USERNAME=?"; List<Object> list = new ArrayList<Object>() ; list.add(bean); ResultSet RS =database.executePstmtQuery(strsql,list); if(RS.next()){ existence = true; } database.closeConn(); }catch (SQLException e){ // TODO Auto-generated catch block e.printStackTrace(); } return existence; } public void insert(userbean bean) { try{ databasedao database=new databasedao(); Connection conn =database.getConn(); String strsql="insert into t_user(f_username,f_nickname,f_password,f_email,f_sex) values(?,?,?,?,?)"; PreparedStatement pstmt=conn.prepareStatement(strsql); pstmt.setString(1,bean.getUSERID()); pstmt.setString(2,bean.getNICKNAME()); pstmt.setString(3,bean.getPASSWORD()); pstmt.setString(4,bean.getEMAIL()); pstmt.setString(5,bean.getSEX()); pstmt.executeUpdate(); pstmt.close(); database.closeConn(); }catch (SQLException e){ // TODO Auto-generated catch block e.printStackTrace(); } } public void delete(userbean bean) { try{ databasedao database=new databasedao(); Connection conn =database.getConn(); String strsql="delete from t_user where f_username=?"; PreparedStatement pstmt=conn.prepareStatement(strsql); pstmt.setString(1,bean.getUSERID()); pstmt.executeUpdate(); pstmt.close(); database.closeConn(); }catch (SQLException e){ // TODO Auto-generated catch block e.printStackTrace(); } } public List find(String bean) { ArrayList<userbean> arraylist=new ArrayList<userbean>(); try{ databasedao database=new databasedao(); Connection conn =database.getConn(); //String strsql = "select * from LOGIN where USERNAME=? AND PASSWORD=?"; String strsql = "select * from t_user where f_username=?"; List<Object> list = new ArrayList<Object>() ; list.add(bean); ResultSet RS =database.executePstmtQuery(strsql,list); while (RS.next()) { userbean person=new userbean(); person.setEMAIL(RS.getString("f_email")); person.setNICKNAME(RS.getString("f_nickname")); person.setPASSWORD(RS.getString("f_password")); person.setSEX(RS.getString("f_sex")); person.setUSERID(RS.getString("f_username")); arraylist.add(person); } database.closeConn(); }catch (SQLException e){ e.printStackTrace(); } return arraylist; } public List findall() { ArrayList<userbean> arraylist=new ArrayList<userbean>(); try{ databasedao database=new databasedao(); Connection conn =database.getConn(); String strsql = "select * from t_user"; ResultSet RS =database.executeQuery(strsql); while (RS.next()) { userbean person=new userbean(); person.setEMAIL(RS.getString("f_email")); person.setNICKNAME(RS.getString("f_nickname")); person.setPASSWORD(RS.getString("f_password")); person.setSEX(RS.getString("f_sex")); person.setUSERID(RS.getString("f_username")); arraylist.add(person); } database.closeConn(); }catch (SQLException e){ e.printStackTrace(); } return arraylist; } public List findExcutingSQL(String sql, Object[] sqlParams) { // TODO Auto-generated method stub return null; } public void insert(Object bean) { // TODO Auto-generated method stub } public void update(Object bean) { // TODO Auto-generated method stub } public void delete(Object bean) { // TODO Auto-generated method stub } public List findAll() { // TODO Auto-generated method stub return null; } }