步骤如下:
(1)右键->new Module->spring initial->web->spring web,生成基础项目
(2)pom.xml添加Mybatis起步依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
如果下载失败,删除maven库里的lastUpdate文件,reimport
(3)pom.xml添加数据库驱动坐标
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
(4)连接数据库——选择自己的数据库连接以及创建数据表等操作
(5)添加数据库连接信息
src->resources->application.properties,添加
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=admin
这里一定要注意connector-8以上,与旧版本有所区别。驱动名称变成了com.mysql.cj.jdbc.Driver。
(6)创建实体类,用于映射数据表
com.qmy下面创建package,创建实体类user,变量名和数据表的属性名和数据类型要一致,否则匹配不上,返回null
public class user {
private int stu_num;
private String stu_name;
public int getStu_num() {
return stu_num;
}
public void setStu_num(int stu_num) {
this.stu_num = stu_num;
}
public String getStu_name() {
return stu_name;
}
public void setStu_name(String stu_name) {
this.stu_name = stu_name;
}
@Override
public String toString() {
return "user{" +
"stu_num=" + stu_num +
", stu_name='" + stu_name + '\'' +
'}';
}
}
(7)创建mapper方法接口
@Mapper
public interface UserMapper {
public List<user> queryUserList();
}
(8)创建mapper,映射实体类和数据表
生成一个mapper的配置文件
src->resources->new pachage->mapper->new file->UserMapper.xml
并添加:
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.qmy.mapper.UserMapper">//这里就是UserMapper接口所在目录
<select id="queryUserList" resultType="user">
select * from students
</select>
</mapper>
这里要注意:http://mybatis.org/dtd/mybatis-3-mapper.dtd这个链接可能是无效的,只需要点击链接将mapper下载下来,并进行设置:
settings->Languages and fremaworks->Schames and DTDs->点击+号,添加链接,并选择mapper本地路径即可。
(9)在application.properties文件下配置mybatis信息
即添加
#配置mybatis信息
mybatis.type-aliases-package=com.qmy.Dao//这里是实体类的package
mybatis.mapper-locations=classpath:mapper/usermapper.xml//这里指向resources下的mapper配置文件
(10)编写测试controller
@Controller
public class MybatisController {
@Autowired
private UserMapper usermapper;
@RequestMapping("/users")
@ResponseBody
public List<user> queryUserList(){
List<user> users=usermapper.queryUserList();
return users;
}
}
(11)启动测试,转到/users路径下,可以看到打印出的students表的数据。
提醒:在应该使用注解的地方前方不要忘了加注解
@Mapper
@Autowired
@RequestMapping
@ResponseBody