mybatis源码分析系列:
- mybatis源码看这一遍就够了(1)| 前言
- mybatis源码看这一遍就够了(2)| getMapper
- mybatis源码看这一遍就够了(3)| Configuration及解析配置文件
- mybatis源码看这一遍就够了(4)| SqlSession.select调用分析
- mybatis源码看这一遍就够了(5)| 与springboot整合
前言这一章主要是为后面分析源码做铺垫,也好回忆下,这篇章将从操作jdbc到操作mybatis的简单demo入手。
在分析mybatis源码前,我们首先先来回忆下jdk提供的sql操作步骤和mybatis的入门例子
准备数据表和数据:
CREATE TABLE `user` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`age` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
一、jdbc中数据库的操作
1.引入pom
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.15</version>
</dependency>
</dependencies>
2.简单入门例子:
public class JdbcTest {
@Test
public void test() throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
Properties pro = new Properties();
pro.setProperty("user","root");
pro.setProperty("password","123456");
Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC",pro);
//Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC","root","123456");
//Statement statement = connection.createStatement();
PreparedStatement statement = connection.prepareStatement("select * from user");
statement.execute();
ResultSet resultSet = statement.getResultSet();
//ResultSet resultSet = statement.executeQuery("select * from user");
while (resultSet.next()){
System.out.println(resultSet.getString("name")+":"+resultSet.getInt("age"));
}
resultSet.close();
statement.close();
connection.close();
}
}
3.结果打印:
以上是我们在jdk下操作数据库的简单操作流程,第一步加载mysql驱动,第二步创建mysql数据库连接,第三步创建Statement,第四步执行sql语句,第五步获取执行结果,第六步关闭所有。
好了下面我们来看看mybatis的入门例子
二、mybatis入门例子
1.引入pom:
<dependencies>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.2</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</dependency>
</dependencies>
2.创建configuration.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/test"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mybatis/UserMapper.xml"/>
</mappers>
</configuration>
3.创建UserMapper.xml,将文件放在我们创建的mybatis目录
<?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.cwh.test.dao.UserDao">
<select id="select" resultType="com.cwh.test.entity.User">
select * from user
</select>
</mapper>
这里的namespace路径对应的是我们UserDao的全名,也就是包名+类名
4.创建UserDao
public interface UserDao {
List<User> select();
}
5.执行操作:
@Test
public void selectUser() throws IOException {
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("configuration.xml"));
SqlSession sqlSession = sqlSessionFactory.openSession();
UserDao mapper = sqlSession.getMapper(UserDao.class);
List<User> users = mapper.select();
System.out.println(users);
}
6.结果打印:
以上是我们在mybatis操作数据库时的操作步骤,第一步new SqlSessionFactoryBuilder();第二步通过SqlSessionFactoryBuilder读取配置文件configuration.xml并创建SqlSessionFactory;第三步用过SqlSessionFactory获取SqlSession;第四步获取代理UserDao;第五步执行sql获取结果。其实这里第四步第五步可以简略如以下操作:
@Test
public void selectUser2() throws IOException {
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("configuration.xml"));
SqlSession sqlSession = sqlSessionFactory.openSession();
List<User> users = sqlSession.selectList("com.cwh.test.dao.UserDao.select");
System.out.println(users);
}
直接sqlSession.selectList("com.cwh.test.dao.UserDao.select");这里对应就是UserMapper.xml的namespace+.id;这样完全就省略创建UserDao;那这两种有什么不同或相同呢?下章mybatis源码看这一遍就够了(2)我们就这个问题来进行分析