Mybatis入门案例-----使用IDEA 创建 maven java 项目,使用mapper接口实现增删改查(内含源码及详细解释)

题目

使用IDEA 创建 MAVEN  JAVA 项目

根据下图 在mysql数据库中创建员工表(t_employee)

创建实体类 Employee  并创建mapper接口(EmployeeMapper.java)

以及测试类 对创建的mapper映射文件进行增删改查以及测试

项目目录结构

 

1.在数据库中创建表T_Employee(大小写无所谓)

DROP TABLE IF EXISTS t_employee;
CREATE TABLE t_employee (
  id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(30) DEFAULT NULL,
  age int(11) DEFAULT NULL,
  birthday date DEFAULT NULL,
  salary decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (id)
)

2.创建实体类Employee

package com.xiongluoluo.bean;

import lombok.*;

import java.math.BigDecimal;
import java.util.Date;

/**
 * Created by Administrator on 2019/12/21 0021.
 */
@Getter
@Setter
@ToString
@AllArgsConstructor
@NoArgsConstructor
public class Employee {
    private int id;
    private String name;
    private int age;
    private Date birthday;
    private BigDecimal salary;
}

2.要使用mybatis的mapper映射文件,就必须先导入mybatis依赖,由于要和数据库进行交互,所以还要导入mysql连接数据库也就是JDBC的依赖.

2.1   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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.xiongluoluo</groupId>
    <artifactId>mybatis2</artifactId>
    <version>1.0.0</version>

    <dependencies>
        <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.8</version>
            <scope>provided</scope>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <!--JDBC的依赖(在https://mvnrepository.com中搜索mysql,点击第一个即可)-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>

    </dependencies>

</project>

 

2.2 db.properties文件

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql:///test2
username=root
password=1234

 

2.3 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>
    <properties resource="db.properties"/>
    <typeAliases>
        <package name="com.xiongluoluo.bean"/>
    </typeAliases>
    <environments default="mysql">
        <environment id="mysql">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <