当前位置：Gxlcms > 数据库问题 > 1.SpringBoot+Thymeleaf+MySQL简单操作

1.SpringBoot+Thymeleaf+MySQL简单操作

时间：2021-07-01 10:21:17 帮助过：6人阅读

dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.1</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-thymeleaf</artifactId> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.5</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.3.1</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> <exclusions> <exclusion> <groupId>org.junit.vintage</groupId> <artifactId>junit-vintage-engine</artifactId> </exclusion> </exclusions> </dependency> </dependencies>

2.Mapper文件

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

3.Controller文件

@Controller
public class PreregController {

    @Autowired
    PreregMapper preregMapper;

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

4.Bean文件

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 +
                    ‘}‘;
        }


}

5.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>[[${item.peopleCount}]]</td>
    <td th:text="${item.trans}"></td>
</tr>

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

6.application.properties

#数据库配置
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/blog?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456
# 非Mysql8.0请改为com.mysql.jdbc.Driver
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

7.数据库内容，运行结果

技术图片

分手后的第一个博客，不想写字，就这样吧，哎

1.SpringBoot+Thymeleaf+MySQL简单操作

标签：lis inter load amp image timezone root driver tran

1.SpringBoot+Thymeleaf+MySQL简单操作

2.Mapper文件

3.Controller文件

4.Bean文件

5.HTML文件

6.application.properties

7.数据库内容，运行结果

人气教程排行