实习23
继续上一个程序
遇上一个比较增加了
iuserdao
User jd(String zh);
void add(@Param("zh") String zh, @Param("mm")String mm);
void update(@Param("id") int id,@Param("zh")String zh, @Param("mm")String mm);
User findbyid(int id);
usercontroller
@RequestMapping("/findAll.do")
public ModelAndView findAll(int pageNum,int size){
List<User> users=userService.findAll(pageNum, size);
PageInfo<User> pageInfo=new PageInfo<>(users);
ModelAndView modelAndView=new ModelAndView();
modelAndView.setViewName("allUser.jsp");
modelAndView.addObject("pageInfo",pageInfo);
return modelAndView;
}
@RequestMapping("/login.do")
public String login(User user){
Boolean num=userService.login(user.getZh(),user.getMm());
if (num){
return "redirect:/findAll.do?pageNum=1&size=5";
}else {
return "fail.jsp";
}
}
@RequestMapping("/update.do")
public String update(int id,String zh,String mm){
userService.update(id,zh,mm);
return "redirect:/findAll.do?pageNum=1&size=5";
}
@RequestMapping("add.do")
public String add(String zh,String mm){
userService.add(zh, mm);
return "redirect:/findAll.do?pageNum=1&size=5";
}
@RequestMapping("/toupdate.do")
public ModelAndView toupdate(User user){
int id=user.getId();
User users=userService.findbyid(id);
ModelAndView modelAndView=new ModelAndView();
modelAndView.setViewName("upUser.jsp");
modelAndView.addObject("users",users);
return modelAndView;
}
userservice
@Override
public Boolean login(String zh, String mm) {
User user=userDao.jd(zh);
if (user!=null && mm.equals(user.getMm())){
return true;
}else {
return false;
}
}
@Override
public List<User> findAll(int pageNum,int size) {
PageHelper.startPage(pageNum, size);
return userDao.findAll();
}
@Override
public void add(String zh,String mm) {
userDao.add(zh,mm);
}
@Override
public void update(int id,String zh,String mm) {
userDao.update(id,zh,mm);
}
@Override
public User findbyid(int id) {
return userDao.findbyid(id);
}
iuserservice
Boolean login(String zh, String mm);
List<User> findAll(@RequestParam int pageNum,@RequestParam int size);
void add(String zh,String mm);
void update(int id,String zh,String mm);
User findbyid(int id);
usermapper1
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zhongruan.dao.IUserDao">
<select id="findAll" resultType="user">
select * from dr
</select>
<select id="delete" parameterType="int">
delete from dr where id=#{id}
</select>
<select id="add" parameterType="String">
insert into dr(zh,mm) values (#{zh},#{mm})
</select>
<select id="update" parameterType="user">
update dr set zh=#{zh},mm=#{mm} where id=#{id}
</select>
<select id="jd" parameterType="String" resultType="com.zhongruan.bean.User">
select * from dr where zh=#{zh}
</select>
<select id="findbyid" parameterType="int" resultType="com.zhongruan.bean.User">
select * from dr where id=#{id}
</select>
</mapper>