05 - mybatis - 注解crud

注解方式crud

返回自增值

@Insert("insert into student(username,address) values(#{username},#{address})")
@Options(keyColumn = "id",keyProperty = "id",useGeneratedKeys = true)

注解result设置

@Select("select * from student")
@Results(id = "stuMap",value ={
   @Result(id = true,property = "id",column = "id"),
   @Result(property = "userName",column = "uname")
} )
List<Student> find();

@Select("select * from student where id = 1")
@ResultMap({"stuMap"})
Student findbyid();

注解一对多，多对多

注解一对一

 @Select("select * from student s  where s.id = #{id}")
    @Results({
            @Result(property = "id",column = "id",id = true),
            @Result(property = "name",column = "name"),
            @Result(property = "tid",column = "tid"),
            @Result(property = "teacher" ,javaType = cn.laixueit.pojo.Teacher.class, column = "tid", one = @One(select = "cn.laixueit.mapper.StudentMapper.t"))
    })
    Student onetoone(Integer id);

    @Select("select name tname from teacher where id = #{id}")
    Teacher t(Integer id);

一对多

@Select("select * from student")
@Results(
   id = "studentMap2",
   value = {
       @Result(property = "id",column = "id",id = true),
       @Result(property = "name",column = "name"),
       @Result(property = "address",column = "address"),
       @Result(property = "teachers" ,column = "id",many = @Many(select = "cn.laixueit.mapper.TeacherMapper.findBySid"))
   }
)
public List<Student> findStudentOneToManyTeacher2();

@Select("select * from teacher where sid = #{id}")
public Teacher findBySid(Integer id);