一、准备工作
先在eclipse中导入mybatis的dtd约束:
- mybatis-3-config.dtd
- mybatis-3-mapper.dtd
导入方法如图:
新建一张数据表dept:
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
`deptno` bigint(20) NOT NULL AUTO_INCREMENT,
`dname` varchar(50) DEFAULT NULL,
PRIMARY KEY (`deptno`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dept
-- ----------------------------
INSERT INTO `dept` VALUES ('1', '开发部');
INSERT INTO `dept` VALUES ('2', '财务部');
INSERT INTO `dept` VALUES ('3', '市场部');
INSERT INTO `dept` VALUES ('4', '后勤部');
INSERT INTO `dept` VALUES ('5', '公关部');
INSERT INTO `dept` VALUES ('9', '测试部');
INSERT INTO `dept` VALUES ('10', '测试部');
二、Mybatis环境搭建
第一步:添加pom依赖,导入mybatis所需jar包,pom依赖如下:
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<