SpringBoot+Mybatis+thymeleaf+gradle+idea 项目搭建打包运行

﹏ヽ暗。殇╰゛Y 2022-05-14 08:47 191阅读 0赞

# 一、 项目构建 #

## 1. 项目总览 ##

![70][]

## 2. 构建gradle项目： ##

![70 1][]

##  3. 创建子模块 ##

![70 2][]

##  4. 配置子模块下build.gradle文件： ##

apply plugin: 'application'
    
    group 'com.hsm.ls'
    version '1.0-SNAPSHOT'
    
    mainClassName = "com.hsm.ls.collection.web.CollectionWebStartApplication"
    
    
    sourceCompatibility = 1.8
    
    [compileJava, compileTestJava]*.options*.encoding = 'UTF-8'
    
    repositories {
    //    mavenCentral()
        maven {
            url "http://maven.iflytek.com:8081/nexus/content/groups/public/"
        }
        maven {
            url 'http://maven.aliyun.com/nexus/content/groups/public/'
        }
    }
    
    dependencies {
        testCompile group: 'junit', name: 'junit', version: '4.12'
    
        compile ("org.springframework.boot:spring-boot-starter:2.0.0.RELEASE")
        compile("org.springframework.boot:spring-boot-starter-web:2.0.0.RELEASE")
        compile("org.springframework.boot:spring-boot-starter-thymeleaf:2.0.0.RELEASE")
        compile ('org.springframework:spring-jdbc:4.3.12.RELEASE')
    
        compile ('com.iflytek.dubbo:common-dubbo-framework:1.2.0-SNAPSHOT')
                {
                    exclude group: 'org.apache.solr'
                }
        compile ('com.iflytek.aisp:aisp-service-biz-api:1.0.0-SNAPSHOT')
    
        compile ("org.apache.poi:poi:3.15")
        compile ("org.apache.poi:poi-ooxml:3.15")
    
        compile ('c3p0:c3p0:0.9.1.2')
        compile ('org.mybatis:mybatis:3.2.3')
        compile ('org.mybatis:mybatis-spring:1.2.3')
        compile ('mysql:mysql-connector-java:6.0.3')
    
    }
    
    distributions() {
        main {
            baseName = "collection-web"
            contents {
                from("src/main/resources") {
                    into "conf"
                }
            }
        }
    }

## 5. 编写启动类： ##

package com.hsm.ls.collection.web;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.context.annotation.ImportResource;
    
    /**
     * Created by lfx on 2018/8/30.
     */
    @SpringBootApplication
    //@ImportResource(locations = "classpath:server-web.xml")
    public class CollectionWebStartApplication {
    
        public static void main(String[] args) {
            SpringApplication application = new SpringApplication(CollectionWebStartApplication.class);
            application.run(args);
            System.out.println("started collection-tool-web server success.");
        }
    }

## 6. 测试启动是否成功 ##

若启动成功则继续进行，若有问题则排查问题直到启动成功

## 7. 配置application.yml ##

server:
      port: 8080
    
    #thymeleaf
    spring:
      thymeleaf:
        mode: HTML5
        encoding: UTF-8
    #    content-type: text/html
        #开发时关闭缓存,不然没法看到实时页面
        cache: false
    
    # db config
    jdbc:
      engine:
        driverClass: com.mysql.jdbc.Driver
        jdbcUrl: jdbc:mysql://127.0.0.1:3306/db1?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false&allowMultiQueries=true&useSSL=false
        user: root
        password: 123456
      biz:
        driverClass: com.mysql.jdbc.Driver
        jdbcUrl: jdbc:mysql://127.0.0.1:3306/db2?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false&allowMultiQueries=true&useSSL=false
        user: root
        password: 123456
      # 初始化连接池中的连接数，取值应在minPoolSize与maxPoolSize之间，默认为3
      initialPoolSize: 5
      # 最大空闲时间，60秒内未使用则连接被丢弃。若为0则永不丢弃。默认值: 0
      maxIdleTime: 60
      # 连接池中保留的最大连接数。默认值: 15
      maxPoolSize: 15
      # 连接池中保留的最小连接数，默认为：3
      minPoolSize: 5
      # 当连接池连接耗尽时，客户端调用getConnection()后等待获取新连接的时间，超时后将抛出SQLException，如设为0则无限期等待。单位毫秒。默认: 0
      checkoutTimeout: 5000
      # 当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。默认值: 3
      acquireIncrement: 5
      # 定义在从数据库获取新连接失败后重复尝试的次数。默认值: 30 ；小于等于0表示无限次
      acquireRetryAttempts: 10
      # 重新尝试的时间间隔，默认为：1000毫秒
      acquireRetryDelay: 1000
      # 每120秒检查所有连接池中的空闲连接。默认值: 0，不检查
      idleConnectionTestPeriod: 120
    logging:
      level:
        com: debug

该项目用到了双库，且必须设置时区，不需要的小伙伴可去掉时区设置或者去掉双库，按照需求来定。

** 时区：jdbcUrl中的serverTimezone=GMT%2B8可去掉**

## 8. 数据库连接配置类： ##

![70 3][]

由于该项目需要使用到双库，故有两个配置类，配置类如下：

package com.hsm.ls.collection.web.service;
    
    import com.mchange.v2.c3p0.ComboPooledDataSource;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.context.annotation.Bean;
    import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    import org.springframework.stereotype.Component;
    
    import java.beans.PropertyVetoException;
    
    /**
     * Created by lfx on 2018/8/10.
     */
    @Component
    @MapperScan(
            basePackages = {"com.hsm.ls.collection.web.mapper.biz"},
            sqlSessionFactoryRef = "flowBizSqlSessionFactory"
    )
    public class FlowBizDbConfig {
    
        @Value("${jdbc.biz.jdbcUrl}")
        private String jdbcUrl;
        @Value("${jdbc.biz.user}")
        private String user;
        @Value("${jdbc.biz.password}")
        private String password;
        @Value("${jdbc.initialPoolSize}")
        private int initialPoolSize;
        @Value("${jdbc.maxIdleTime}")
        private int maxIdleTime;
        @Value("${jdbc.maxPoolSize}")
        private int maxPoolSize;
        @Value("${jdbc.minPoolSize}")
        private int minPoolSize;
        @Value("${jdbc.checkoutTimeout}")
        private int checkoutTimeout;
        @Value("${jdbc.acquireIncrement}")
        private int acquireIncrement;
        @Value("${jdbc.acquireRetryAttempts}")
        private int acquireRetryAttempts;
        @Value("${jdbc.acquireRetryDelay}")
        private int acquireRetryDelay;
        @Value("${jdbc.idleConnectionTestPeriod}")
        private int idleConnectionTestPeriod;
    
        @Bean(name = "flowBizDataSource")
        public ComboPooledDataSource getDataSource() throws PropertyVetoException {
            ComboPooledDataSource dataSource = new ComboPooledDataSource();
            dataSource.setDriverClass("com.mysql.jdbc.Driver");
            dataSource.setJdbcUrl(jdbcUrl);
            dataSource.setUser(user);
            dataSource.setPassword(password);
            dataSource.setInitialPoolSize(initialPoolSize);
            dataSource.setMaxIdleTime(maxIdleTime);
            dataSource.setMaxPoolSize(maxPoolSize);
            dataSource.setMinPoolSize(minPoolSize);
            dataSource.setCheckoutTimeout(checkoutTimeout);
            dataSource.setAcquireIncrement(acquireIncrement);
            dataSource.setAcquireRetryAttempts(acquireRetryAttempts);
            dataSource.setAcquireRetryDelay(acquireRetryDelay);
            dataSource.setIdleConnectionTestPeriod(idleConnectionTestPeriod);
            return dataSource;
        }
    
        @Bean(name = "flowBizSqlSessionFactory")
        public SqlSessionFactory getSessionFactory(@Qualifier("flowBizDataSource") ComboPooledDataSource dataSource) throws Exception {
            SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
            factoryBean.setDataSource(dataSource);
            //开启驼峰命名转换
            factoryBean.getObject().getConfiguration().setMapUnderscoreToCamelCase(true);
            return factoryBean.getObject();
        }
    
        @Bean(name = "flowBizTrans")
        public DataSourceTransactionManager getTransactionManager(@Qualifier("flowBizDataSource") ComboPooledDataSource dataSource){
            DataSourceTransactionManager transactionManager = new DataSourceTransactionManager();
            transactionManager.setDataSource(dataSource);
            return transactionManager;
        }
    }

package com.hsm.ls.collection.web.service;
    
    import com.mchange.v2.c3p0.ComboPooledDataSource;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.context.annotation.Bean;
    import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    import org.springframework.stereotype.Component;
    
    import java.beans.PropertyVetoException;
    
    /**
     * Created by weiluo on 2017/11/27.
     */
    @Component
    @MapperScan(
            basePackages = {"com.hsm.ls.collection.web.mapper.engine"},
            sqlSessionFactoryRef = "flowEngineSqlSessionFactory"
    )
    public class FlowEngineDbConfig {
    
        @Value("${jdbc.engine.jdbcUrl}")
        private String jdbcUrl;
        @Value("${jdbc.engine.user}")
        private String user;
        @Value("${jdbc.engine.password}")
        private String password;
        @Value("${jdbc.initialPoolSize}")
        private int initialPoolSize;
        @Value("${jdbc.maxIdleTime}")
        private int maxIdleTime;
        @Value("${jdbc.maxPoolSize}")
        private int maxPoolSize;
        @Value("${jdbc.minPoolSize}")
        private int minPoolSize;
        @Value("${jdbc.checkoutTimeout}")
        private int checkoutTimeout;
        @Value("${jdbc.acquireIncrement}")
        private int acquireIncrement;
        @Value("${jdbc.acquireRetryAttempts}")
        private int acquireRetryAttempts;
        @Value("${jdbc.acquireRetryDelay}")
        private int acquireRetryDelay;
        @Value("${jdbc.idleConnectionTestPeriod}")
        private int idleConnectionTestPeriod;
    
        @Bean(name = "flowEngineDataSource")
        public ComboPooledDataSource getDataSource() throws PropertyVetoException {
            ComboPooledDataSource dataSource = new ComboPooledDataSource();
            dataSource.setDriverClass("com.mysql.jdbc.Driver");
            dataSource.setJdbcUrl(jdbcUrl);
            dataSource.setUser(user);
            dataSource.setPassword(password);
            dataSource.setInitialPoolSize(initialPoolSize);
            dataSource.setMaxIdleTime(maxIdleTime);
            dataSource.setMaxPoolSize(maxPoolSize);
            dataSource.setMinPoolSize(minPoolSize);
            dataSource.setCheckoutTimeout(checkoutTimeout);
            dataSource.setAcquireIncrement(acquireIncrement);
            dataSource.setAcquireRetryAttempts(acquireRetryAttempts);
            dataSource.setAcquireRetryDelay(acquireRetryDelay);
            dataSource.setIdleConnectionTestPeriod(idleConnectionTestPeriod);
            return dataSource;
        }
    
        @Bean(name = "flowEngineSqlSessionFactory")
        public SqlSessionFactory getSessionFactory(@Qualifier("flowEngineDataSource") ComboPooledDataSource dataSource) throws Exception {
            SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
            factoryBean.setDataSource(dataSource);
            //开启驼峰命名转换
            factoryBean.getObject().getConfiguration().setMapUnderscoreToCamelCase(true);
            return factoryBean.getObject();
        }
    
        @Bean(name = "flowEngineTrans")
        public DataSourceTransactionManager getTransactionManager(@Qualifier("flowEngineDataSource") ComboPooledDataSource dataSource){
            DataSourceTransactionManager transactionManager = new DataSourceTransactionManager();
            transactionManager.setDataSource(dataSource);
            return transactionManager;
        }
    
    }

分别对应mapper目录下的两个文件夹

![70 4][]

##  9. 编写dao层： ##

package com.hsm.ls.collection.web.mapper.biz;
    
    import com.hsm.ls.collection.web.domain.MarketBatchInfo;
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.SelectProvider;
    
    import java.util.List;
    
    /**
     * Created by lfx on 2018/9/3.
     */
    public interface MarketMapper {
    
        @SelectProvider(type = MarketProvider.class, method = "getBatchInfoList")
        public List<MarketBatchInfo> getBatchInfoByIdOrName(@Param("batchId") String batchId, @Param("batchName") String batchName);
    }

package com.hsm.ls.collection.web.mapper.biz;
    
    import org.apache.commons.lang3.StringUtils;
    
    import java.util.Map;
    
    /**
     * Created by lfx on 2018/9/3.
     */
    public class MarketProvider {
    
        /**
         * 获取满足条件的批次
         * @param params
         * @return
         */
        public String getBatchInfoList(Map<String,Object> params){
            String batchId = (String)params.get("batchId");
            String batchName = (String) params.get("batchName");
            StringBuilder sb = new StringBuilder();
            sb.append("select info.Id,info.BatchName,info.BusinessId,info.PlatTaskId from MarketBatchInfo info where 1=1 ");
    
            if(StringUtils.isNotBlank(batchId)){
                sb.append(" and info.id = " + batchId);
            }
            if(StringUtils.isNotBlank(batchName)){
                sb.append(" and info.BatchName LIKE '%"+batchName+"%' ");
            }
            return sb.toString();
        }
    
    }

## 10. controller层： ##

![70 5][]

##  11. 配置thymeleaf ##

见第七步，已配置。

##  12. 静态页 ##

![70 6][]

随便你写点啥  反正能正常访问即可。

###  若到此步皆正常，则可以放心开始填充业务和功能了~~~~   ###

# 二、 项目打包运行 #

# 1. dist文件夹： #

下次再写。。。。。 来活了md

[70]: /images/20220514/87a07c283be04521b7598c5b0246f9e1.png
[70 1]: /images/20220514/672d2aa7abff4ed281cdfc162f2ab081.png
[70 2]: /images/20220514/75938b1fa0e844a0990280c35db87617.png
[70 3]: /images/20220514/20064e4d76a84d5ca32ab42a2ee5d62f.png
[70 4]: /images/20220514/c4d5d368ab5246db9a28797ed52f320b.png
[70 5]: /images/20220514/b026e6b9fd844e1d875ef41f2beda41f.png
[70 6]: /images/20220514/13d561b5be5041b4843a8d00ccff746a.png