mybatis

配置文件



server.port=8080
spring.application.name=logistics

#配置图片资源路径,则默认的static/public静态路径就要重新配置
spring.resources.static-locations=file:E:/logistics/,classpath:/static/
#mybatis配置

#配置别名
mybatis.type-aliases-package=com.logistics.bean
#驼峰命名
mybatis.configuration.map-underscore-to-camel-case=true

#关闭缓存
mybatis.configuration.cache-enabled=false
#是否返回主键
mybatis.configuration.use-generated-keys=true
#提高性能
mybatis.configuration.default-executor-type=reuse
#事务超时的时间
mybatis.configuration.default-statement-timeout=600
#扫描SQL映射文件
mybatis.mapper-locations=mapper/*.xml                  */

#数据源
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/logistics?characterEncoding=utf-8&useSSL=false
spring.datasource.username=
spring.datasource.password=

#druid连接池配置
#指定druid数据源(不指定则使用默认数据源)
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
#默认开启此路径
spring.datasource.druid.stat-view-servlet.url-pattern=/druid/*                      */
#初始化时建立物理连接的个数
spring.datasource.druid.initial-size=5
#最小连接池数量
spring.datasource.druid.min-idle=5
#最大连接池数量
spring.datasource.druid.max-active=20
#获取连接时最大等待时间，单位毫秒
spring.datasource.druid.max-wait=60000
#用来检测连接是否有效的sql 必须是一个查询语句
#mysql中为 select 'x'
#oracle中为 select 1 from dual
spring.datasource.druid.validation-query=select 'x'
##指定druid数据源(不指定则使用默认数据源)
#spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
##启用statFilter过滤器(默认关闭)
#spring.datasource.druid.web-stat-filter.enabled=true
##启用druid监控页面（如果关闭将不能进入druid管理界面）（默认关闭）
#spring.datasource.druid.stat-view-servlet.enabled=true
##指定过滤类型（SQL统计，URI统计，WEB统计等，可以在监控页面看到）
#spring.datasource.druid.filters=stat,wall,slf4j
#
##设置访问druid管理后台的路径（默认为/druid）
#spring.datasource.druid.stat-view-servlet.url-pattern=/druid/*      */
##设置druid拦截路径（默认为/*表示拦截所有请求）
#spring.datasource.druid.web-stat-filter.url-pattern=/*            */
##配置不需要监控的形式（比如一些图片，css，js，默认的）
#spring.datasource.druid.web-stat-filter.exclusions=*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*
##配置druid后台管理的账号密码（不设置表示不需要登录）
#spring.datasource.druid.stat-view-servlet.login-username=root
#spring.datasource.druid.stat-view-servlet.login-password=123456

#pagehelper分页插件配置
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql

pom文件

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.3.0.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.logistics</groupId>
    <artifactId>logistics</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>logistics</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <!--配置方式项目编码-->
        <project.build.sourceEncoding>UTF8</project.build.sourceEncoding>
        <!--配置项目编译打包的java版本-->
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>
        <java.version>1.8</java.version>
        <mybatis.version>1.3.2</mybatis.version>
        <druid.version>1.1.10</druid.version>
        <lombok.version>1.18.8</lombok.version>
        <fastjson.version>1.2.49</fastjson.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>${fastjson.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-aop</artifactId>
        </dependency>
        <!-- 分页插件pagehelper -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.5</version>
        </dependency>


        <!--        模板引擎-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <!-- 连接池  -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>${druid.version}</version>
        </dependency>
        <!-- mybatis 支持-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>${mybatis.version}</version>
        </dependency>
        <!--mysql数据库依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.48</version>
        </dependency>
        <!--提供getter，setter减少代码量-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>

        <dependency>
            <groupId>redis.clients</groupId>
            <artifactId>jedis</artifactId>
            <version>2.9.0</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>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

首页

<!DOCTYPE html>
<html lang="zh-cn" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>首页</title>
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!--bootstrap要导入的文件-->
    <script th:src="@{/js/jquery-1.12.4.js}"></script>
    <link th:href="@{/css/bootstrap.css}" rel="stylesheet"/>
    <script th:src="@{/js/bootstrap.js}"></script>
    <!-- 远程调用   -->
    <!--    <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.css" rel="stylesheet">-->

    <style>
        body {
            padding-top: 50px;
        }

        .img-ads {
            width: 495px;
            height: 300px;
        }

        .product {
            height: 400px;
        }

        .product img {
            max-height: 200px;
        }

        .new {
            position: absolute;
            top: -2px;
            right: -1px;
        }
    </style>
</head>
<body>
<div th:include="header::headnav"></div>
<div class="container">
    <div class="page-header">
        <div class="row">
            <h3 class="bg-success"> <span class="glyphicon glyphicon-bed"></span>   顶级物流，光有多快，我们就有多快！</h3>
            <!--    Carousel:轮播图-->
            <div id="carousel-example" class="carousel slider" data-ride="carousel" >
                <ol class="carousel-indicators">
                    <!--            正下方的切换小圆点，data-target对应ID-->
                    <li data-target="#carousel-example" data-slide-to="0" class="active"></li>
                    <li data-target="#carousel-example" data-slide-to="1"></li>
                    <li data-target="#carousel-example" data-slide-to="2"></li>
                </ol>
                <!--        图片设置区域-->
                <div class="carousel-inner" role="listbox" >
                    <div class="item active">
                        <img th:src="@{/img/2.jpg}" style="height: 1013px;width: 1698px" >
                        <!--                图片介绍部分-->
                        <div class="carousel-caption">
                            图片一
                        </div>
                    </div>

                    <div class="item">
                        <img th:src="@{/img/3.jpg}" style="height: 1013px;width: 1698px" >
                        <div class="carousel-caption">
                            图片二
                        </div>
                    </div>

                    <div class="item">
                        <img th:src="@{/img/mac.jpeg}"  >
                        <div class="carousel-caption">
                            图片三
                        </div>
                    </div>
                </div>

                <!--        切换图片的标签-->
                <a class="left carousel-control" href="#carousel-example" role="button" data-slide="prev">
                    <span class="glyphicon glyphicon-align-left" aria-hidden="true"></span>
                    <span class="sr-only">Previous</span>
                </a>
                <a class="right carousel-control" href="#carousel-example" role="button" data-slide="next">
                    <span class="glyphicon glyphicon-align-right" aria-hidden="true"></span>
                    <span class="sr-only">Next</span>
                </a>
            </div>
        </div>
        <h3>
            顶级物流，光有多快，我们就有多快！
            <a href="#"><small class="pull-right">值得信赖！</small></a>
        </h3>
    </div>
</div>

</body>
</html>