“IUserDao”
User selectById(int id);
void update(User user);
“IUserService”
User selectById(int id);
void update(User user);
“UserService”
@Override
public User selectById(int id) {
return userDao.selectById(id);
}
@Override
public void update(User user) {
userDao.update(user);
}
“UserController”
@RequestMapping("toupdate.do")
public ModelAndView toUpdate(int id){
User user=userService.selectById(id);
ModelAndView mv=new ModelAndView();
mv.addObject("user",user);
mv.setViewName("updateUser.jsp");
return mv;
}
@RequestMapping("update.do")
public String toUpdate(User user){
userService.update(user);
return "redirect:/findAll.do";
}
“UserMapper.xml”
<select id="selectById" parameterType="int" resultType="user">
select * from tb_user where id=#{id}
</select>
<update id="update" parameterType="com.zhongruan.bean.User">
update tb_user set username=#{username},password=#{password} where id=#{id}
</update>
</mapper>
在“applicationContext.xml”的第二个“<bean></bean>”
代码块中添加代码
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageInterceptor">
<property name="properties">
<props>
<prop key="helperDialect"></prop>
<prop key="reasonable">true</prop>
</props>
</property>
</bean>
</array>
</property>
“allUser.jsp”修改“修改”相关语句
<a class="btn btn-primary" href="/toupdate.do?id=${user.id}">修改</a>
“updateUser.jsp”修改“修改”相关语句
<form action="/update.do" method="post">
<input type="hidden" name="id" value="${user.id}"><br><br><br>
新的用户姓名:<input type="text" name="username" value="${user.username}"><br><br><br>
新的用户密码:<input type="text" name="password" value="${user.password}"><br><br><br>
<input type="submit" value="修改" >
</form>
分页
修改“UserController”中的"/findAll.do"块代码
@RequestMapping("/findAll.do")
public ModelAndView findAll(@RequestParam(defaultValue = "1") int pageNum,@RequestParam(defaultValue = "5") int size){
PageInfo<User> pageInfo=new PageInfo<>(userService.findAll(pageNum,size));
ModelAndView modelAndView=new ModelAndView();
modelAndView.setViewName("allUser.jsp");
modelAndView.addObject("pageInfo",pageInfo);
return modelAndView;
}
“allUser.jsp”分页代码修改为
<div align="center">
<a href="/findAll.do?pageNum=1&size=5">首页</a>
<a href="/findAll.do?pageNum=${pageInfo.pageNum-1}&size=5">上一页</a>
<c:forEach begin="1" end="${pageInfo.pages}" var="i">
<a href="/findAll.do?pageNum=${i}&size=5">${i}</a>
</c:forEach>
<a href="/findAll.do?pageNum=${pageInfo.pageNum+1}&size=5">下一页</a>
<a href="/findAll.do?pageNum=${pageInfo.pages}&size=5">尾页</a>
</div>