主程序配置:
SqlMapConfig.xml:
<?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">
<!--mybatis主配置文件-->
<configuration>
<!--配置环境-->
<environments default="mysql">
<environment id="mysql">
<!--配置事务类型-->
<transactionManager type="JDBC"></transactionManager>
<!--配置数据源(连接池)-->
<dataSource type="POOLED">
<!--配置连接数据库的4个基本信息-->
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/test3"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<!--指定映射配置文件的位置,映射配置文件指的是每个dao独立的配置文件-->
<mappers>
<mapper resource="com/wance/model/Dao/UserDao.xml"/>
</mappers>
</configuration>
映射文件配置:
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为UserDao的路径-->
<mapper namespace="com.wance.model.Dao.UserDao">
<!--配置查询所有信息-->
<!--id为方法的名称-->
<select id="findAll" resultType="com.wance.model.entity.User">
select * from user;
</select>
</mapper>
建一个数据库user:
建立实体类(注意实体类字段名要和数据库字段名相同):
User.java:
package com.wance.model.entity;
import java.io.Serializable;
import java.util.Date;
public class User implements Serializable {
private int id;
private String username;
private Date birthday;
private String sex;
private String address;
public User() {
}
public User(int id, String username, Date birthday, String sex, String address) {
this.id = id;
this.username = username;
this.birthday = birthday;
this.sex = sex;
this.address = address;
}
public int getId() {
return id;
}
public void setId(int 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 + '\'' +
'}';
}
}
建立UserDao类:
public interface UserDao {
//查询所有信息
List<User> findAll();
}
编写测试类:
public class MybatisTest {
@Test
public void test() throws IOException {
//1 读取配置文件
InputStream in= Resources.getResourceAsStream("SqlMapConfig.xml");
//2 创建SqlSessionFactory工厂
SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
SqlSessionFactory factory=builder.build(in);
//3 使用工厂生产SqlSession对象
SqlSession session=factory.openSession();
//4 使用SqlSession创建Dao接口的代理对象
UserDao userDao=session.getMapper(UserDao.class);
//5 使用代理对象执行方法
List<User> users=userDao.findAll();
for (User user:users){
System.out.println(user);
}
//6 释放资源
session.close();
in.close();
}
}
运行结果:
User{id=1, usrname='king', birthday=Sat Jul 18 00:00:00 CST 2020, sex='man', address='江西'}