Javaweb完整项目+Layui+Mybatis+增删改查条件模糊查询（源码）Part8之全部页面全部代码(资源)

package servlet; import com.fasterxml.jackson.databind.ObjectMapper; import mapper.CustomerMapper; import org.apache.commons.beanutils.BeanUtils; import org.apache.ibatis.session.SqlSession; import pojo.Customer; import util.BaseServlet; import util.GetSqlSession; import util.ResultData; import util.ToLayuiData; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.lang.reflect.InvocationTargetException; import java.sql.ResultSet; import java.util.List; import java.util.Map; @WebServlet("/customer/*") public class CustomerServlet extends BaseServlet { //更新一条数据 public void updateOne(HttpServletRequest request, HttpServletResponse response) { try { //请求对象直接获取所有的参数名和值 Map<String, String[]> map = request.getParameterMap(); //使用BeanUtils直接进行对象的映射 Customer customer=new Customer(); BeanUtils.populate(customer,map); //获取sqlSession SqlSession sqlSession = GetSqlSession.getSqlSession(); //获取代理对象 CustomerMapper mapper =sqlSession.getMapper(CustomerMapper.class); //执行插入 int i= mapper.update(customer); //sqlSession事务提交 sqlSession.commit(); if (i >0) { System.out.println("更新数据成功"); String success = ResultData.success(); response.getWriter().write(success); }else{ System.out.println("更新数据失败"); String error = ResultData.error(); response.getWriter().write(error); } } catch (IOException e) { e.printStackTrace(); } catch (IllegalAccessException e) { e.printStackTrace(); } catch (InvocationTargetException e) { e.printStackTrace(); } } //删除一条数据 public void deleteOne(HttpServletRequest request, HttpServletResponse response) { try { String id= request.getParameter("uuid"); //获取请求的uuid int uuid = Integer.parseInt(id); //获取sqlSession SqlSession sqlSession = GetSqlSession.getSqlSession(); //获取代理对象 CustomerMapper mapper =sqlSession.getMapper(CustomerMapper.class); //执行插入 int i= mapper.delete(uuid); //sqlSession事务提交 sqlSession.commit(); if (i >0) { System.out.println("删除数据成功"); String success = ResultData.success(); response.getWriter().write(success); }else{ System.out.println("删除数据失败"); String error = ResultData.error(); response.getWriter().write(error); } } catch (IOException e) { e.printStackTrace(); } } //添加一条数据 public void insertOne(HttpServletRequest request, HttpServletResponse response) { try { //请求对象直接获取所有的参数名和值 Map<String, String[]> map = request.getParameterMap(); //使用BeanUtils直接进行对象的映射 Customer customer=new Customer(); BeanUtils.populate(customer,map); System.out.println("新增的对象"+customer); //获取sqlSession SqlSession sqlSession = GetSqlSession.getSqlSession(); //获取代理对象 CustomerMapper mapper =sqlSession.getMapper(CustomerMapper.class); //执行插入 int i= mapper.insertNew(customer); //sqlSession事务提交 // sqlSession.commit(); if (i >0) { System.out.println("新增数据成功"); String success = ResultData.success(); response.getWriter().write(success); }else{ String error = ResultData.error(); response.getWriter().write(error); } } catch (IllegalAccessException e) { e.printStackTrace(); } catch (InvocationTargetException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } public void page(HttpServletRequest request, HttpServletResponse response) { try { //拿到页面传过来的两个参数 page当前页 limit页大小 int page = Integer.parseInt(request.getParameter("page")); int limit = Integer.parseInt(request.getParameter("limit")); //获取代理对象 CustomerMapper mapper = GetSqlSession.getSqlSession().getMapper(CustomerMapper.class); //分页查询 select * from customer limit ?, ? 代表起始下标 页大小 10 // 起始下标=（当前页大小-1）*页大小 List<Customer> customers = mapper.selectPage((page - 1) * limit, limit); //查询总条数 int count = mapper.selectCount(); //将查出来的数据转换为json格式 ObjectMapper objectMapper = new ObjectMapper(); String data = objectMapper.writeValueAsString(customers); System.out.println(data); //code msg count data ToLayuiData layuiData = ToLayuiData.success(0, "成功", count, data); //将这个数据返回给页面进行渲染 response.getWriter().write(layuiData.toString()); System.out.println(layuiData); } catch (IOException e) { e.printStackTrace(); } } public void pageByCondition(HttpServletRequest request, HttpServletResponse response) { try { //拿到页面传过来的两个参数 page当前页 limit页大小 int page = Integer.parseInt(request.getParameter("page")); int limit = Integer.parseInt(request.getParameter("limit")); //拿到用户输入的三个参数 String username = request.getParameter("username"); String nickname = request.getParameter("nickname"); String addr = request.getParameter("addr"); //获取代理对象 CustomerMapper mapper = GetSqlSession.getSqlSession().getMapper(CustomerMapper.class); //分页查询 select * from customer limit ?, ? 代表起始下标 页大小 10 // 起始下标=（当前页大小-1）*页大小 List<Customer> customers = mapper.selectPageByCondition((page - 1) * limit, limit,username,nickname,addr); //查询总条数但是附带条件 int count = mapper.selectCountByCondition(username,nickname,addr); //将查出来的数据转换为json格式 ObjectMapper objectMapper = new ObjectMapper(); String data = objectMapper.writeValueAsString(customers); System.out.println(data); //code msg count data ToLayuiData layuiData = ToLayuiData.success(0, "成功", count, data); //将这个数据返回给页面进行渲染 response.getWriter().write(layuiData.toString()); System.out.println(layuiData); } catch (IOException e) { e.printStackTrace(); } } }