MyBatis快速入门代码以及配置

MyBatis快速入门

1. 导入依赖

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.6</version>
</dependency>

<!-- Mysql -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.42</version>
</dependency>
<!-- lombok -->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>1.16.20</version>
    <scope>provided</scope>
</dependency>

2. 建库+表

create database mybatis;
use mybatis;
create table user(
   id varchar(50) PRIMARY key, -- 主键ID
   uname varchar(50),       -- 用户名
   upass varchar(50),	     -- 密码
   createDate datetime         -- 当前时间   
);

3. 创建Mybatis的配置文件
   XML 配置文件中包含了对 MyBatis 系统的核心设置，包含获取数据库连接实例的数据源（DataSource）和决定事务作用域和控制方式的事务管理器（TransactionManager）。

<?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" />
				<property name="username" value="root" />
				<property name="password" value="root" />
			</dataSource>
		</environment>
	</environments>
<!--相关mappers配置文件-->
</configuration>

4. 定义表所对应的实体类

package com.qfjy.bean;
import java.util.Date;
import lombok.Data;
@Data
public class User {
	private String id;
	private String uname;
	private String upass;
	private Date createDate;
}

5.定义pojo对应的sql映射文件

<?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.qfjy.mapper.UserMapper">
  <select id="selectById" resultType="com.qfjy.bean.User">
    select * from User where id = #{id}
  </select>
</mapper>

6.在mybatis文件中引入.xml文件

<!--相关mappers配置文件-->
<mappers >
    <mapper resource="com/qfjy/mapper/UserMapper.xml"/>
</mappers>

7.测试示例

@Test
	public void t1() throws IOException{
		String resource = "mybatis.xml";
		//1 加载 mybatis.xml配置文件
		InputStream inputStream = Resources.getResourceAsStream(resource);
		//2 得到SqlSessionFactory
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
		//3 得到SqlSession
		SqlSession sqlSession=sqlSessionFactory.openSession();
		//4 映射SQL的标识字符串
		String statementId="com.qfjy.mapper.UserMapper.selectById";
		//5业务逻辑进行查询
		User u=sqlSession.selectOne(statementId, "1");
		System.out.println(u);
		//6 关闭资源
		sqlSession.close();
	}

以上就是MyBatis快速入门的代码以及相关的文件配置.