1.导入依赖
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.4.1</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.ajin.springboot</groupId>
<artifactId>013-springboot-mybatis3</artifactId>
<version>1.0.0</version>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<!--SpringBoot 框架web项目起步依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--MySQL 驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--Mybatis 整合SpringBoot框架的起步依赖-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.0.0</version>
</dependency>
<!--
引入SpringBoot内嵌Tomcat对jsp的解析依赖,不添加解析不了jsp
仅仅只是展示jsp页面,只添加以下一个依赖
-->
<dependency>
<groupId>org.apache.tomcat.embed</groupId>
<artifactId>tomcat-embed-jasper</artifactId>
</dependency>
</dependencies>
<build>
<resources>
<!--
SpringBoot项目默认推荐使用的前端引擎是 thymeleaf
现在我们要使用SpringBoot集成jsp,手动指定jsp最后编译的路径
而且SpringBoot集成jsp编译jsp的路径是SpringBoot规定好的位置
META-INF/resources
-->
<resource>
<!--源文件-->
<directory>src/main/webapp</directory>
<!--指定编译到META-INF/resources -->
<targetPath>META-INF/resources</targetPath>
<!--指定源文件中的哪个资源要进行编译-->
<includes>
<include>*.*</include>
</includes>
</resource>
</resources>
<plugins>
<!--mybatis代码自动生成插件-->
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.7</version>
<configuration>
<!--允许移动生成的文件 -->
<verbose>true</verbose>
<!-- 是否覆盖 -->
<overwrite>true</overwrite>
<!-- 自动生成的配置 -->
<configurationFile>GeneratorConfig.xml</configurationFile>
</configuration>
</plugin>
<!--SpringBoot 项目打包编译的插件-->
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
2.创建数据库
CREATE TABLE t_student
(
id INT(10) NOT NULL AUTO_INCREMENT,
NAME VARCHAR(20) NULL,
age INT(10) NULL,
CONSTRAINT pk_t_student PRIMARY KEY clustered(id)
);
3.创建mapper包和model包
4.拷贝Mybatis反向工程配置文件到项目的跟目录下
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<!--指定连接数据库的JDBC 驱动包所在位置,指定到你本机的完整路径-->
<classPathEntry location="F:\development tool\maven_work\maven_repository\mysql\mysql-connector-java\8.0.22\mysql-connector-java-8.0.22.jar"/>
<!--配置table表信息内容体,targetRuntime 指定采用MyBatis3的版本-->
<context id="tables" targetRuntime="MyBatis3">
<!--抑制生成注释,由于生成的注释都是英文的,可以不让它生成-->
<commentGenerator>
<property name="suppressAllComments" value="true" />
</commentGenerator>
<!--配置数据库连接信息-->
<jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC"
userId="root"
password="1493">
<property name="nullCatalogMeansCurrent" value="true"/>
</jdbcConnection>
<!--生成model 类,targetPackage 指定 model 类的包名,targetProject 指定
生成的 model放在eclipse的哪个工程下面-->
<javaModelGenerator targetPackage="com.ajin.springboot.model"
targetProject="src/main/java">
<property name="enableSubPackages" value="false"/>
<property name="trimStrings" value="false"/>
</javaModelGenerator>
<!--生成 MyBatis的Mapper.xml文件,targetPackage 指定 mapper.xml文件的包名,targetProject 指定生成的 mapper.xml放在 eclipse的哪个工程下面
-->
<sqlMapGenerator targetPackage="com.ajin.springboot.mapper"
targetProject="src/main/java">
<property name="enableSubPackages" value="false"/>
</sqlMapGenerator>
<!--生成 MyBatis的 Mapper接口类文件,targetPackage 指定 Mapper 接口类的包名,targetProject 指定生成的 Mapper 接口放在eclipse 的哪个工程下面
-->
<javaClientGenerator type="XMLMAPPER"
targetPackage="com.ajin.springboot.mapper"
targetProject="src/main/java">
<property name="enableSubPackages" value="false"/>
</javaClientGenerator>
<!--数据库表名及对应的Java模型类名-->
<table tableName="t_Student" domainObjectName="Student"
enableCountByExample="false"
enableUpdateByExample="false"
enableDeleteByExample="false"
enableSelectByExample="false"
selectByExampleQueryId="false" />
<table tableName="t_User" domainObjectName="User"
enableCountByExample="false"
enableUpdateByExample="false"
enableDeleteByExample="false"
enableSelectByExample="false"
selectByExampleQueryId="false" />
</context>
</generatorConfiguration>
5.单击工程下–plugins–mybatis–generator–mybatis–generator:generate来自动生成实体类、接口、映射文件
6.在main目录下创建文件webapp,打开项目结构,把该文件添加为web项目,并在该文件下添加jsp,获取controller信息
7.编写Controller层
@Controller
public class StudentController {
@Autowired //通过spring容器来调用service层
private StudentService studentService;
@RequestMapping("/student")
public String getStudent(Integer id, Model model){
Student student = studentService.queryStudentById(id);
model.addAttribute("message",student);
return "student";
}
}
8.编写Service层
public interface StudentService {
/**
* 通过id查询学生信息
* @param id
* @return
*/
Student queryStudentById(Integer id);
}
@Service //将该类交由spring进行管理,方便controller层调用
public class StudentServiceImpl implements StudentService{
@Autowired //通过spring容器来调用Dao层方法
private StudentMapper studentMapper;
@Override
public Student queryStudentById(Integer id) {
return studentMapper.selectByPrimaryKey(id);
}
}
9.编写Dao层
//@Mapper //扫描Dao接口到spring容器
public interface StudentMapper {
//根据 id 删除
int deleteByPrimaryKey(Integer id);
//插入语句
int insert(Student record);
//选择性的插入语句
int insertSelective(Student record);
//根据 id 进行查询
Student selectByPrimaryKey(Integer id);
//选择性的根据 id 修改
int updateByPrimaryKeySelective(Student record);
//根据 id 进行修改
int updateByPrimaryKey(Student record);
}
//StudentMapper.xml文件由SpringBoot自动生成
10.编写application.xml核心配置文件来绑定数据库
#集成jsp,配置视图解析器
spring.mvc.view.prefix=/
spring.mvc.view.suffix=.jsp
#绑定数据库
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=1493
#指定mybatis映射文件的路径
mybatis.mapper-locations=classpath:mapper/*.xml
11.如果映射文件在java目录下则需要在pom.xml文件中手动指定加载mapper的位置,如果映射文件在resources文件下,则只需要在application.xml文件中指定mybatis映射文件的路径即可
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>