MyBatis学习笔记总结【二】之CRUD(增删改查)

示例----增整体代码

mapper：

void addUser2(Map map);

mapper.xml

    insert into mybatis.user(id, name, pwd) values (#{userId}, #{userName}, #{userPwd});

mapper

public interface UserDao {
    //查询全部用户
    List getUserList();

    //根据ID查用户
    User getUserById(int id);

    //insert一个用户
    void addUser(User user);

    //修改用户
    void updateUser(User user);

    //删除一个用户
    void deleteUser(int id);
}

mapper.xml

    
        select * from mybatis.user;
    

    
        select * from mybatis.user where id = #{id};
    

    
        insert into mybatis.user(id, name, pwd) values (#{id}, #{name}, #{pwd});
    

    
        update mybatis.user set pwd = #{pwd}, name = #{name} where id = #{id};
    

    
        delete from mybatis.user where id = #{id};