Mybatis映射 - 使用XML/Annotation实现
查询学生属于哪一个学校。- 使用Mybatis完成两个表的连接查询。
- Pojo类
Student.java(id, name, age, school / setter, getter)
School.java(id, name / setter, getter)
- Mapper.java
StudentMapper.java
package com.java1234.mappers;
import com.java1234.model.Student;
public interface StudentMapper {
public Student findStduentById(int stuId);
}
SchoolMapper.java
package com.java1234.mappers;
import java.util.List;
import com.java1234.model.School;
import com.java1234.model.Student;
public interface SchoolMapper {
public List<Student> findStudents(int schoolid);
}
- Mapper.xml