1.实体类

package com.oa.entity;
public class Users {
	private int id;
	private String uname;
	private String usex;
	private String upword;
	private int dept;
	private int role;
	private String date;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUname() {
		return uname;
	}
	public void setUname(String uname) {
		this.uname = uname;
	}
	public String getUsex() {
		return usex;
	}
	public void setUsex(String usex) {
		this.usex = usex;
	}
	public String getUpword() {
		return upword;
	}
	public void setUpword(String upword) {
		this.upword = upword;
	}
	public int getDept() {
		return dept;
	}
	public void setDept(int dept) {
		this.dept = dept;
	}
	public int getRole() {
		return role;
	}
	public void setRole(int role) {
		this.role = role;
	}
	public String getDate() {
		return date;
	}
	public void setDate(String date) {
		this.date = date;
	}
	
}

2.DAO层

package com.oa.dao;

import java.util.List;

import com.oa.entity.Users;
import com.oa.tool.PageUtil;

public interface UsersDao {

	public List<Users> gets(PageUtil page);
	public int getAllCounts();
	
	public boolean del(int id);
	
	public boolean delu(String ids);
	
	public Users sel(int id);
	
	public boolean add(Users u);
	
	public boolean update(Users u);
}

3.DAOImpl层

package com.oa.daoImpl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.oa.tool.*;
import com.oa.dao.UsersDao;
import com.oa.entity.Dept;
import com.oa.entity.Role;
import com.oa.entity.Users;
import com.oa.tool.C3p0Util;

public class UsersDaoImpl implements UsersDao{
    //查询所有用户信息
	@Override
	public List<Users> gets(PageUtil page) {
		List<Users> users = new ArrayList<>();
		Connection conn=null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String sql = "select * from t_user limit ?,?";
		try{
			conn = C3p0Util.getConnection();
			pstmt=conn.prepareStatement(sql);
			pstmt.setInt(1, page.getBeginRow());
			pstmt.setInt(2, page.getPageSize());
			rs=pstmt.executeQuery();
			while(rs.next()){
				Users user = new Users();
				user.setId(rs.getInt("id"));
				user.setUname(rs.getString("user_name"));
				user.setUsex(rs.getString("user_sex"));
				user.setUpword(rs.getString("user_password"));
				user.setDept(rs.getInt("user_department"));
				user.setRole(rs.getInt("user_role"));
				user.setDate(rs.getString("create_date"));
				
				
				users.add(user);
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			C3p0Util.close(conn, pstmt, rs);
		}
		return users;//集合
	}
	//查询数量，分页设计
	@Override
	public int getAllCounts() {
		Connection conn=null;
		PreparedStatement pst = null;
		ResultSet rs = null;
		int result=0;
		try{
			conn=C3p0Util.getConnection();
			System.out.print("---------------------成功"+conn);
			String sql="select count(*) from t_user";
			pst=conn.prepareStatement(sql);
			rs=pst.executeQuery();
			if(rs.next()){
				result=rs.getInt(1);//参数是列，返回这一列有多少条记录
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			C3p0Util.close(conn, pst, rs);
		}
		return result;
	}
	//查询单个用户信息
	@Override
	public Users sel(int id) {
		Users us=new Users();
		Connection conn=null;
		PreparedStatement pst = null;
		ResultSet rs = null;
		String sql = "select * from t_user where id=?";
		try{
			conn=C3p0Util.getConnection();
			pst=conn.prepareStatement(sql);
			pst.setInt(1, id);
			rs=pst.executeQuery();
			if(rs.next()){
				us.setId(rs.getInt("id"));
				us.setUname(rs.getString("user_name"));
				us.setUsex(rs.getString("user_sex"));
				us.setUpword(rs.getString("user_password"));
				us.setDept(rs.getInt("user_department"));
				us.setRole(rs.getInt("user_role"));
				us.setDate(rs.getString("create_date"));
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			C3p0Util.close(conn, pst, rs);
		}
		return us;
	}
//修改单条用户信息

	@Override
	public boolean update(Users u) {
		Connection conn=null;
		PreparedStatement pst = null;
		ResultSet rs = null;
		boolean result=false;
		String sql="UPDATE t_user SET user_name=?,user_sex=?,user_password=?, user_department=?, user_role=? WHERE id=?";
		try{
			conn=C3p0Util.getConnection();
			pst=conn.prepareStatement(sql);
			pst.setString(1, u.getUname());
			pst.setString(2, u.getUsex());
			pst.setString(3, u.getUpword());
			pst.setInt(4, u.getDept());
			pst.setInt(5, u.getRole());
			pst.setInt(6, u.getId());
			int in=pst.executeUpdate();
			if(in==1){
				result=true;
			}
			
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			C3p0Util.close(conn, pst, rs);
		}
		return result;
	}

//添加用户
	@Override
	public boolean add(Users u) {
		Connection conn=null;
		PreparedStatement pst = null;
		ResultSet rs = null;
		boolean result=false;
		try{
			conn=C3p0Util.getConnection();
			String sql="INSERT into t_user(user_name,user_sex,user_password,user_department,user_role,create_date) VALUES(?,?,?,?,?,?)";
		pst=conn.prepareStatement(sql);
		pst.setString(1, u.getUname());
		pst.setString(2, u.getUsex());
		pst.setString(3, u.getUpword());
		pst.setInt(4, u.getDept());
		pst.setInt(5, u.getRole());
		pst.setString(6, u.getDate());
		int add=pst.executeUpdate();
		if(add==1){
			result = true;
		}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			C3p0Util.close(conn, pst, rs);
		}
		return result;
	}
	//删除单个用户
	@Override
	public boolean del(int id) {
		Connection conn=null;
		PreparedStatement pst = null;
		ResultSet rs = null;
		Users us =new Users();
		boolean result=false;
		try{
			conn=C3p0Util.getConnection();
			String sql="delete from t_user where id=?";
			pst=conn.prepareStatement(sql);
			pst.setInt(1, id);
			int res=pst.executeUpdate();
			if(res==1){
				result=true;
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			C3p0Util.close(conn, pst, rs);
		}
		return result;
	}
//删除多条记录
	@Override
	public boolean delu(String ids) {
		Connection conn=null;
		PreparedStatement pst = null;
		ResultSet rs = null;
		Users us =new Users();
		boolean result=false;
		try{
			conn=C3p0Util.getConnection();
			System.out.println(ids+" kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk"); 
			String sql="DELETE FROM t_user WHERE id in ("+ids+")";
			pst = conn.prepareStatement(sql);
			System.out.println(pst+"********");
			int in=pst.executeUpdate();
			if(in>=1){
				result = true;
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			C3p0Util.close(conn, pst, rs);
		}
		return result;
	}
}

4.service层

package com.oa.service;

import java.util.List;

import com.oa.entity.Users;
import com.oa.tool.PageUtil;

public interface UsersService {
  public List<Users> gets(PageUtil page);
  public int getAllCounts();
	
	public boolean del(int id);
	
	public boolean delu(String ids);
	
	public Users sel(int id);
	
	public boolean add(Users u);
	
	public boolean update(Users u);
}

5.ServiceImpl层

package com.oa.serviceImpl;

import java.util.List;
import com.oa.dao.*;
import com.oa.daoImpl.*;
import com.oa.entity.Users;
import com.oa.service.UsersService;
import com.oa.tool.PageUtil;

public class UsersServiceImpl implements UsersService {
	private UsersDao ud = new UsersDaoImpl();

	@Override
	public List<Users> gets(PageUtil page) {
		// TODO Auto-generated method stub
		return ud.gets(page);
	}

	@Override
	public int getAllCounts() {
		// TODO Auto-generated method stub
		return ud.getAllCounts();
	}

	@Override
	public boolean del(int id) {
		// TODO Auto-generated method stub
		return ud.del(id);
	}

	@Override
	public boolean delu(String ids) {
		// TODO Auto-generated method stub
		return ud.delu(ids);
	}

	@Override
	public Users sel(int id) {
		// TODO Auto-generated method stub
		return ud.sel(id);
	}

	@Override
	public boolean add(Users u) {
		// TODO Auto-generated method stub
		return ud.add(u);
	}

	@Override
	public boolean update(Users u) {
		// TODO Auto-generated method stub
		return ud.update(u);
	}
	

}

6.Servlet层

package com.oa.servlet;

import java.io.IOException;
import java.sql.Timestamp;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.oa.entity.Users;
import com.oa.service.UsersService;
import com.oa.serviceImpl.UsersServiceImpl;
import com.oa.tool.PageUtil;

/**
 * Servlet implementation class UsersServlet
 */
@WebServlet("/UsersServlet")
public class UsersServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
	private UsersService us = new UsersServiceImpl();
	protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String info = request.getParameter("users.info");
		//info=2 查询全部用户；info=3删除 ； info=4添加；  info=5查询单条信息； info=6 修改 ; info=7多条删除
		if("2".equals(info)){
			System.out.println("-----doGet--selsUserServlet--查询全部用户-users.info=2------");
			selsUserServlet(request, response); 
		}else if("3".equals(info)){
			System.out.println("-----doGet----删除-users.info=3------");
			delUserServlet(request, response); 
		}else if("4".equals(info)){
			System.out.println("-----doGet--addUserServlet--添加-users.info=4------");
			addUserServlet(request, response); 
		}else if("5".equals(info)){
			System.out.println("-----doGet--selUserServlet--查询单条信息-users.info=5------");
			selUserServlet(request, response); 
		}else if("6".equals(info)){
			System.out.println("-----doGet--updUserServlet--修改-users.info=6------");
			updUserServlet(request, response); 
		}else if("7".equals(info)){
			System.out.println("-----doGet--updsUserServlet--批量删除-users.info=7------");
			delsUserServlet(request, response); 
		}
	}
	//查询所有用户信息
		protected void selsUserServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		PageUtil page =new PageUtil();
		
		//获取当前页数
		String currentPage =request.getParameter("currentPage");
				int currentPageIndex=0;
				if(currentPage!=null){
					currentPageIndex=Integer.parseInt(currentPage);
				}else{
					currentPageIndex=1;
				}
				int totalCount=us.getAllCounts();
				page.setCurrentPage(currentPageIndex);//当前页
				page.setPageSize(5);//每页数目
				page.setTotalCount(totalCount);//总条数
				
				//查询所有用户信息
				List<Users> list = us.gets(page);
				
				//返回数据
				request.setAttribute("PageObj", page);
		
		         request.setAttribute("lists", list);
		       request.getRequestDispatcher("files/yonghuxinxi.jsp").forward(request, response);
		}
		//查询单个用户
		protected void selUserServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	      UsersService us =new UsersServiceImpl();
	      int id =Integer.parseInt(request.getParameter("id"));
	      Users uu =us.sel(id);
			request.setAttribute("edit", uu);
			request.getRequestDispatcher("files/yonghuedit.jsp").forward(request, response); 
		}
		//修改个用户
		protected void updUserServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
			  UsersService us =new UsersServiceImpl();
			  Users user = new Users();
				user.setId(Integer.parseInt(request.getParameter("id")));
				user.setUname(request.getParameter("user_name"));
				user.setUpword(request.getParameter("user_password"));
				user.setUsex(request.getParameter("user_sex"));
				user.setDept(Integer.parseInt(request.getParameter("user_department")));
				user.setRole(Integer.parseInt(request.getParameter("user_role")));
				boolean bool = us.update(user);
				if(bool){
					System.out.println("用户修改成功");  
					response.sendRedirect("UsersServlet?users.info=2"); 
				}
		}
		//添加用户
		protected void addUserServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
			UsersService us =new UsersServiceImpl();
			  Users user = new Users();
			  System.out.println(request.getParameter("user_department")+"9999999999999kkkkkkkkkkkkkk");
				Timestamp timestamp = new Timestamp(System.currentTimeMillis());
				user.setUname(request.getParameter("user_name"));
				user.setUpword(request.getParameter("user_password"));
				user.setUsex(request.getParameter("user_sex"));
				user.setDept(Integer.parseInt(request.getParameter("user_department")));
				user.setRole(Integer.parseInt(request.getParameter("user_role")));
				user.setDate(timestamp.toString());
				
				boolean bool = us.add(user);
				if(bool){
					System.out.println("用户添加成功");  
					response.sendRedirect("UsersServlet?users.info=2"); 
				}
		}
		//删除单条记录
		protected void delUserServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
			int id = Integer.parseInt(request.getParameter("id"));
			UsersService us = new UsersServiceImpl();
			boolean bool = us.del(id);
			if(bool){
				System.out.println(id+"用户删除成功dddddddddddddddddddddddddddd");
				response.sendRedirect("UsersServlet?users.info=2"); 
			}
		}
		//删除多条记录
		protected void delsUserServlet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
			String id = request.getParameter("ids");
			UsersService us = new UsersServiceImpl();
			boolean bool = us.delu(id);
			if(bool){
				System.out.println("用户删除成功");   
				response.sendRedirect("UsersServlet?users.info=2"); 
			}
		}
		}