最新Springboot整合Thymeleaf、layui实现简单的增删改查

淩亂°似流年 2022-04-17 06:10 821阅读 0赞

# Springboot整合Thymeleaf、layui实现简单的增删改查 #

## 主页面列表分页显示 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70][]

## 搜索功能 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 1]

## 添加用户 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 2]

## 编辑用户 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 3]

## Mapper映射 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 4]

## Controller层 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 5]

## list.html初始化加载表格数据 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 6]

## 搜索重载表格数据 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 7]

## application.properties文件 ##

#\u5173\u95ED\u7F13\u5B58, \u5373\u65F6\u5237\u65B0
    #spring.freemarker.cache=false
    #spring.thymeleaf.cache=true
    #打印SQL
    logging.level.com.swkj.mapper=debug
    #\u70ED\u90E8\u7F72\u751F\u6548
    spring.devtools.restart.enabled=true
    #\u8BBE\u7F6E\u91CD\u542F\u7684\u76EE\u5F55,\u6DFB\u52A0\u90A3\u4E2A\u76EE\u5F55\u7684\u6587\u4EF6\u9700\u8981restart
    spring.devtools.restart.additional-paths=src/main/java
    # \u4E3Amybatis\u8BBE\u7F6E\uFF0C\u751F\u4EA7\u73AF\u5883\u53EF\u5220\u9664
    restart.include.mapper=/mapper-[\\w-\\.]+jar
    restart.include.pagehelper=/pagehelper-[\\w-\\.]+jar
    #\u6392\u9664\u90A3\u4E2A\u76EE\u5F55\u7684\u6587\u4EF6\u4E0D\u9700\u8981restart
    #spring.devtools.restart.exclude=static/**,public/**
    #classpath\u76EE\u5F55\u4E0B\u7684WEB-INF\u6587\u4EF6\u5939\u5185\u5BB9\u4FEE\u6539\u4E0D\u91CD\u542F
    #spring.devtools.restart.exclude=WEB-INF/**    
    ############################################################
    #
    # \u914D\u7F6E\u6570\u636E\u6E90\u76F8\u5173	\u4F7F\u7528\u963F\u91CC\u5DF4\u5DF4\u7684 druid \u6570\u636E\u6E90
    #
    ############################################################
    spring.datasource.url=jdbc:mysql://localhost:3306/springboot?characterEncoding=utf8&useSSL=true
    spring.datasource.username=root
    spring.datasource.password=1234
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    spring.datasource.druid.initial-size=1
    spring.datasource.druid.min-idle=1
    spring.datasource.druid.max-active=20
    spring.datasource.druid.test-on-borrow=true
    spring.datasource.druid.stat-view-servlet.allow=true
    
    ############################################################
    #
    # mybatis \u914D\u7F6E
    #
    ############################################################
    # mybatis \u914D\u7F6E
    mybatis.type-aliases-package=com.swkj.pojo
    mybatis.mapper-locations=classpath:mapper/*.xml
    #开启驼峰命名转换
    mybatis.configuration.map-underscore-to-camel-case=true
    # 通用 Mapper 配置
    mapper.mappers=com.swkj.utils.MyMapper
    mapper.not-empty=false
    mapper.identity=MYSQL
    
    ############################################################
    #
    # 配置i18n 资源文件，供thymeleaf 读取
    #
    ############################################################
    spring.messages.basename=i18n/messages
    spring.messages.cache-seconds=3600
    spring.messages.encoding=UTF-8
    
    #设定静态文件路径，js,css等。要使用Swagger，这行需要注释
    spring.mvc.static-path-pattern=/static/**
    
    ############################################################
    #
    # thymeleaf 静态资源配置
    #
    ############################################################
    spring.thymeleaf.prefix=classpath:/templates/
    spring.thymeleaf.suffix=.html
    spring.thymeleaf.mode=HTML5
    spring.thymeleaf.encoding=UTF-8
    spring.thymeleaf.content-type=text/html
    # 关闭缓存, 即时刷新, 上线生产环境需要改为true
    spring.thymeleaf.cache=false
    
    ############################################################
    #
    # Server \u670D\u52A1\u7AEF\u76F8\u5173\u914D\u7F6E
    #
    ############################################################
    # \u914D\u7F6Eapi\u7AEF\u53E3\u53F7
    server.port=8080
    # \u914D\u7F6Econtext-path, \u4E00\u822C\u6765\u8BF4\u8FD9\u4E2A\u914D\u7F6E\u5728\u6B63\u5F0F\u53D1\u5E03\u7684\u65F6\u5019\u4E0D\u914D\u7F6E
    #server.context-path=/IMooc
    # \u9519\u8BEF\u9875\uFF0C\u6307\u5B9A\u53D1\u751F\u9519\u8BEF\u65F6\uFF0C\u8DF3\u8F6C\u7684URL --> BasicErrorController
    #server.error.path=/error
    # session\u6700\u5927\u8D85\u65F6\u65F6\u95F4(\u5206\u949F)\uFF0C\u9ED8\u8BA4\u4E3A30\u5206\u949F
    server.session-timeout=60
    # \u8BE5\u670D\u52A1\u7ED1\u5B9AIP\u5730\u5740\uFF0C\u542F\u52A8\u670D\u52A1\u5668\u65F6\u5982\u672C\u673A\u4E0D\u662F\u8BE5IP\u5730\u5740\u5219\u629B\u51FA\u5F02\u5E38\u542F\u52A8\u5931\u8D25, 
    # \u53EA\u6709\u7279\u6B8A\u9700\u6C42\u7684\u60C5\u51B5\u4E0B\u624D\u914D\u7F6E, \u5177\u4F53\u6839\u636E\u5404\u81EA\u7684\u4E1A\u52A1\u6765\u8BBE\u7F6E
    #server.address=192.168.1.2
    
    ############################################################
    # Server - tomcat \u76F8\u5173\u5E38\u7528\u914D\u7F6E
    ############################################################
    # tomcat\u6700\u5927\u7EBF\u7A0B\u6570, \u9ED8\u8BA4\u4E3A200
    #server.tomcat.max-threads=250
    # tomcat\u7684URI\u7F16\u7801
    server.tomcat.uri-encoding=UTF-8
    # \u5B58\u653ETomcat\u7684\u65E5\u5FD7\u3001Dump\u7B49\u6587\u4EF6\u7684\u4E34\u65F6\u6587\u4EF6\u5939\uFF0C\u9ED8\u8BA4\u4E3A\u7CFB\u7EDF\u7684tmp\u6587\u4EF6\u5939
    #\uFF08\u5982\uFF1AC:\Users\Shanhy\AppData\Local\Temp\uFF09
    #server.tomcat.basedir=H:/springboot-tomcat-tmp
    # \u6253\u5F00Tomcat\u7684Access\u65E5\u5FD7\uFF0C\u5E76\u53EF\u4EE5\u8BBE\u7F6E\u65E5\u5FD7\u683C\u5F0F\u7684\u65B9\u6CD5\uFF1A
    #server.tomcat.access-log-enabled=true
    #server.tomcat.access-log-pattern=
    # accesslog\u76EE\u5F55\uFF0C\u9ED8\u8BA4\u5728basedir/logs
    #server.tomcat.accesslog.directory=
    # \u65E5\u5FD7\u6587\u4EF6\u76EE\u5F55
    #logging.path=H:/springboot-tomcat-tmp
    # \u65E5\u5FD7\u6587\u4EF6\u540D\u79F0\uFF0C\u9ED8\u8BA4\u4E3Aspring.log
    #logging.file=myapp.log

## pom.xml文件 ##

<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-devtools</artifactId>
    			
    			<optional>true</optional>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-configuration-processor</artifactId>
    			<optional>true</optional>
    		</dependency>
    
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-data-redis</artifactId>
    		</dependency>
    
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    
    		<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
    			<artifactId>mybatis-spring-boot-starter</artifactId>
    			<version>1.3.2</version>
    		</dependency>
    		<dependency>
    			<groupId>com.alibaba</groupId>
    			<artifactId>druid-spring-boot-starter</artifactId>
    			<version>1.1.0</version>
    		</dependency>
    
    		<dependency>
    			<groupId>org.mybatis.generator</groupId>
    			<artifactId>mybatis-generator-core</artifactId>
    			<version>1.3.2</version>
    			<scope>compile</scope>
    			<optional>true</optional>
    		</dependency>
    		
    		<dependency>
    			<groupId>tk.mybatis</groupId>
    			<artifactId>mapper-spring-boot-starter</artifactId>
    			<version>RELEASE</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-thymeleaf</artifactId>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>com.alibaba</groupId>
    			<artifactId>fastjson</artifactId>
    			<version>1.2.7</version>
    		</dependency>
    		<dependency>
    			<groupId>com.fasterxml.jackson.core</groupId>
    			<artifactId>jackson-databind</artifactId>
    			<version>${jackson.version}</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>io.springfox</groupId>
    			<artifactId>springfox-swagger2</artifactId>
    			<version>2.5.0</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>io.springfox</groupId>
    			<artifactId>springfox-swagger-ui</artifactId>
    			<version>2.5.0</version>
    		</dependency>
    		<dependency>
    			<groupId>com.belerweb</groupId>
    			<artifactId>pinyin4j</artifactId>
    			<version>2.5.0</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>javax.mail</groupId>
    			<artifactId>mail</artifactId>
    			<version>1.4.5</version>
    		</dependency>
    
    		<dependency>
    			<groupId>org.apache.shiro</groupId>
    			<artifactId>shiro-core</artifactId>
    			<version>1.3.2</version>
    		</dependency>
    		<dependency>
    			<groupId>org.slf4j</groupId>
    			<artifactId>slf4j-nop</artifactId>
    			<version>1.7.24</version>
    		</dependency>
    		<dependency>
    			<groupId>log4j</groupId>
    			<artifactId>log4j</artifactId>
    			<version>1.2.17</version>
    		</dependency>
    
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<scope>runtime</scope>
    		</dependency>
    
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<scope>test</scope>
    		</dependency>

Springboot整合Thymeleaf和Layui。目前已实现简单的增删改查功能、批量删除功能、以及Echart报表显示与后台的数据交互功能。后面会不断完善。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70]: /images/20220417/4a732697fcd94b3e822d55db388e75b6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 1]: /images/20220417/2072f7e513314302907b5232aae52559.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 2]: /images/20220417/33809317e8574f679457be5d0ccfe0b3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 3]: /images/20220417/04029f306bfa4bf79c85aef5ae665159.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 4]: /images/20220417/f5e0cc80bb4a497084630bcda5d0407c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 5]: /images/20220417/1ec89ca318b24258ab66ee76576efb49.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 6]: /images/20220417/59d3c722537e480abd6982efdd983e12.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzQ0MDMwMQ_size_16_color_FFFFFF_t_70 7]: /images/20220417/6cdcd68ddf464029853f9f42e70a03b4.png