spring-boot集成springmvc、myBatista和thymeleaf的案例

最新推荐文章于 2025-03-17 08:22:23 发布

zgahlibin

最新推荐文章于 2025-03-17 08:22:23 发布

阅读量348

点赞数

分类专栏： Java 微架构spring-boot

本文链接：https://blog.youkuaiyun.com/zgahlibin/article/details/83471785

版权

Java 同时被 2 个专栏收录

20 篇文章

订阅专栏

微架构spring-boot

15 篇文章

订阅专栏

该博客详细介绍了如何在Spring Boot项目中集成SpringMVC、MyBatis和Thymeleaf，实现CRUD操作。通过添加相关依赖、配置数据库连接、设置连接池、扫描Mapper接口以及编写对应的XML文件，完成了一个完整的业务案例。项目源码已上传至网盘，供读者参考学习。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

案例需求，完成增、删、改、查业务。

引入依赖

<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 http://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>1.5.10.RELEASE</version>
	</parent>
	<groupId>com.jiayun</groupId>
	<artifactId>spring-boot-mybatis-thymeleaf</artifactId>
	<version>0.0.1-SNAPSHOT</version>


	

	<!-- 修改jdk版本 -->
	<properties>
		<java.version>1.7</java.version>
		<thymeleaf.version>3.0.2.RELEASE</thymeleaf.version>
		<thymeleaf-layout-dialect.version>2.0.4</thymeleaf-layout-dialect.version>
	</properties>

	<dependencies>
		<!-- springBoot的启动器依赖 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<!-- Mybatis启动器 -->
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.1.1</version>
		</dependency>
		<!-- mysql数据库驱动 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		<!-- druid数据库连接池 -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.0.9</version>
		</dependency>
		
		<!-- thymeleaf  -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-thymeleaf</artifactId>
		</dependency>
	</dependencies>

</project>

配置数据库的连接信息在application.properties文件中

spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/ssm
spring.datasource.username=root
spring.datasource.password=root

连接池的配置

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

启动类中要添加扫描mapper文件的注解

@MapperScan("mapper文件的包路径")

package com.jiayun;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.jiayun.dao")
public class App {
	
	public static void main(String[] args) {
		SpringApplication.run(App.class, args);
	}

}

xml文件要与dao接口同名

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.jiayun.dao.UserDaoMapper">
	<insert id="add" parameterType="com.jiayun.entity.User">
		insert into user(name,age) values(#{name }, #{age })
	</insert>
	
	<select id="selectAll" resultType="com.jiayun.entity.User">
		SELECT * FROM user
	</select>
	
	<select id="selectById" resultType="com.jiayun.entity.User">
		SELECT * FROM user where id=#{id }
	</select>
	
	<delete id="delete" parameterType="java.lang.Integer">
		DELETE FROM user WHERE id=#{id }
	</delete>
	
	<update id="update" parameterType="com.jiayun.entity.User">
		update user set name=#{name }, age=#{age } WHERE id=#{id }
	</update>
</mapper>

最后我把项目放到网盘上

链接：https://pan.baidu.com/s/1b8BTSEj4qm1jbdGtLG8h1A
提取码：f4u7