SSM 框架实现用户的登录和用户管理的增删改查

SSM 框架实现用户的登录和用户管理的增删改查

UserService

@Override
public Boolean doLogin(UserInfo userInfo){
    UserInfo userInfo1=userDao.doLogin(userInfo);
    if(userInfo1!=null)
    {
        return true;
    }
    else
        return false;
}

@Override
public void save(UserInfo userInfo) {
    userDao.save(userInfo);
}

@Override
public void delete(int id){

    userDao.delete(id);
}

@Override
public void update(UserInfo userInfo)//修改用户
{
    userDao.update(userInfo);
}
@Override
public UserInfo findUserById(int id)//根据id查找用户
{
    UserInfo userInfo = userDao.findUserById(id);
    return userInfo;
}

UserController

 @RequestMapping("login.do")
public ModelAndView doLogin(UserInfo userInfo){
    Boolean flag=userService.doLogin(userInfo);
    ModelAndView modelAndView=new ModelAndView();
    if(flag){
        modelAndView.setViewName("main");
    }
    else
    {
        modelAndView.setViewName("../failer");
    }
    return modelAndView;
}

@RequestMapping("/add.do")
public String add(UserInfo userInfo)
{
    userService.save(userInfo);
    return "redirect:findAll.do";
}

@RequestMapping("/delete.do")
public String delete(int id){
    userService.delete(id);
    return "redirect:findAll.do";
}
@RequestMapping("/update.do")
public ModelAndView update(ModelAndView modelAndView,UserInfo userInfo){
    userService.update(userInfo);
    userInfo=userService.findUserById(userInfo.getId());
    modelAndView.addObject("userInfo",userInfo);
    modelAndView.setViewName("redirect:findAll.do");
    return modelAndView;
}

UserMapper.xml

<select id="doLogin" parameterType="com.zhongruan.bean.UserInfo" resultType="com.zhongruan.bean.UserInfo">
    select * from userinfo where username=#{username} and password=#{password}
    </select>

    <insert id="save" parameterType="UserInfo">
        insert into userinfo (id,username,password) values (#{id},#{username},#{password})
    </insert>

    <delete id="delete" parameterType="UserInfo">
    delete from userinfo where id=#{id}
    </delete>

    <update id="update" parameterType="UserInfo">
    update userinfo set username=#{username},password=#{password} where id=#{id}
</update>
    <select id="findUserById" resultType="com.zhongruan.bean.UserInfo">
    select * from userinfo where id=#{id}
</select>

实现界面如下