1.前端效果展示

1.进入之后是一个分页查询所有数据的内容该页面有基础的增删改查还有分页查询批量删除

进行条件查询有什么不对的地方欢迎提出谢谢

2.增删改查

1.添加

添加成功

2.删除将刚才添加的OPPO删除

3.修改

4.查询的话就是主页查询所有页面所用的是分页查询＋查询所有

2.数据库设计

1.使用navicat 或者用idea自带的数据库进行设计即可

2.注意数据库中varchar 设计为utf8

3.后台逻辑

1.后台结构

2.增删改查方法

1.查询所有

protected void findAll(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{List<Brand> brand = brandService.selectAll();String s = JSON.toJSONString(brand);resp.getWriter().write(s);
}

2.修改

protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String line = req.getReader().readLine();Brand brand = JSON.parseObject(line, Brand.class);int row = brandService.update(brand);if(row>0){resp.getWriter().write("true");}else {resp.getWriter().write("false");}
}

3.添加

protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String line = req.getReader().readLine();Brand brand = JSON.parseObject(line, Brand.class);int row = brandService.insert(brand);if(row>0){resp.getWriter().write("true");}else {resp.getWriter().write("false");}
}

4.删除

protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String id=req.getParameter("id");int row = brandService.deleteBrand(Integer.parseInt(id));if(row>0){resp.getWriter().write("true");}else {resp.getWriter().write("false");}}

5.批量删除从前端获得要删除的id数组在进行对id数组的查询去进行删除

protected void deleteById(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String s = req.getReader().readLine();int[] ints = JSON.parseObject(s, int[].class);int row = brandService.delete(ints);//响应删除成功的标识if(row>0){resp.getWriter().write("true");}else {resp.getWriter().write("false");}
}

6.分页查询

protected void findByPage(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {Integer currentPage = Integer.parseInt(req.getParameter("currentPage"));Integer pageSize = Integer.parseInt(req.getParameter("pageSize"));PageInfo<Brand> pb = brandService.selectByPage(currentPage, pageSize);String s = JSON.toJSONString(pb);resp.getWriter().write(s);}

7.分页查询带条件查询

protected void findByPageAndCondition(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {Integer currentPage = Integer.parseInt(req.getParameter("currentPage"));Integer pageSize = Integer.parseInt(req.getParameter("pageSize"));String line = req.getReader().readLine();Brand brand = JSON.parseObject(line, Brand.class);PageInfo<Brand> pb = brandService.findByPageCondition(currentPage, pageSize,brand);String s = JSON.toJSONString(pb);resp.getWriter().write(s);
}