MyBatis_注解

MyBatis注解虽然简洁，但是功能有限，在进行较为复杂的开发时不建议使用

壹.为Mapper接口的方法编写注释

public interface UserMapper {
     @Select("select id,name,password as PWD from mybatis.user where id=#{id}")
     User getUserByID(int id);
}

贰.注册Mapper接口

<!--注册mapper 必须置于结尾-->
    <mappers>
        <mapper class="cn.alan.Mapper.UserMapper"/>
    </mappers>

叁.编写测试类

@Test
    public void getUserByID() {
        SqlSession sqlSession = mybatisUtils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

        User user = userMapper.getUserByID(1);
        System.out.println(user);

        sqlSession.close();
    }

运行效果

注：当存在多个参数时，需要为每个参数加上@Parma注解，否则只允许存在一个参数

public interface UserMapper {
     @Select("select id,name,password as PWD from mybatis.user where id=#{id}")
     User getUserByID(@Param("id") int ididid);
}

 此时，选择器#{id}需与注解保持一致，参数名相当于一种"别名"