springBoot导出SQl文档

最新推荐文章于 2024-07-29 09:08:18 发布

勘察加熊人

最新推荐文章于 2024-07-29 09:08:18 发布

阅读量895

点赞数

分类专栏： javaweb 文章标签： sql java mysql

本文链接：https://blog.csdn.net/cf8833/article/details/120136363

版权

这篇博客详细介绍了如何利用SpringBoot项目，配合配置文件和模板，一步步实现从数据库导出SQL文档的过程，覆盖了从配置到操作的多个步骤。

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

step1:

<?xml version="1.0" encoding="UTF-8"?>
<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>

  <groupId>com.mxixm.spring</groupId>
  <artifactId>boot</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>jar</packaging>

  <name>boot Maven Webapp</name>
  <url>http://www.mxixm.com</url>

  <!--Spring Boot项目需要指定的父项目-->
  <parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.0.2.RELEASE</version>
  </parent>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
  </properties>

  <dependencies>
    <!--Spring Boot Web项目的starter包，Web项目引入此包-->
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <!--Spring Boot项目数据库读写的starter包，需要数据库读写是引入此包即可-->
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <!--Spring Boot默认情况下不支持JSP模板，推荐使用thymeleaf模板引擎，引入此starter即可-->
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-thymeleaf</artifactId>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-freemarker</artifactId>
    </dependency>
    <!--WebSocket支持-->
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-websocket</artifactId>
    </dependency>
    <!--mysql连接器-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
    </dependency>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <scope>test</scope>
    </dependency>

    <dependency>
      <groupId>javax.persistence</groupId>
      <artifactId>persistence-api</artifactId>
      <version>1.0.2</version>
    </dependency>

    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>3.16</version>
    </dependency>
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml</artifactId>
      <version>3.16</version>
    </dependency>
    <dependency>
      <groupId>com.google.code.gson</groupId>
      <artifactId>gson</artifactId>
    </dependency>
  </dependencies>

  <build>
    <plugins>
      <!--Spring Boot提供的项目打为Jar包的Maven插件，执行mvn package即可打为可启动jar包。-->
      <plugin>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-maven-plugin</artifactId>
      </plugin>
    </plugins>
  </build>

</project>

step2: F:\project\excel\poi\goodTable\src\main\resources\application.properties

spring.datasource.url=jdbc:mysql://localhost/mysql?characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=gft123456

step3: F:\project\excel\poi\goodTable\src\main\resources\templates\index.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<body>
<h2 th:text="'Hello ' + ${sqlName} + '!'"></h2>
</body>
</html>

step4:

package com.org;


import org.springframework.boot.SpringApplication;
imp

最低0.47元/天解锁文章

勘察加熊人

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
springBoot导出SQl文档

step1:<?xml version="1.0" encoding="UTF-8"?><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.or
复制链接

扫一扫

专栏目录