springboot整合mybatis与thymeleaf
GechangLiu 2020-01-26
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.entity3.实体类与表的映射关系
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.测试效果
相关推荐
丽丽 0喜欢 / 0评论 2020-10-30
visionzheng 0喜欢 / 0评论 2020-04-20
86384798 0喜欢 / 0评论 2020-04-07
85291545 0喜欢 / 0评论 2020-03-26
东哥笔记 0喜欢 / 0评论 2020-02-29
goodyatou 0喜欢 / 0评论 2020-01-29
ffujbcf 0喜欢 / 0评论 2019-12-05
空间数据库是 0喜欢 / 0评论 2019-11-18
yangjinpingc 0喜欢 / 0评论 2018-05-20
MicroBoy 0喜欢 / 0评论 2017-03-30
努力的zhiyi 0喜欢 / 0评论 2017-01-17
姜依涛 0喜欢 / 0评论 2019-06-27
jackuseradmin 0喜欢 / 0评论 2019-06-27
newstudent0 0喜欢 / 0评论 2019-06-27
LeeEmmmm 0喜欢 / 0评论 2019-06-21
wangjie 0喜欢 / 0评论 2018-09-25
hanyueqi 0喜欢 / 0评论 2017-06-14
稀土 0喜欢 / 0评论 2018-05-11
BitTigerio 0喜欢 / 0评论 2018-05-08
出版圈郭志敏 0喜欢 / 0评论 2018-02-26
人丑就该多读书 0喜欢 / 0评论 2017-12-09
莫道寻常 0喜欢 / 0评论 2017-12-09
无人机中的城堡 0喜欢 / 0评论 2017-11-29
软件设计 0喜欢 / 0评论 2017-04-09
编程爱好者联盟 0喜欢 / 0评论 2017-03-01