学习目标
- (1)按分类显示路线数据
- (2)按详情显示路线
- (3)后台最核心的还是业务方法与sql
- (4)前台最核心的是$(“#”) 拼接 html()函数修改内容
分类与分页的分析
分类与分页的后台代码
RouteServiceTest
@Test
public void test02() throws JsonProcessingException {
RouteService routeService = new RouteService();
PageBean pb = routeService.findPageByCid(1,1,20);
ResponseInfo responseInfo = new ResponseInfo();
responseInfo.setCode(200);
responseInfo.setData(pb);
String json = new ObjectMapper().writeValueAsString(responseInfo);
System.out.println(json);
}
RouteService
public PageBean findPageByCid(int cid, int currentPage, int pageSize) {
PageBean pb = new PageBean();
pb.setCurrentPage(currentPage);
pb.setPageSize(pageSize);
RouteDao routeDao = MySessionUtils2.getMapper(RouteDao.class);
int totalCount = routeDao.findCountByCid(cid);
pb.setTotalCount(totalCount);
int totalPage = totalCount % pageSize == 0 ? totalCount / pageSize : totalCount / pageSize + 1;
pb.setTotalPage(totalPage);
int start = (currentPage - 1) * pageSize;
List<Route> list = routeDao.findPageByCid(cid, start, pageSize);
pb.setList(list);
return pb;
}
RouteDao
int findCountByCid(int cid);
List<Route> findPageByCid(int cid, int start, int pageSize);
<select id="findCountByCid" parameterType="int" resultType="int">
select count(*) from tab_route where cid = #{cid};
</select>
<select id="findPageByCid" resultType="route">
select * from tab_route where cid = #{arg0} limit #{arg1},#{arg2};
</select>
Route2Servlet
@WebServlet("/route2Servlet")
public class Route2Servlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String cidStr = request.getParameter("cid");
String currentPageStr = request.getParameter("currentPage");
String pageSizeStr = request.getParameter("pageSize");
int cid = 0;
try {
cid = Integer.parseInt(cidStr);
} catch (NumberFormatException e) {
e.printStackTrace();
}
int currentPage = 1;
try {
currentPage = Integer.parseInt(currentPageStr);
} catch (NumberFormatException e) {
e.printStackTrace();
}
int pageSize = 20 ;
try {
pageSize = Integer.parseInt(pageSizeStr);
} catch (NumberFormatException e) {
e.printStackTrace();
}
RouteService routeService = new RouteService();
PageBean pb = routeService.findPageByCid(cid,currentPage,pageSize);
ResponseInfo responseInfo = new ResponseInfo();
responseInfo.setCode(200);
responseInfo.setData(pb);
String json = new ObjectMapper().writeValueAsString(responseInfo);
response.getWriter().println(json);
}
}