Mybatis01_使用原生接口开发

最新推荐文章于 2024-09-28 22:50:59 发布

BLUcoding

最新推荐文章于 2024-09-28 22:50:59 发布

阅读量6.7w

点赞数

CC 4.0 BY-SA版权

分类专栏： Mybatis 文章标签： mybatis mysql maven jdbc

本文链接：https://blog.csdn.net/BLU_111/article/details/105965401

Mybatis 专栏收录该内容

14 篇文章

订阅专栏

本文详细介绍如何使用MyBatis框架搭建Java环境，包括Maven项目配置、数据库设置、实体类创建、核心配置文件编写、XML映射文件定义及测试代码实现，最终成功向数据库插入一条记录。

新建 Maven ⼯程，pom.xml

<dependencies>
	<dependency>
 		<groupId>org.mybatis</groupId>
 		<artifactId>mybatis</artifactId>
 		<version>3.4.5</version>
    </dependency>
	<dependency>
 		<groupId>mysql</groupId>
	 	<artifactId>mysql-connector-java</artifactId>
	 	<version>8.0.11</version>
	</dependency>
	<dependency>
		<groupId>org.projectlombok</groupId>
		<artifactId>lombok</artifactId>
		<version>1.18.6</version>
		<scope>provided</scope>
	</dependency>
</dependencies>

<build>
	<resources>
		<resource>
			<directory>src/main/java</directory>
			<includes>
				<include>**/*.xml</include>
			</includes>
		</resource>
		<resource>
			<directory>src/main/resources</directory>
			<includes>
				<include>**/*.xml</include>
			</includes>
		</resource>
	</resources>
</build>

新建数据库

use mybatis;
create table t_account(
 id bigint primary key auto_increment,
 username varchar(11),
 password varchar(11),
 age int
)

新建实体类 Account

package com.blu.entity;

import lombok.AllArgsConstructor;
import lombok.Data;

@Data
@AllArgsConstructor
public class Account {
	private long id;
	private String username;
	private String password;
	private int age;
}

创建 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><!-- 配置MyBatis运⾏环境 -->
	<environments default="development">
		<environment id="development">
			<!-- 配置JDBC事务管理 -->
			<transactionManager type="JDBC"></transactionManager>
			<!-- POOLED配置JDBC数据源连接池 -->
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.cj.jdbc.Driver"></property>
				<property name="url"
					value="jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&amp;useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf-8"></property>
				<property name="username" value="root"></property>
				<property name="password" value="123456"></property>
			</dataSource>
		</environment>
	</environments>
	
</configuration>

Account实体类对应的 AccountMapper.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="com.blu.mapper.AccountMapper">
    <insert id="save" parameterType="com.blu.entity.Account">
        insert into t_account(username,password,age) values(#{username},#{password},#{age})
    </insert>
</mapper>

在全局配置⽂件 config.xml 中注册 AccountMapper.xml

<mappers>
		<mapper resource="com/blu/mapper/AccountMapper.xml"></mapper>
</mappers>

使用原⽣接⼝测试

package com.blu.test;

import java.io.InputStream;

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 com.blu.entity.Account;

public class Test {
	public static void main(String[] args) throws Exception {
		// 加载MyBatis配置文件
		String resource = "config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session=sqlSessionFactory.openSession();
		String statement = "com.blu.mapper.AccountMapper.save";
		Account account = new Account(1L, "张三", "123123", 22);
		session.insert(statement,account);
		session.commit();
	}
}