0、综合案例功能介绍

- 以上是在综合案例要实现的功能。除了对数据的增删改查功能之外,还有一些复杂的功能,如批量删除,分页查询,条件查询等功能
- 批量删除功能:每条数据前都有复选框,当我们选中多条数据并点击批量删除按钮后,会发送请求到后端并删除数据库指定的多条数据
- 分页查询功能:当数据库中有很多数据的时候,我们不可能将所有的数据展示在一页里,这个时候就需要分页展示数据
- 条件查询功能:数据库量大的时候,我们需要精确的查询一些想看到的数据,这个时候就需要通过条件查询
1、查询所有功能
1.1、后端实现
1.1.1、dao方法实现
- 在com.coolman.mapper.BrandMapper接口中定义抽象方法,使用@Select注解编写SQL语句
- // 查询所有品牌
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@Select("select * from brand.tb_brand order by ordered")
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>List<Brand> selectAllBrands();
复制代码
- 由于表中有些字段名和实体类中的属性名没有对应,所以要进行相关配置
- 方法1:在SQL语句中取别名
- // 查询所有品牌
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@Select("select id, brand_name as brandName, company_name as companyName, ordered, description, status from brand.tb_brand order by ordered")
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>List<Brand> selectAllBrands();
复制代码
- 方法2:在BrandMapper.xml映射配置文件中定义结果映射,同时在使用注解开发的条件下在Mapper接口中使用ResultMap注解
- <resultMap id="brandResultMap" type="Brand">
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><result property="brandName" column="brand_name" />
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><result property="companyName" column="company_name" />
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings></resultMap>
复制代码- //查询所有品牌
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@Select("select * from brand.tb_brand order by ordered")
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@ResultMap("brandResultMap")
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>List<Brand> selectAllBrands();
复制代码
- 方法3:在MyBatis配置文件中设置并开启驼峰自动命名映射
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>
复制代码
1.1.2、service实现
- // 查询所有品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>public List selectAllBrands() {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>SqlSession sqlSession = MyBatisUtils.getSqlSession();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>List brands = mapper.selectAllBrands();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>sqlSession.close();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>return brands;<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}
复制代码 1.1.3、Servlet实现
1.2、前端实现
- created() {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>axios.get("selectAllBrandsServlet").then( response => {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// window.alert("正在请求数据");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// console.log(response.data);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>this.tableData = response.data;<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>});<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>},
复制代码 2、添加功能
2.1、后端实现
2.1.1、dao方法实现
- // 添加品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@Insert("insert into brand.tb_brand values(null, #{brandName}, #{companyName}, #{ordered}, #{description}, #{status})")<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>void addBrand(Brand brand);
复制代码 2.1.2、service方法实现
- // 添加品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>public void addBrand(Brand brand) {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>SqlSession sqlSession = MyBatisUtils.getSqlSession();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>mapper.addBrand(brand);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>sqlSession.commit();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>sqlSession.close();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}
复制代码 2.1.3、servlet方法实现
- package com.coolman.web.servlet;import com.alibaba.fastjson.JSON;import com.coolman.pojo.Brand;import com.coolman.service.BrandService;import javax.servlet.ServletException;import javax.servlet.ServletInputStream;import javax.servlet.ServletOutputStream;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;import java.io.PrintStream;@WebServlet("/addBrandServlet")public class AddBrandServlet extends HttpServlet {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>doGet(request, response);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 在这里处理请求<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 获取ajax请求返回的json字符串<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 获取请求体中的输入流<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>ServletInputStream inputStream = request.getInputStream();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 调用JSON的api将返回的json字符串转换为实体类对象<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>Brand brand = JSON.parseObject(inputStream, Brand.class);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 调用服务保存信息<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>new BrandService().addBrand(brand);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>response.getWriter().print("ok");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}}
复制代码 2.2、前端实现
3、删除功能
3.1、后端实现
3.1.1、dao层实现
- // 删除品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@Delete("delete from brand.tb_brand where id = #{id}")<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>void deleteBrand(int id);
复制代码 3.1.2、service层实现
- // 删除品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>public void deleteBrand(int id) {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>SqlSession sqlSession = MyBatisUtils.getSqlSession();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>mapper.deleteBrand(id);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>sqlSession.commit();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>sqlSession.close();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}
复制代码 3.1.3、servlet层实现
- package com.coolman.web.servlet;import com.coolman.service.BrandService;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 java.io.IOException;@WebServlet("/deleteBrandServlet")public class DeleteBrandServlet extends HttpServlet {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>doGet(request, response);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 在这里处理请求<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 获取返回的id<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>String idStr = request.getParameter("id");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>int id = Integer.parseInt(idStr);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 调用服务,删除该品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>new BrandService().deleteBrand(id);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 返回成功删除信息<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>response.getWriter().print("ok");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}}
复制代码 3.2、前端实现
- 在Vue对象的method属性中添加deleteBrandById方法,同时在html标签中的点击事件中,传递一个参数回来到方法中
- <resultMap id="brandResultMap" type="Brand">
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><result property="brandName" column="brand_name" />
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><result property="companyName" column="company_name" />
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings></resultMap><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>修改<resultMap id="brandResultMap" type="Brand">
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><result property="brandName" column="brand_name" />
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><result property="companyName" column="company_name" />
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings></resultMap>删除<resultMap id="brandResultMap" type="Brand">
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><result property="brandName" column="brand_name" />
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><result property="companyName" column="company_name" />
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings></resultMap><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>
复制代码
4、修改功能
4.1、后端实现
4.1.1、dao层实现
- // 修改品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 回显功能,根据id查询品牌信息<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@Select("select * from brand.tb_brand where id = #{id}")<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>Brand selectBrandById(int id);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 修改功能<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@Update("update brand.tb_brand set brand_name = #{brandName}, company_name = #{companyName}, ordered = #{ordered}, " +<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>"description = #{description},status = #{status} where id = #{id}")<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>void updateBrandById(Brand brand);
复制代码 4.1.2、service层实现
4.1.3、servlet层实现
4.2、前端实现
5、servlet优化
5.1、背景
- Web层的Servlet个数太多,不利于管理和编写
- 模块的每一个功能都需要定义一个servlet,当模块的数量多时,就很容易造成servlet泛滥。
5.2、解决方法
- 一个模块只定义一个servlet,模块中的每一个功能只需要在servlet中定义对应的方法,如下代码所示
- @WebServlet("/brand/*")public class BrandServlet {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>//查询所有 public void selectAll(...) {}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>//添加数据<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>public void add(...) {}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings> //修改数据<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>public void update(...) {}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>//删除删除<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>public void delete(...) {}}
复制代码 5.3、思路
- 当发送请求至servlet,tomcat会自动调用service()方法,源码如下所示

- 我们一般在自定义的servlet中会重写doGet()和doPost()方法,当我们访问该servlet的时候会根据请求方式将请求分发给doGet()或者doPost()方法
- 那么可以仿照这样的请求分发的思想,在service()方法中根据具体的操作调用对应的方法
- 如:查询所有就调用selectAll()方法,添加企业信息就调用add()方法
5.4、具体实现
- 定义一个通用的servlet类,在定义其他的servlet是不需要继承HttpServlet,而继承我们定义的BaseServlet,在BaseServlet中调用具体servlet(如BrandServlet)中的对应方法,如下所示
- BaseServlet
- public class BaseServlet extends HttpServlet {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@Override<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>//进行请求的分发<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}}
复制代码
- BrandServlet
- @WebServlet("/brand/*")public class BrandServlet extends BaseServlet {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>//用户实现分页查询 public void selectAll(...) {}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings> //添加企业信息<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>public void add(...) {}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>//修改企业信息<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>public void update(...) {}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>//删除企业信息<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>public void delete(...) {}}
复制代码
- 那么如何在BaseServlet中调用对应的方法,进行请求分发呢?
- 可以规定在发送请求的时候,请求资源的二级路径(/brandServlet/selectAll)和需要调用的方法名相同,如下所示
- 查询所有数据的路径以后就需要写成: http://localhost:8080/brand-case/brandServlet/selectAll
- 添加数据的路径以后就需要写成: http://localhost:8080/brand-case/brandServlet/add
- 修改数据的路径以后就需要写成: http://localhost:8080/brand-case/brandServlet/update
- 删除数据的路径以后就需要写成: http://localhost:8080/brand-case/brandServlet/delete
- 或者给在路径中添加一个参数,值为对应的方法名称,如下所示
- 查询所有数据的路径以后就需要写成: http://localhost:8080/brand-case/brandServlet?action=selectAll
- ...
- 这样的话,在BaseServlet中就需要获取到资源的二级路径作为方法名或者路径中的action参数的值,然后调用该方法
5.4.1、后端代码
- BaseServlet
- package com.coolman.web.servlet;import cn.hutool.core.util.StrUtil;import com.coolman.web.servlet.BrandServlet;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 java.io.IOException;import java.lang.reflect.InvocationTargetException;import java.lang.reflect.Method;public class BaseServlet extends HttpServlet {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@Override<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// tomcat中的servlet每次被调用都会执行service方法<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 在这里分发请求<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 1. 获取方法名称<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 1.1 如果请求的URL格式为 .../brandServlet?action=selectAll<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 那么获取方法名称则要简单很多//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>String methodName = request.getParameter("action");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings> // 但是在前端的ajax请求中就需要多写一些单词<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 1.2 如果请求的URL格式为 .../brandServlet/selectAll<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 使用工具类,获取到最后一个'/'号后面的字符串<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 1.2.1 获取请求的URI<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>String requestURI = request.getRequestURI();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 1.2.2 使用工具类,获取到最后一个'/'号后面的字符串<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>String methodName = StrUtil.subAfter(requestURI, "/", true);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 2. 获取方法名称后调用方法<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 方式1://<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>if ("selectAll".equals(methodName)) {//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>selectAll(request, response);//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>} else if ("add".equals(methodName)) {//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>add(request, response);//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>} else if ("delete".equals(methodName)) {//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>delete(request, response);//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>} else if ("update".equals(methodName)) {//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>update(request, response);//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>} //else if ...<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 方式2: 方式1在当功能多的时候就会显地条件判断很冗余<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>可以利用反射的方法,获取到方法,然后调用对应的方法即可<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>try {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>Method method = this.getClass().getDeclaredMethod(methodName, HttpServletRequest.class, HttpServletResponse.class);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 再让方法对象执行<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 暴力反射获取字节码对象的时候需要去除权限(在同一个包下,protected是可以访问的)//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>method.setAccessible(true);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>method.invoke(this, request, response);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>} catch (Exception e) {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>e.printStackTrace();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>catch (NoSuchMethodException | IllegalAccessException | InvocationTargetException e) {//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>e.printStackTrace();//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}}
复制代码
- BrandServlet
- package com.coolman.web.servlet;import com.alibaba.fastjson.JSON;import com.coolman.pojo.Brand;import com.coolman.service.BrandService;import javax.servlet.ServletException;import javax.servlet.ServletInputStream;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;import java.util.List;@WebServlet("/brand/*") // 不带action//@WebServlet("/brand") // 带actionpublic class BrandServlet extends BaseServlet {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 查询所有品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void selectAll(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 调用服务,查询所有<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>List brands = new BrandService().selectAllBrands();//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>System.out.println(brands);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 将List对象转换为JSON字符串,传递给前端<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>String brandsJson = JSON.toJSONString(brands);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 解决中文乱码问题,声明字符串为JSON字符串<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>response.setContentType("application/json;charset=utf-8");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 返回JSON字符串<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>response.getWriter().print(brandsJson);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 添加品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 获取ajax请求返回的json字符串<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 获取请求体中的输入流<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>ServletInputStream inputStream = request.getInputStream();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 调用JSON的api将返回的json字符串转换为实体类对象<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>Brand brand = JSON.parseObject(inputStream, Brand.class);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 调用服务保存信息<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>new BrandService().addBrand(brand);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>response.getWriter().print("ok");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 删除品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 获取返回的id<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>String idStr = request.getParameter("id");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>int id = Integer.parseInt(idStr);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 调用服务,删除该品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>new BrandService().deleteBrand(id);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 返回成功删除信息<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>response.getWriter().print("ok");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 根据id查询品牌<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void selectBrandById(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 接收前端返回的id<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>String idStr = request.getParameter("id");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>int id = Integer.parseInt(idStr);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 调用服务,查询品牌信息<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>Brand brand = new BrandService().selectBrandById(id);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 将Java对象转换成json数据,返回给前端<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>String jsonString = JSON.toJSONString(brand);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 向前端声明返回的数据是json数据,同时更改编码格式防止编码错误<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>response.setContentType("application/json;charset=utf-8");//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>System.out.println(jsonString);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>response.getWriter().print(jsonString);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 修改品牌信息<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 接收前端返回的json数据<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 得到输入流<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>ServletInputStream inputStream = request.getInputStream();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 待用JSON的API转换成JAVA对象<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>Brand brand = JSON.parseObject(inputStream, Brand.class);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 调用服务,修改数据<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>new BrandService().updateBrandById(brand);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 返回修改成功信息给前端<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>response.getWriter().print("ok");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}}
复制代码
注意事项
- BaseServlet和BrandServlet要放在同一个包下,否则因为BrandServlet中的方法全都是protected修饰的方法,必须要设置取出权限才可调用
- method.setAccessible(true);
7、批量删除
7.1、后端实现
7.1.1、dao层实现
- BrandMapper.java
- // 批量删除<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>void deleteByIds(@Param("ids") int[] ids);
复制代码
- BrandMapper.xml
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>delete from brand.tb_brand where id in<resultMap id="brandResultMap" type="Brand">
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><result property="brandName" column="brand_name" />
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><result property="companyName" column="company_name" />
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings></resultMap>#{id}<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>
复制代码
7.1.2、service层实现
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 批量删除功能<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>public void deleteByIds(int[] ids) {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>SqlSession sqlSession = MyBatisUtils.getSqlSession(true);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>mapper.deleteByIds(ids);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>sqlSession.close();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}
复制代码 7.1.3、web层servlet实现
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 批量删除<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>protected void deleteByIds(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 接收前端返回的id数组<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>ServletInputStream inputStream = request.getInputStream();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>int[] ids = JSON.parseObject(inputStream, int[].class);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 调用服务<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>new BrandService().deleteByIds(ids);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 返回成功信息<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>response.getWriter().print("ok");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}
复制代码 7.2、前端实现
8、分页查询
8.1、后端实现
8.1.1、dao层实现
- // 分页查询<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>//select * from ... limit 起始索引, 每页条数//<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>select * from tb_brand limit 0, 5;<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 第一页////<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>select * from tb_brand limit 5, 5;<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 第二页////<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>select * from tb_brand limit 10, 5; // 第三页<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>//select * from ... limit (起始索引 - 1) * 每页条数, 每页条数<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@Select("select * from brand.tb_brand limit #{currentPage}, #{pageSize}")<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>List selectBrandByPage(@Param("currentPage") int currentPage, @Param("pageSize") int pageSize);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 页码左边需要的总条数<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>@Select("select count(*) from brand.tb_brand")<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>Integer selectSumCount();
复制代码 8.1.2、service层实现
- <settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 分页功能<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>public PageBean selectBrandByPage(int currentPage, int pageSize) {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>//select * from ... limit (起始索引 - 1) * 每页条数, 每页条数<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>currentPage = (currentPage - 1) * pageSize;<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>SqlSession sqlSession = MyBatisUtils.getSqlSession();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>List brands = mapper.selectBrandByPage(currentPage, pageSize);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>int totalCount = mapper.selectSumCount();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>sqlSession.close();<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>return new PageBean(totalCount, brands);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}
复制代码 8.1.3、web层servlet实现
8.2、前端实现
- created()函数
- created() {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>axios.get("brand/selectBrandByPage?currentPage=" + this.currentPage + "&pageSize=" + this.pageSize).then( response => {<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// window.alert("正在请求数据");<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// console.log(response.data);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>this.totalCount = response.data.totalCount;<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>this.tableData = response.data.list;<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>});<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>}
复制代码
- handleSizeChange(val)函数(每一页的数据量)
- handleCurrentChange(val)函数(当前页码)
9、条件查询
9.1、后端实现
9.1.1、dao层实现
- Mapper接口
- // 多条件查询<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>List selectBrandByCondition(@Param("brand") Brand brand, @Param("currentPage") int currentPage, @Param("pageSize") int pageSize);<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>// 查询结果记录数<settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings><settings>
- <setting name="mapUnderscoreToCamelCase" value="true"/>
- </settings>int selectSearchCount(Brand brand);
复制代码
- Mapper映射文件
9.1.2、service层实现
9.1.3、web层servlet实现
9.2、前端实现
免责声明:如果侵犯了您的权益,请联系站长,我们会及时删除侵权内容,谢谢合作! |