0. maven坐标
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.3.0</version>
</dependency>
1. sqlsessionfactorybuilder (构造器) 通过配置信息或代码来生成sqlsessionfactory
2. sqlSessionFactory 工厂接口,来生成sqlSession(会话)
3. sqlSession 负责发送sql和返回结果. 并且读取mapper接口
InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
//sql
SqlSession session = null;
try {
session = factory.openSession();
// ....
session.commit();
} catch (Exception e) {
}finally {
//需要将session关闭,不然连接资源被耗尽,系统瘫痪
session.commit();
}
sqlSession的执行方式
1.可以通过映射器,发送sql并返回结果
session = factory.openSession();
// ....
RoleMapper roleMapper = session.getMapper(RoleMapper.class);
Role role = roleMapper.queryById(1l);
System.out.println(role.getName());
2.通过命名信息去执行sql并返回结果
映射器:
1.由java接口和xml映射文件组成