总体框架
导包
< dependency>
< groupId> org.mybatis</ groupId>
< artifactId> mybatis</ artifactId>
< version> 3.5.6</ 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 = " com.mysql.jdbc.Driver" />
< property name = " url" value = " jdbc:mysql://localhost:3306/mybatis?useSSL=true& useUnicode=true& characterEncoding=utf8" />
< property name = " username" value = " root" />
< property name = " password" value = " 123" />
</ dataSource>
</ environment>
</ environments>
< mappers>
< mapper resource = " com/tl/dao/UserMapper.xml" />
</ mappers>
</ configuration>
工具类
package com. tl. utils;
import org. apache. ibatis. io. Resources;
import org. apache. ibatis. session. SqlSession;
import org. apache. ibatis. session. SqlSessionFactory;
import org. apache. ibatis. session. SqlSessionFactoryBuilder;
import java. io. IOException;
import java. io. InputStream;
public class MybatisUtils {
private static SqlSessionFactory sqlSessionFactory;
static {
String resource = "Mybatis-config.xml" ;
{
try {
InputStream inputStream = Resources. getResourceAsStream ( resource) ;
sqlSessionFactory =
new SqlSessionFactoryBuilder ( ) . build ( inputStream) ;
} catch ( IOException e) {
e. printStackTrace ( ) ;
}
}
}
public static SqlSession getSqlSession ( ) {
return sqlSessionFactory. openSession ( ) ;
}
}
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.tl.dao.UserDao" >
< select id = " getUserList" resultType = " com.tl.pojo.User" >
select * from user
</ select>
</ mapper>
Dao层接口
package com. tl. dao;
import com. tl. pojo. User;
import java. util. List;
public interface UserDao {
List< User> getUserList ( ) ;
}
Junit单元测试
package com. tl. test;
import com. tl. dao. UserDao;
import com. tl. pojo. User;
import com. tl. utils. MybatisUtils;
import org. apache. ibatis. session. SqlSession;
import org. junit. Test;
import java. util. List;
public class UserDaoTest {
@Test
public void Test ( ) {
SqlSession sqlSession = MybatisUtils. getSqlSession ( ) ;
UserDao userDao = sqlSession. getMapper ( UserDao. class ) ;
List< User> userList = userDao. getUserList ( ) ;
for ( User user : userList) {
System. out. println ( user) ;
}
}
}