MyBatis入门(一)

最新推荐文章于 2023-08-12 16:56:02 发布

buyue__

最新推荐文章于 2023-08-12 16:56:02 发布

阅读量251

点赞数

分类专栏： Java 文章标签： mybatis

本文链接：https://blog.csdn.net/buyueliuying/article/details/78803165

版权

Java 专栏收录该内容

47 篇文章 0 订阅

订阅专栏

new project

这里写图片描述

pom.xml
添加依赖包

<dependencies>
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.4.5</version>
    </dependency>
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>6.0.6</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>1.7.25</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>1.7.25</version>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
    </dependency>
    <!--其他依赖-->
</dependencies>

数据库

use mybatis;

CREATE TABLE `mybatis`.`country`  (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `countryname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
 `countrycode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

insert into country(countryname,countrycode) values('中国','cn'),('美国','us'),('俄罗斯','ru');