05 - mybatis - 注解crud

注解方式crud

注解一对一

 @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);