能够使用注解方式配置：
（1）基本表CRUD操作
（2）一对一、一对多、多对多表关系
（3）动态SQL
（一）注解-CRUD
使用注解的编写方式主要讲工作量从XML文件到接口方法对应的注释上来
MyBatis中的注解开发基于接口，和XML文件一样，首先要注册这个接口
- 在mybatis-config.xml中注册接口
<!--持久化类的映射文件-->
<mappers>
<mapper class="com.mio4.mapper.UserMapper"/>
</mappers>
- 接口方法配置注解
public interface UserMapper {
@Insert("INSERT INTO TB_USER(name,age,sex) VALUES (#{name},#{age},#{sex})")
@Options(useGeneratedKeys = true,keyProperty = "id")
int saveUser(User user);
@Delete("DELETE FROM TB_USER WHERE id = #{id}")
int removeUser(@Param("id") Integer id);
@Update("UPDATE TB_USER SET name = #{name},sex = #{sex}, age = #{age} WHERE id = #{id}")
void modifyUser(User user);
@Select("SELECT * FROM TB_USER WHERE id = #{id}")
@Results({
@Result(id = true, property = "id", column = "id"),
@Result(property = "name", column = "name"),
@Result(property = "sex", column = "sex"),
@Result(property = "age",column = "age")
})
User selectUserById(Integer id);
@Select("SELECT * FROM TB_USER")
List<User> selectAllUser();
}
- 基于Junit测试
@Test
public void testInsert(){
SqlSession sqlSession = mySqlSessionFactory.getSqlSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = new User();
user.setName("test");
user.setSex("male");
user.setAge(30);
userMapper.saveUser(user);
sqlSession.commit();
sqlSession.close();
}