Mybatis使用注解开发

一、使用注解开发

• 注解在接口实现

    @Select( "select * from user" )
    List<User> SelectAllUser();

• 需要在核心配置文件中进行绑定接口

<!--    接口绑定-->
    <mappers>
        <mapper class="com.RXJ.mapper.UserMapper"/>
    </mappers>

• 测试

    @Test
    public void tset(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper( UserMapper.class );
        List<User> users = mapper.SelectAllUser();
        for (User user:users){
            System.out.println(user.toString());
        }
        sqlSession.close();
    }

增加用户

• 接口

//增加用户
    @Insert( "insert into user(id,name,pd) VALUES(#{id},#{name},#{pd})" )
    int InsertUser(User user);

• 核心配置文件

<!--    接口绑定-->
    <mappers>
        <mapper class="com.RXJ.mapper.UserMapper"/>
    </mappers>

• 测试

    @Test
    public void insertUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper( UserMapper.class );
        User user = new User( 9, "wei", "180" );
        int i = mapper.InsertUser( user );
        sqlSession.commit();
        if (i>0){
            System.out.println("添加成功");
        }else {
            System.out.println("添加失败");
        }
        sqlSession.close();
    }

删除用户

• 接口

    //根据id删除用户
    @Update( "delete from user where id=#{id}" )
    int DeleteUser(int id);

• 核心配置文件

<!--    接口绑定-->
    <mappers>
        <mapper class="com.RXJ.mapper.UserMapper"/>
    </mappers>

• 测试

    @Test
    public void deleteUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper( UserMapper.class );
        int i = mapper.DeleteUser( 9 );
        sqlSession.commit();
        if (i>0){
            System.out.println("删除成功");
        }else {
            System.out.println("删除失败");
        }
        sqlSession.close();
    }

修改用户

• 接口

    //根据id修改用户
    @Update( "update user set name=#{name},pd=#{pd} where id=#{id}" )
    int updateUser(User user);

• 核心配置文件 

<!--    接口绑定-->
    <mappers>
        <mapper class="com.RXJ.mapper.UserMapper"/>
    </mappers>

• 测试

    @Test
    public void uptateUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper( UserMapper.class );
        User user = new User( 6, "dsa", "369" );
        int i = mapper.updateUser( user );
        sqlSession.commit();
        if (i>0){
            System.out.println("修改成功");
        }else {
            System.out.println("修改失败");
        }
        sqlSession.close();
    }

注意：方法存在多个参数，必须加上@Param("xxx")