mybatis基础01(Mybatis入门程序)

Mybatis入门程序(必须亲自动手写上一遍)

1.创建表:

 

CREATE TABLE `user` (   `uid` int(11) NOT NULL AUTO_INCREMENT,   `uname` varchar(32) DEFAULT NULL,   `uphone` varchar(32) DEFAULT NULL,   PRIMARY KEY (`uid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8

 

2.导入需要的依赖

    <dependencies>
        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/junit/junit -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <!-- https://mvnrepository.com/artifact/log4j/log4j -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.12</version>
            <scope>provided</scope>
        </dependency>


    </dependencies>

 

 

3.根据表创建模型

@Data
public class User {
    private Integer uid;
    private String uname;
    private String uphone;
}

4.使用xml配置框架

a:配置主配置文件mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
&l