Mybatis学习笔记&注解/xml映射/动态SQL%%%Mybatis教程

介绍

• Mybatis 是一款优秀的持久层框架，用于简化 JDBC 的开发

MyBatis中文网

Mybatis 入门

快速入门

• 步骤

1. 创建 SpringBoot 工程、数据库表 user、实体类 User
2. 引入 Mybatis 相关依赖，配置 Mybatis（数据库连接信息）
3. 编写 SQL 语句（注解/XML）
   

项目创建

创建的项目的 pom.xml 如下：

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>3.1.4</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.example</groupId>
    <artifactId>demoMybatis</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>demoMybatis</name>
    <description>demoMybatis</description>
    <properties>
        <java.version>17</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>3.0.2</version>
        </dependency>

        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter-test</artifactId>
            <version>3.0.2</version>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

引入了这三个依赖：

数据库表格创建

代码如下：

CREATE DATABASE mybatis;
USE mybatis;

CREATE TABLE USER(
    id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT COMMENT 'ID',
    NAME VARCHAR(100) COMMENT '姓名',
    age TINYINT UNSIGNED COMMENT '年龄',
    gender TINYINT UNSIGNED COMMENT '性别, 1:男, 2:女',
    phone VARCHAR(11) COMMENT '手机号'
) COMMENT '用户表';

INSERT INTO USER(id, NAME, age, gender, phone) VALUES (NULL,'白眉鹰王',55,'1','18800000000');
INSERT INTO USER(id, NAME, age, gender, phone) VALUES (NULL,'金毛狮王',45,'1','18800000001');
INSERT INTO USER(id, NAME, age, gender, phone) VALUES (NULL,'青翼蝠王',38,'1','18800000002');
INSERT INTO USER(id, NAME, age, gender, phone) VALUES (NULL,'紫衫龙王',42