Struts2实现员工信息管理系统.rar

package com.hnpi.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.hnpi.bean.User; import com.hnpi.dao.UserDao; import com.hnpi.util.DBUtil; public class UserDaoImpl implements UserDao { /** * 查找用户列表 */ public List<User> selectAllUser() { Connection conn = DBUtil.getConn(); PreparedStatement ps = null; ResultSet rs = null; String sql = "select * from user"; List<User> users = new ArrayList<User>(); try { ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { User user = new User(); user.setId(rs.getInt(1)); user.setUsername(rs.getString(2)); user.setPassword(rs.getString(3)); user.setRealname(rs.getString(4)); user.setSex(rs.getString(5)); user.setBirthday(rs.getString(6)); user.setNation(rs.getString(7)); user.setEducation(rs.getString(8)); user.setPost(rs.getString(9)); user.setPhone(rs.getString(10)); user.setAddress(rs.getString(11)); user.setEmail(rs.getString(12)); users.add(user); } } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.closeConn(conn, ps, null); } return users; } /** * 新增用户 */ public boolean addUser(User user) { Connection conn = DBUtil.getConn(); PreparedStatement ps = null; int result = 0; String sql = "insert into user (username,password,realname,sex,birthday,nation,education,post,phone,address,email) values (?,?,?,?,?,?,?,?,?,?,?)"; try { ps = conn.prepareStatement(sql); ps.setString(1, user.getUsername()); ps.setString(2, user.getPassword()); ps.setString(3, user.getRealname()); ps.setString(4, user.getSex()); ps.setString(5, user.getBirthday()); ps.setString(6, user.getNation()); ps.setString(7, user.getEducation()); ps.setString(8, user.getPost()); ps.setString(9, user.getPhone()); ps.setString(10, user.getAddress()); ps.setString(11, user.getEmail()); result = ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.closeConn(conn, ps, null); } if (result > 0) { return true; } else { return false; } } /** * 根据ID查询员工信息 */ public User selectUserById(int id) { Connection conn = DBUtil.getConn(); PreparedStatement ps = null; ResultSet rs = null; String sql = "select * from user where id = ?"; User user = new User(); try { ps = conn.prepareStatement(sql); ps.setInt(1, id); rs = ps.executeQuery(); if (rs.next()) { user.setId(rs.getInt(1)); user.setUsername(rs.getString(2)); user.setPassword(rs.getString(3)); user.setRealname(rs.getString(4)); user.setSex(rs.getString(5)); user.setBirthday(rs.getString(6)); user.setNation(rs.getString(7)); user.setEducation(rs.getString(8)); user.setPost(rs.getString(9)); user.setPhone(rs.getString(10)); user.setAddress(rs.getString(11)); user.setEmail(rs.getString(12)); } } catch (Exception e) { e.printStackTrace(); } finally { DBUtil.closeConn(conn, ps, null); } return user; } /** * 修改员工信息 */ public boolean updateUser(User user) { Connection conn = DBUtil.getConn(); PreparedStatement ps = null; int result = 0; String sql = "update user set username = ?,password = ?,realname = ?,sex = ?,birthday = ?,nation = ?,education = ?,post = ?,phone = ?,address = ?,email = ? where id =?"; try { ps = conn.prepareStatement(sql); ps.setString(1, user.getUsername()); ps.setString(2, user.getPassword()); ps.setString(3, user.getRealname()); ps.setString(4, user.getSex()); ps.setString(5, user.getBirthday()); ps.setString(6, user.getNation()); ps.setString(7, user.getEducation()); ps.setString(8, user.getPost()); ps.setString(9, user.getPhone()); ps.setString(10, user.getAddress()); ps.setString(11, user.getEmail()); ps.setInt(12, user.getId()); result = ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.closeConn(conn, ps, null); } if (result > 0) { return true; } else { return false; } } /** * 删除员工信息 */ public boolean delUser(int id) { Connection conn = DBUtil.getConn(); PreparedStatement ps = null; int result = 0; String sql = "delete from user where id = ?"; try { ps = conn.prepareStatement(sql); ps.setInt(1, id); result = ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); }finally{ DBUtil.closeConn(conn, ps, null); } if(result > 0){ return true; }else{ return false; } } }