Mybatis01使用原生接口开发javaBLU111的博客-

• 新建 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 int 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" "https://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" "https://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(); } } 

• 运行结果：数据库新增了一条记录