1.在mapper.xml写好sql语句
<mapper namespace="cn.itsource._01mapper.TeacherMapper">
<!--查询所有数据-->
<select id="findAll" resultType="Teacher">
select * from t_tea
</select>
</mapper>
3.sqlSession的工具类(使用枚举)
public enum MybatisUtil {
//枚举
INSTANCE;
private static SqlSessionFactory sqlSessionFactory;
static {
Reader reader =null;
try {
//与数据库建立联系,读取配置文件
reader = Resources.getResourceAsReader("Mybatis-Config.xml");
sqlSessionFactory =new SqlSessionFactoryBuilder().build(reader);
} catch (IOException e) {
e.printStackTrace();
System.out.println("配置文件出错!!!"+e.getMessage());
}
}
public SqlSession getSqlSession(){
return sqlSessionFactory.openSession();
}
}
2.写一个测试类进行测试(需要写好一个sqlSession的工具类)
TeacherMapper mapper=sqlSession.getMapper(TeacherMapper.class);
List<Teacher> teachers = mapper.findAll();
for (Teacher teacher : teachers) {
System.out.println(teacher);
}