springboot整合mybatis与thymeleaf
2024-10-08 15:20:01
1.创建springboot项目
(1)选择Spring Initializr
(2)填写自己的Group 与 Artifact
(3)选择依赖框架
等待maven下载好依赖和插件即可
2.主配置文件(这里使用的是更为简洁的ylm文件)
application.yml
主要配置了数据源和mapper路径与实体类别名
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
username: root
password: 330069879
mybatis:
mapper-locations: classpath:/mapper/*.xml
type-aliases-package: com.datatest.signup.entity
3.实体类与表的映射关系
Person.java
package com.datatest.signup.entity; public class Person {
private String id;
private String name;
private int age;
private int sex; public void setId(String id) {
this.id = id;
} public void setName(String name) {
this.name = name;
} public void setAge(int age) {
this.age = age;
} public void setSex(int sex) {
this.sex = sex;
} @Override
public String toString() {
return "Person{" +
"id='" + id + '\'' +
", name='" + name + '\'' +
", age=" + age +
", sex=" + sex +
'}';
}
}
数据库表person
4.mapper.xml 与 PersonMapper
<?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.datatest.signup.mapper.PersonMapper">
<select id="queryPersonById" resultType="Person" parameterType="String">
select * from person where id=#{id}
</select>
</mapper>
PersonMapper.java
package com.datatest.signup.mapper; import com.datatest.signup.entity.Person;
import org.springframework.stereotype.Repository; @Repository
public interface PersonMapper {
Person queryPersonById(String id);
}
5.Service层
PersonService.java
package com.datatest.signup.service; import com.datatest.signup.entity.Person; public interface PersonService {
public Person queryPersonById(String id);
}
package com.datatest.signup.service.impl; import com.datatest.signup.entity.Person;
import com.datatest.signup.mapper.PersonMapper;
import com.datatest.signup.service.PersonService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service; @Service
public class PersonServiceImpl implements PersonService {
@Autowired
private PersonMapper personMapper; @Override
public Person queryPersonById(String id) {
return personMapper.queryPersonById(id);
}
}
6.controller层
package com.datatest.signup.controller; import com.datatest.signup.entity.Person;
import com.datatest.signup.service.PersonService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping; import java.util.Map; @Controller
public class StudentController { @Autowired
private PersonService personService; @RequestMapping("query/{id}")
public String queryPersonById(@PathVariable String id, Map<String,Object> map){
Person person = personService.queryPersonById(id);
System.out.println(person);
map.put("person",person);
return "result";
}
}
7.前段页面
index.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>sprint boot</title>
</head>
<body>
<a href="query/P01">查询一个人</a>
</body>
</html>
result.html
<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>result</title>
</head>
<body>
<p th:text="${person}">没有查询到该人</p>
</body>
</html>
8.主程序文件
package com.datatest.signup; import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication; @MapperScan("com.datatest.signup.mapper")
@SpringBootApplication
public class SignupApplication { public static void main(String[] args) {
SpringApplication.run(SignupApplication.class, args);
} }
9.测试效果
最新文章
- C#开发微信门户及应用(25)-微信企业号的客户端管理功能
- php基础排序算法 冒泡排序 选择排序 插入排序 归并排序 快速排序
- tomcat(三)--基本安装配置
- linux中配置NTP基本操作
- C#第一次的Hello World
- Delphi 使用之dll文件生成与调用
- 一、什么是WPF?
- 基于XMPP的即时通信系统的建立(六)— 开发环境搭建
- JavaBean个人总结
- Web.xml 中增加log4j
- C#多线程和线程同步总结
- OC对象与Core Foundation对象的转换
- win7无法启用网络发现
- Spring Boot入门(五):使用JDBC访问MySql数据库
- String、StringBuffer和StringBuilder类的区别
- Scala之eq,equals,==的区别
- JSTL_Core标记库
- 基于WIN8.1:新手篇→tomcat安装配置
- 安装配置JDK和Eclipse的步骤
- 洛谷P4782 2-SAT问题
热门文章
- ThreadLocal的原理和在框架中的应用
- 针对小文件的spark wholeTextFiles()
- IDEA激活方法(Linux和Windows通用)
- P1063 计算谱半径
- day07-Python运维开发基础(深/浅拷贝、字典/集合/相关操作)
- WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! 的解决办法
- ssm web.xml文件解析
- 从三星官方uboot开始移植
- 99乘法表(for循环嵌套)
- 接口测试基础----postman、jmeter