为了防止遗忘mybatis的一些细节点,记录一下
首先我定义了两个实体类,一个是学生,一个是老师
建表时学生tid和老师id进行外键关联
代码如下(为了代码简洁,使用了lombok依赖)
环境搭建
@Data
@NoArgsConstructor
@AllArgsConstructor
//学生类
public class Student {
private Integer id;
private String name;
//因为多个学生对应一个老师,设置一个teacher对应数据库字段tid
private Teacher teacher;
}
@Data
@AllArgsConstructor
@NoArgsConstructor
//老师类
public class Teacher {
private Integer id;
private String name;
}
SqlSession工具类
public class MySqlSession {
private static SqlSessionFactory factory = null;
//获取factory
static{
try {
InputStream inputStream = Resources.getResourceAsStream("mybatis.xml");
factory= new SqlSessionFactoryBuilder().build(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
}
public static SqlSession getSqlSession(){
//获取sqlsession
SqlSession sqlSession = null;
if (factory!=null){
sqlSession=factory.openSession();
}
return sqlSession;