SSM基础-完成用户注册，登陆，注销，增删查改，编辑功能

实现注册

//注册方法
 @RequestMapping("/registaction")
 public String Regist(Users user,Model model){
  System.out.println("注册用户："+user.getUsername()+user.getUserpassword());
  usersService.regist(user);
  //model.addAttribute("msg","注册成功");
  return "success"; 
 }

注册service

public void regist(Users user) {
  usersmapper.addUser(user);
 }

注册mapper

void addUser(Users user);

注册mapper.xml

<insert id="addUser">
  insert into tbl_users(username,userpassword)
  values(#{username},#{userpassword})
 </insert>

实现登陆

登陆的JSP

<form action="checkLogin" method="post">
  <table>
  <tr>
   <td>用户名:</td>
   <td><input id="adminname" name="adminname" type="text"/></td>
  </tr>
  <br><br>
  <tr>
   <td>密码:</td>
   <td><input id="adminpassword" name="adminpassword" type="password"/></td>
  </tr>
  <br><br>
  <tr>
   <td><input type="submit" name="submit" value="submit"/></td>
  </tr>
 </table>
 </form>

登陆service

public Users checkLogin(String username,String userpassword){
  
  Users user=usersmapper.checkLogin(username, userpassword);
  if(user!=null&&user.getUserpassword().equals(userpassword)){
   return user;
  }
  return null;
  
 }

登陆mapper

//logincheck 
 Users checkLogin(@Param("username")String username,@Param("userpassword")String userpassword);

登陆 mapper.xml

<select id="checkLogin" resultType="com.mybatis.bean.Users" parameterType="String">
  select * from tbl_users where username=#{username}
 </select>

实现注销

 //注销方法
 @RequestMapping("/outLogin")
 public String OutLogin(HttpSession session){
  //通过session.invalidata()方法来注销当前的session
  session.invalidate();
  return "fail";
 }

实现查找

@RequestMapping("/canyin")
 public String users(Map<String,Object> map ){
  
  List<Users> users=usersService.getUsers();
  map.put("allUsers", users);
  return "list";
 }

查找service

public List<Users> getUsers(){
  return usersmapper.getUsers();
  
 }

查找mapper

public List<Users> getUsers();

查找mapper.xml

<select id="getUsers" resultType="com.mybatis.bean.Users">
  select * from tbl_users
 </select>

实现删除

//删除
 @RequestMapping("/delete")
 public String deleteuser(int userid){
  System.out.println("userid:"+userid);
  usersService.delete(userid);
  return "redirect:/canyin";
 }

删除service

public boolean delete(int userid){
  return usersmapper.delete(userid);
 }

删除mapper

boolean delete(int userid);

删除mapper.xml

<delete id="delete">
  delete from tbl_users where userid=#{userid}
 </delete>

实现更新

//更新
 @RequestMapping("/update")
 public String updateuser(Users user,HttpServletRequest request,Model model){
  System.out.println("userid:"+user.getUserid());
  
  if(usersService.update(user)){
   user=usersService.findById(user.getUserid());
   //System.out.println("username:"+user.getUsername());
   //request.setAttribute("user", user);设置user属性名的值为user
   request.setAttribute("user", user);
   model.addAttribute("user",user);
   return "redirect:/canyin";
  }else{
   return null;
  }

更新service

 public Users findById(int userid){
  //System.out.println("success");
  //System.out.println("userid"+userid);
  Users user=usersmapper.findById(userid);
  return user;
  
 }

更新mapper

Users findById(Integer userid);

更新mapper.xml

<update id="update" >
  update tbl_users set username=#{username},userpassword=#{userpassword} where userid=#{userid}
 </update>

实现编辑

jsp

<form action="update.action" >
 <table>
   <input type="hidden" name="userid" value="${user.userid}"/>
  <tr>
   <td>用户名:</td>
   <td><input id="username" name="username" value="${user.username}"/></td>
  </tr>
  <br><br>
  <tr>
   <td>密码:</td>
   <td><input id="userpassword" name="userpassword" type="password"/></td>
  </tr>
  <br><br>
  <tr>
   <td><input type="submit" name="submit" value="编辑"/></td>
  </tr>
 </table>
 </form>