ssm框架中增删改查操作

Day07

ssm基础增删改查操作

这个必须先学会配置基本的ssm环境不会的可以看我或者其他大佬的博客。

不比比了，上代码：

TbUser

public class TbUser {

    private int id;
    private String username;
    private String password;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "TbUser{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

IUserDao

public interface IUserDao {
    List<TbUser> FindAll();

    void insert(TbUser user);

    void delete(Integer id);

    void update(TbUser user);

    TbUser FindOne(Integer id);
}

service

public interface IUserService {
    List<TbUser> FindAll();

    void insert(TbUser user);

    void delete(Integer id);

    void update(TbUser user);

    TbUser FindOne(Integer id);
}

service实现类

@Service  //可以在别的类中调用用@Autowired创建这个类，必须在这个类之前加@Service也就是将Service放入容器中可以调用
public class UserServiceImpl implements IUserService {


    @Autowired
    private IUserDao userDao;

    @Override
    public List<TbUser> FindAll() {
        return userDao.FindAll();
    }

    @Override
    public void insert(TbUser user) {
        userDao.insert(user);
    }

    @Override
    public void delete(Integer id) {
        userDao.delete(id);
    }

    @Override
    public void update(TbUser user) {
        userDao.update(user);
    }

    @Override
    public TbUser FindOne(Integer id) { return userDao.FindOne(id); }
}

controller

@RequestMapping("user")
@Controller  //一定要加，把Controller放入容器中
public class UserController {

    @Autowired
    IUserService userService;

    @RequestMapping("FindAll.do")
    public ModelAndView FindAll(){
        List<TbUser> users = userService.FindAll();
        ModelAndView mv = new ModelAndView();
        mv.addObject("us",users);
        mv.setViewName("allUser");
        return mv;
    }

    @RequestMapping("delete.do")
    public ModelAndView delete(Integer id){

        userService.delete(id);
        return FindAll();
    }

    @RequestMapping("toAddUser.do")
    public ModelAndView toAddUser(){
        ModelAndView mv = new ModelAndView();
        mv.setViewName("addUser");
        return mv;
    }

    @RequestMapping("toUpdate.do")
    public ModelAndView toUpdate(int id){
        TbUser user = userService.FindOne(id);
        ModelAndView mv = new ModelAndView();
        mv.addObject("user",user);
        mv.setViewName("updateUser");
        return mv;
    }

    @RequestMapping("save.do")
    public ModelAndView insert(HttpServletRequest request){
        String username = request.getParameter("username");
        String password = request.getParameter("password");

        TbUser tbUser = new TbUser();
        tbUser.setUsername(username);
        tbUser.setPassword(password);
        userService.insert(tbUser);
        return FindAll();
    }

    @RequestMapping("update.do")
    public ModelAndView update(HttpServletRequest request){
        Integer id = Integer.parseInt(request.getParameter("id"));
        String username = request.getParameter("username");
        String password = request.getParameter("password");

        TbUser tbUser = new TbUser();
        tbUser.setId(id);
        tbUser.setUsername(username);
        tbUser.setPassword(password);
        userService.update(tbUser);
        return FindAll();
    }
}

rescurces\mapper\UserMapper.xml

<?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="com.zhongruan.bean.TbUser">
       select * from tb_user
   </select>
    <select id="FindOne" resultType="com.zhongruan.bean.TbUser" parameterType="java.lang.Integer">
       select * from tb_user where id = #{id}
   </select>
    <insert id="insert" parameterType="com.zhongruan.bean.TbUser">
        insert into tb_user(username,password) value(#{username},#{password})
    </insert>
    <delete id="delete" parameterType="java.lang.Integer">
        delete from tb_user where id = #{id}
    </delete>
    <update id="update" parameterType="com.zhongruan.bean.TbUser">
        update tb_user set username = #{username},password = #{password} where id = #{id}
    </update>

</mapper>