@[toc]首先创建一个供查询的数据库和表
create database mybatis;
use mybatis;
drop table if exists mybatis;
create table tb_users(
id int primary key auto_increment,
username varchar(20),
password varchar(20),
gender char(1),
address varchar(30)
);
insert into tb_users values (1,'马大帅', '1234','M','莲花乡马家堡子');
insert into tb_users values (2,'范德彪', '5678','M','开原维多利亚玉乐广场');
insert into tb_users values (3,'罗翔', '9876','M','厚大法考');
select *
from tb_users;
结果如图
新建一个名为mybatis_demo的maven模块
给pom.xml文件添加依赖
<dependencies>
<dependency>
<!--mybatis的依赖-->
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.10</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.29</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13</version>
<scope>test</scope>