需求:使用Mapper接口对数据库中的表进行CRUD
项目结构
target是项目编译之后生成的
1.在数据库中创建表
CREATE TABLE employee(
id INT(11) PRIMARY KEY auto_increment,
name VARCHAR(30),
age INT(11),
birthday date,
salary DECIMAL(10,0)
)
2.准备工作
2.1在项目的pom.xml文件中添加mysql,mybatis等依赖
<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.ujiuye</groupId>
<artifactId>mybatis002</artifactId>
<version>1.0.0</version>
<dependencies>
<!-- mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<!-- lombok -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.8</version>
<scope>provided</scope>
</