FuXin.zip_2HPT_couplegaj_登录添加显示

package cn.bdqn.dao.impl; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import cn.bdqn.dao.BaseDao; import cn.bdqn.dao.UserDao; import cn.bdqn.entity.User; public class UserDaoImpl extends BaseDao implements UserDao { @Override public User login(String userName, String userPwd) { String sql = "select * from users where userName = ? and userPwd = ?"; Object[] param = {userName,userPwd}; ResultSet rs = super.executeQuery(sql, param); User user = null; try { if(rs.next()){ user = new User(); user.setId(rs.getInt("id")); user.setUserName(rs.getString("userName")); user.setUserPwd(rs.getString("userPwd")); user.setuName(rs.getString("uName")); user.setSex(rs.getString("sex")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ super.closeAll(); } return user; } @Override public List<User> findAll() { // TODO Auto-generated method stub String sql = "select * from users"; ResultSet rs = super.executeQuery(sql); List<User> list = new ArrayList<User>(); try { while(rs.next()){ User user = new User(); user.setId(rs.getInt("id")); user.setUserName(rs.getString("userName")); user.setUserPwd(rs.getString("userPwd")); user.setuName(rs.getString("uName")); user.setSex(rs.getString("sex")); list.add(user); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ super.closeAll(); } return list; } @Override public List<User> findUsersByUserName(String userName,String uName) { String sql = "select * from users where userName like ? and uName like ?"; Object[] param = {"%"+userName+"%","%"+uName+"%"}; ResultSet rs = super.executeQuery(sql,param); List<User> list = new ArrayList<User>(); try { while(rs.next()){ User user = new User(); user.setId(rs.getInt("id")); user.setUserName(rs.getString("userName")); user.setUserPwd(rs.getString("userPwd")); user.setuName(rs.getString("uName")); user.setSex(rs.getString("sex")); list.add(user); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ super.closeAll(); } return list; } @Override public int addUser(User user) { // TODO Auto-generated method stub String sql = "insert into users(userName,userPwd,uName,sex) values(?,?,?,?)"; Object[] param = {user.getUserName(),user.getUserPwd(),user.getuName(),user.getSex()}; return super.executeUpdate(sql, param); } @Override public int del(String id) { // TODO Auto-generated method stub String sql = "delete from users where id = ?"; Object[] param = {id}; return super.executeUpdate(sql, param); } @Override public User findById(String id) { // TODO Auto-generated method stub String sql = "select * from users where id = ?"; Object[] param = {id}; ResultSet rs = super.executeQuery(sql, param); User user = null; try { if(rs.next()){ user = new User(); user.setId(rs.getInt("id")); user.setUserName(rs.getString("userName")); user.setUserPwd(rs.getString("userPwd")); user.setuName(rs.getString("uName")); user.setSex(rs.getString("sex")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ super.closeAll(); } return user; } @Override public int update(User user) { // TODO Auto-generated method stub String sql = "update users set userName = ? , userPwd = ? , uName = ? , sex = ? where id = ? "; Object[] param = {user.getuName(),user.getUserPwd(),user.getuName(),user.getSex(),user.getId()}; return super.executeUpdate(sql, param); } }