1.目录结构
2.准备工作
首先我们需要添加Mybatis以及数据库连接所需要的依赖:
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.44</version>
</dependency>
因为 idea不会编译src的java目录的xml文件,所以我们需要进行设置,我们在pom文件中添加以下代码即可:
<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
</resources>
<build/>
3.mybatis-config.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">
<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://127.0.0.1:3306/sms?characterEncoding=UTF-8"/>
<property name="username" value="root"/>
<property name="password" value="admin"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="cn/yf/mapper/AdminMapper.xml"/>
</mappers>
</configuration>
上面是对数据库的配置,下面是关于映射的配置。
4.接口和映射文件
AdminMapper
package cn.yf.mapper;
import cn.yf.entity.Admin;
public interface AdminMapper {
Admin queryAdminById(int id);
}
AdminMapper.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="cn.yf.mapper.AdminMapper">
<select id="queryAdminById" resultType="cn.yf.entity.Admin" parameterType="int">
select * from admin where id = #{id}
</select>
</mapper>
这里实施的是:约定大于配置。
我们约定
1.接口的全路径类名为对应映射文件的namespace值
2.映射文件中的id为接口中的方法名,而且返回值,以及参数类型也相互对应。
5.测试
package cn.yf.junit;
import cn.yf.entity.Admin;
import cn.yf.mapper.AdminMapper;
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 org.junit.Test;
import java.io.IOException;
import java.io.InputStream;
public class test1 {
@Test
public void test1() throws IOException {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession session = sqlSessionFactory.openSession();
AdminMapper adminMapper = session.getMapper(AdminMapper.class);
Admin admin = adminMapper.queryAdminById(1);
System.out.println(admin);
}
}
动态代理的方式减少了对配置文件的寻找的复杂程度,我们直接可以通过接口的名字找到相对应的映射文件,调用不同的方法,来执行不同的sql语句。