springboot Thymeleaf从数据库提取数据到页面显示

最新推荐文章于 2024-09-14 10:16:37 发布

YUEXILIULI

最新推荐文章于 2024-09-14 10:16:37 发布

阅读量8.2k

点赞数 12

分类专栏： Springboot 文章标签： Springboot Thymeleaf

本文链接：https://blog.csdn.net/YUEXILIULI/article/details/103099403

版权

Springboot 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

本文介绍如何在SpringBoot项目中整合Thymeleaf模板引擎，包括配置Thymeleaf依赖、创建PreregController控制器、PreregMapper数据访问接口、Prereg实体类以及Thymeleaf HTML页面，实现从数据库查询数据并展示。

摘要由CSDN通过智能技术生成

准备

MySql数据库，表Prereg，IDEA
数据库中的表如下所示：
在这里插入图片描述
IDEA目录结构如下：

添加thymeleaf依赖：

<dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>

开始添加代码：

在controller包添加类“PreregController”

package com.example.demo.controller;

import com.example.demo.mapper.PreregMapper;
import com.example.demo.pojo.Prereg;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.annotation.Resource;
import java.util.List;

@Controller
public class PreregController {
    @Resource
    PreregMapper preregMapper;

    @RequestMapping("/listPrereg")
    public String listPrereg(Model model)
    {
        List<Prereg> preregs=preregMapper.findAll();
        model.addAttribute("preregs",preregs);
        return "listPrereg";
    }
}

在Mapper包下添加映射interface:“PreregMapper”

package com.example.demo.mapper;

import com.example.demo.pojo.Prereg;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.boot.autoconfigure.data.jpa.JpaRepositoriesAutoConfiguration;
import java.util.List;

@Mapper
public interface PreregMapper {
    @Select("SELECT * FROM Prereg")
    List<Prereg> findAll();
}

在pojo包下添加类Prereg：

package com.example.demo.pojo;

import java.util.Date;

public class Prereg {
    private String StuId;
    private String StuName;
    private String Trans;
    private int IsCompany;
    private int PeopleCount;
    private Date ArrTime;

    public String getStuId() {
        return StuId;
    }

    public void setStuId(String stuId) {
        StuId = stuId;
    }

    public String getStuName() {
        return StuName;
    }

    public void setStuName(String stuName) {
        StuName = stuName;
    }

    public String getTrans() {
        return Trans;
    }

    public void setTrans(String trans) {
        Trans = trans;
    }

    public int getIsCompany() {
        return IsCompany;
    }

    public void setIsCompany(int isCompany) {
        IsCompany = isCompany;
    }

    public int getPeopleCount() {
        return PeopleCount;
    }

    public void setPeopleCount(int peopleCount) {
        PeopleCount = peopleCount;
    }

    public Date getArrTime() {
        return ArrTime;
    }

    public void setArrTime(Date arrTime) {
        ArrTime = arrTime;
    }

    @Override
    public String toString() {
        return "Prereg{" +
                "StuId='" + StuId + '\'' +
                ", StuName='" + StuName + '\'' +
                ", Trans='" + Trans + '\'' +
                ", IsCompany=" + IsCompany +
                ", PeopleCount=" + PeopleCount +
                ", ArrTime=" + ArrTime +
                '}';
    }
}

注：小技巧：定义好变量后，Alt+insert弹出“Generate”,选择“Getter and Setter”,再选择toString()即可完成。

最后是写HTML页面：

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>springboot-thymeleaf demo</title>
</head>
<body>
<table border="1" width="1000">
    <thead>
    <tr>
        <td>学生学号</td>
        <td>学生姓名</td>
        <td>到达时间</td>
        <td>家人陪伴</td>
        <td>陪伴数量</td>
        <td>交通工具</td>
    </tr>
    </thead>
<tr th:each="item,eee: ${preregs}">
    <td th:text="${item.stuId}"></td>
    <td th:text="${item.stuName}"></td>
    <td th:text="${item.arrTime}"></td>
    <td th:text="${item.isCompany}"></td>
    <td th:text="${item.peopleCount}"></td>
    <td th:text="${item.trans}"></td>
</tr>

</table>
</body>
</html>
</html>