当前环境:JDK1.8、MAVEN 3.6.1、idea
1.导入依赖
当前
pom
文件如下:
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.7.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.hy</groupId>
<artifactId>hy</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>EnterpriseTalentManagement</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
2.创建实体类
当前的
Department
类中的内容:
/**
* Created by Administrator on 2019/8/22.
*/
public class Department {
private Integer id;
private String name;
public Integer getId() {
return id;
}
....省略getter和setter方法
}
3.创建dao层
当前的
DepartmentMapper
内容:
/**
* Created by Administrator on 2019/8/22.
*/
@Mapper//这里使用mapper
public interface DepartmentMapper {
List<Department> findAll();
}
4.编写xml文件
注意:当前的xml文件再resources中的mapper文件中
<?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.hy.job.dao.DepartmentMapper" >
<select id="findAll" resultType="Department">
select * FROM department;
</select>
</mapper>
5.当前的application.properties
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/db
spring.datasource.username=root
spring.datasource.password=root
mybatis.mapper-locations=classpath:mapper/*Mapper.xml
这里使用mapper文件的扫描
mybatis.type-aliases-package=com.hy.job.entity
这里做别名映射
6.测试
成功!
7.总结
1.当前的dao层需要添加@Mapper
2.使用xml的时候需要在resources文件中编写
,否者可能出现找不到xml文件的情况
,需要在application.properties中编写
出来
- mybatis.mapper-locations=classpath:xml文件所在的路径
- mybatis.type-aliases-package=实体类的路劲
3.使用模板引入js的时候需要使用th:src="@{js的文件路径}"
使用idea的时候,与eclipse不一样,有的地方需要配置,才能使用
以上纯属个人见解,如有问题请联系本人!