mybatis的增删改查

CRUD（增删改查）

1、namespace

namespace包命和接口要一致

2、Select

选择，查询语句；

• id：就是对应的namespace中的方法名

• resultType

• parameterType //参数类型
  

import org.westos.pogo.User;

import java.util.List;

public interface UserMapper {
    //获取全部用户
    List<User> getUserList();

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

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

    //修改用户名
    int updateUser(User user);

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

}

    <select id="getUserById" resultType="org.westos.pogo.User" parameterType="int">
       SELECT * FROM mybatis.user where id = #{id}
    </select>

   @Test
    public void getUserById(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        try {
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            User userById = mapper.getUserById(1);
            System.out.println(userById);

        }catch (Exception e){
            e.printStackTrace();

        } finally {
            sqlSession.close();
        }
    }

3、insert

    <insert id="addUser" parameterType="org.westos.pogo.User">
        insert into mybatis.user(id,name,pwd) value (#{id},#{name},#{pwd})
    </insert>

 @Test
    public void addUser() {
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        try {
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            int i = mapper.addUser(new User(4, "刘六", "123456"));
            if (i > 0) {
                System.out.println("插入成功");
                sqlSession.commit();
                //增删改必须提交事务。
            } else {
                System.out.println("插入失败");
            }
        } catch (Exception e) {
            e.printStackTrace();

        } finally {
            sqlSession.close();
        }
    }

4、update

    <update id="updateUser" parameterType="org.westos.pogo.User">
        update mybatis.user set name = #{name} ,pwd =#{pwd} where id=#{id}
    </update>

  @Test
    public void updateuser() {
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        try {
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            int i = mapper.updateUser(new User(4,"哈哈", "1234123"));
            sqlSession.commit();
        } catch (Exception e) {
            e.printStackTrace();

        } finally {
            sqlSession.close();
        }
    }

5、delete

    <delete id="deleteUser" parameterType="org.westos.pogo.User">
        delete from mybatis.user where  id = #{id}
    </delete>

   @Test
    public void deleteUser() {
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        try {
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            int i = mapper.deleteUser(4);
            sqlSession.commit();
        } catch (Exception e) {
            e.printStackTrace();

        } finally {
            sqlSession.close();
        }
    }

}

注意点：

增删改需要提交事务