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");
}
}
}