一、初始化数据库
建立ApricotRed数据库,添加user表
DROP DATABASE IF EXISTS ApricotRed;
CREATE DATABASE ApricotRed;
USE ApricotRed;
DROP TABLE IF EXISTS user;
CREATE TABLE user
(
id BIGINT(20) NOT NULL COMMENT '主键ID',
name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名',
age INT(11) NULL DEFAULT NULL COMMENT '年龄',
sex VARCHAR(30) NULL DEFAULT NULL COMMENT '性别',
PRIMARY KEY (id)
);
INSERT INTO user (id, name, age, sex) VALUES
(1, '小芳', 18, '女'),
(2, '小明', 20, '男'),
(3, '小强', 28, '男'),
(4, '小丽', 21, '女');
二、创建实体类
1.User实体类
新建文件夹entity
创建实体类User
代码如下(示例):
package entity;
// 实体层,对应Mysql数据库中表和字段名,详情参照sql/init.sql
// lombok参考文档: https://blog.csdn.net/qq_43429919/article/details/117470788
import lombok.Data;
@Data
public class User {
private Long id;
private String name;
private int age;
private String email;
}
三、创建Mapper
1.UserMapper类
新建文件夹mapper
创建类UserMapper
如下(示例):
package mapper;
import entity.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
public class UserMapper {
}
四、创建操作数据库类
1.OperateMysqlDatabase类
新建文件夹controller
创建操作数据库类OperateMysqlDatabase
如下(示例):
package mapper;
import entity.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
public class UserMapper {
}
四、创建*mapper.xml
1.UserMapper.xml
新建文件夹mapper
创建UserMapper.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">
<!--1.注意下方对应namespace对应的位置-->
<mapper namespace="mapper.UserMapper">
</mapper>
四、pom.xml
1.pom依赖
如下(示例):
<!--lombok,entity(User)中使用,简化代码-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<!--baomidou,(mybatis-plus)在mapper(UserMapper)中使用,简介开发-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.3.1.tmp</version>
</dependency>
五、总预览
1.层次结构
如下(示例):