一、导入依赖(maven坐标)
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>x.x.x</version>
</dependency>
二、 创建配置文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<!--每一个mapper都需要在Mapper配置文件中进行驱动注册-->
<mappers>
<mapper resource="org/mybatis/example/BlogMapper.xml"/>
</mappers>
</configuration>
三、获取SqlSession对象
public class MybatisUtils {
private static SqlSessionFactory sqlSessionFactory=null;
static{
String xml="mybatis-config.xml";
InputStream is = null;
try {
is = Resources.getResourceAsStream(xml);
} catch (IOException e) {
e.printStackTrace();
}
sqlSessionFactory=new SqlSessionFactoryBuilder().build(is);
}
public static SqlSession getSqlSession(){
return sqlSessionFactory.openSession(true);
}
}
四、Mapper.xml文件配置
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--绑定接口-->
<mapper namespace="com.dxy.dao.UserMapper">
<!-- 绑定方法名称 返回集合-->
<select id="getUserList" resultType="com.dxy.pojo.User">
select * from mybatis.user
</select>
</mapper>
五、环境测试
@Test //helloworld 查询测试
public void test1(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
/*映射获取UserDao对象*/
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = mapper.getUserList();
for (User user : userList) {
System.out.println(user);
}
sqlSession.close();
}
具体参考Mybatis官网文档进行参考:
Mybatis中文官方文档