MyBatis框架的搭建
在使用Maven的基础上进行MyBatis框架的搭建:
第一步搭建MyBatis 开发环境
1.导入jar包(依赖)
<dependencies>
<!--添加MyBatis框架的jar包坐标-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<!--数据库的驱动jar包-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
<!--引入单元测试的jar-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<!--引入一个日志的jar包-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
</dependencies>
2.在 domain 包下编写实体类:
例如
public class User implements Serializable {
private Integer id;
private String username;
private Date birthday;
private String sex;
private String address;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", birthday=" + birthday +
", sex='" + sex + '\'' +
", address='" + address + '\'' +
'}';
}
}
3.在 dao包下编写UseDao接口
例如:
public interface IUserDao {
//查询所有用户
List<User> findAll();
}
第二步编写持久层接口的映射文件 UserDao.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">
<!--注意namespace值是接口的全路径-->
<mapper namespace="org.westos.dao.IUserDao">
<!--注意id的值是接口中的方法名 resultType 查询返回的结果类型-->
<select id="findAll" resultType="org.westos.domain.User">
select * from user;
</select>
</mapper>
注意:
创建位置:
必须和持久层接口在相同的包中。
名称:
必须以持久层接口名称命名文件名,扩展名是.xml
如我的Dao层叫UserDao,所以xml文件是UserDao.xml
建包的时候要一层一层的建立,不要一口气输入com.xxxx.dao
第三步编写MyBatis的核心配置文件 SqlMapConfig.xml
SqlMapConfig.xml的目的是为了去读取UserDao.xml,以及链接数据库,其位置直接放在resources文件夹下;
<?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="mysql">
<environment id="mysql">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<!--配置数据源的四个基本参数-->
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis_test"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<!--引入dao接口的映射文件-->
<mappers>
<mapper resource="org/westos/dao/IUserDao.xml"></mapper>
</mappers>
</configuration>
测试类Test的编写:
public class TestUserDao {
private SqlSessionFactory factory;
private SqlSession sqlSession;
private InputStream in;
@Before //在@Test注解执行之前调用
public void init() throws IOException {
//读取MyBatis的核心配置文件
in = Resources.getResourceAsStream("SqlMapConfig.xml");
//构建工厂
factory = new SqlSessionFactoryBuilder().build(in);
//打开SqlSession
sqlSession = factory.openSession();
}
//测试的方法可以添加多个
@Test
public void testFindAll() throws IOException {
//获取接口的代理对象
IUserDao userDao = sqlSession.getMapper(IUserDao.class);
//执行查询操作
List<User> list = userDao.findAll();
for (User user : list) {
System.out.println(user);
}
//释放资源
in.close();
sqlSession.close();
}
@After //在@Test执行完之后调用
public void destory() throws IOException {
//释放资源
in.close();
sqlSession.close();
}