暑期实习报告（第四天）

今天的学习任务是为用户管理系统添加、分页、更新的实现

添加

mapeer中添加sql语句：

insert into userinfo(username,password) value(#{username},#{password})

controal层：
@RequestMapping(“add.do”)
public String add(UserInfo userInfo){
userinfoService.add(userInfo);
return “redirect:findAll.do”;
}

分页

1.pom.xml中添加依赖：

  <dependency>
  <groupId>com.github.pagehelper</groupId>
  <artifactId>pagehelper</artifactId>
  <version>5.1.2</version>
</dependency>

2.java包的更改：
congtroller层：

       @RequestMapping("findAll.do")
    public ModelAndView findAll(@RequestParam(defaultValue="1") int page,@RequestParam(defaultValue="5") int size){
        List<UserInfo> users=userinfoService.findAll(page,size);
        ModelAndView mv=new ModelAndView();
        PageInfo pageInfo=new PageInfo(users);
        mv.addObject("pageInfo",pageInfo);
        mv.setViewName("user-list");
        return mv;
}

3.user-list.jsp中的更改:

            </div>
		<!-- /.box-body -->
			<div class="box-tools pull-right">
				<ul class="pagination">
					<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=1&size=5" aria-label="Previous">首页</a></li>
					<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageInfo.pageNum-1}&size=5">上一页</a></li>
					<c:forEach begin="1" end="${pageInfo.pages}" var="pageNumber">
						<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageNumber}&size=5">${pageNumber}</a></li>
					</c:forEach>
					<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageInfo.pageNum+1}&size=5">下一页</a></li>
					<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageInfo.pages}&size=5" aria-label="Next">尾页</a></li>
				</ul>

              </div>

更新

controller:
@RequestMapping(“toUpdate.do”)
public ModelAndView toUpdate(int id){
UserInfo userInfo=userinfoService.selectById(id);
ModelAndView mv=new ModelAndView();
mv.addObject(“userInfo”,userInfo);
mv.setViewName(“user-update”);
return mv;
}
@RequestMapping(“update.do”)
public String update(UserInfo userInfo){
userinfoService.update(userInfo);
return"redirect:findAll.do";
}
sql:

select * from userinfo where id=#{id}