## 数据库访问配置 ## 主数据源,默认的 ##spring.datasource.druid.type=com.alibaba.druid.pool.DruidDataSource ##spring.datasource.druid.driver-class-name=com.mysql.jdbc.Driver #spring.datasource.druid.driver-class-name=com.mysql.cj.jdbc.Driver #spring.datasource.druid.url=jdbc:mysql://localhost:3306/zgdd?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC #spring.datasource.druid.username=root #spring.datasource.druid.password=root # 最大支持文件大小 spring.servlet.multipart.max-file-size=2000MB # 最大支持请求大小 spring.servlet.multipart.max-request-size=2000MB ## DataSource settings #spring.datasource.type=com.alibaba.druid.pool.DruidDataSource ##spring.datasource.url = jdbc:mysql://localhost:3306/zgdd?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai #spring.datasource.url = jdbc:mysql://39.100.252.34:3306/zgdd?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai #spring.datasource.username = root #spring.datasource.password = root #spring.datasource.driverClassName = com.mysql.jdbc.Driver spring.datasource.driver-class-name=com.p6spy.engine.spy.P6SpyDriver ## 测试库 spring.datasource.url=jdbc:p6spy:mysql://10.23.69.88:3306/zgdd?serverTimezone=Asia/Shanghai&allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8 ## 生产库 #spring.datasource.url=jdbc:p6spy:mysql://39.99.227.124:3306/zgdd?serverTimezone=Asia/Shanghai&allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8 spring.datasource.username = root spring.datasource.password = zgdd@2020 ## spring 配置 ## 如果配置了spring-resources,则必须包含classpath:/static/ ## 访问静态页面 /pages/指定路径为 /static/pages/ #spring.mvc.view.prefix=/ ## 静态页面后缀 #spring.mvc.view.suffix=.html ## 静态文件路径, 资源路径,博客路径 #spring.resources.static-locations=classpath:/static/ # 下面为连接池的补充设置,应用到上面所有数据源中 # 初始化大小,最小,最大 spring.datasource.druid.initial-size=5 spring.datasource.druid.minIdle=5 spring.datasource.druid.maxActive=20 # 配置获取连接等待超时的时间 spring.datasource.druid.maxWait=60000 # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 spring.datasource.druid.timeBetweenEvictionRunsMillis=60000 # 配置一个连接在池中最小生存的时间,单位是毫秒 spring.datasource.druid.minEvictableIdleTimeMillis=300000 spring.datasource.druid.validationQuery=SELECT 1 FROM DUAL spring.datasource.druid.testWhileIdle=true spring.datasource.druid.testOnBorrow=true spring.datasource.druid.testOnReturn=true # 打开PSCache,并且指定每个连接上PSCache的大小 spring.datasource.druid.poolPreparedStatements=true spring.datasource.druid.maxPoolPreparedStatementPerConnectionSize=20 # 配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙 spring.datasource.druid.filters=stat,wall,log4j # 通过connectProperties属性来打开mergeSql功能;慢SQL记录 spring.datasource.druid.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000 # 合并多个DruidDataSource的监控数据 #spring.datasource.druid.useGlobalDataSourceStat=true #中煤接口测试地址 ZMUrl=https://test.echinacoal.com/singlePlatform/ ZMIMGUrl=https://test.echinacoal.com/singlePlatform/others/ ZMSMSUrl=https://test.echinacoal.com/singlePlatform/prpall/ ZMToken=THIRDSCOuloft2020052818346904zmYBSX CallbackUrl=http://10.23.69.88:8080/zm/Underwriting RGCallbackUrl=http://10.23.69.88:8080/zm/ArtificialUnderwriting #中煤接口生产地址 #ZMUrl=https://www.echinacoal.com/singlePlatform/ #ZMIMGUrl=https://www.echinacoal.com/singlePlatform/others/ #ZMSMSUrl=https://www.echinacoal.com/singlePlatform/prpall/ #ZMToken=THIRDSCOuloft2020052818346904zmYBSXQYTQ #CallbackUrl=http://39.101.143.165:8080/zm/Underwriting #RGCallbackUrl=http://39.101.143.165:8080/zm/ArtificialUnderwriting #天安API测试参数 TASign=gIpr5j5haL7T8WJY7ZS54JdlYL/7PToQOy505Mr/iH3qN4SMpJJVdvxFE1/KsWH0EjDxR9qVwRC/t6kLCJo+Y1AB+FD1qNjkbLyEQ+9aeQEF2Af/4bJqUDArewHHT879o5IqzHg/lcg= TAModelUrl=https://testow.95505.cn/cpf/tianan_cpf/access/car/queryCarModel.mvc TAQuoteUrl=https://testow.95505.cn/cpf/tianan_cpf/access/car/premiumAccurate.mvc TAInsureUrl=https://testow.95505.cn/cpf/tianan_cpf/access/car/insureConfirmation.mvc TAPayUrl=https://testow.95505.cn/cpf/tianan_cpf/common/pay/applyPay.do TAUploadUrl=https://testow.95505.cn/cpf/tianan_cpf/access/car/thirdUploadAttach.mvc #天安API生产参数 #TASign=gIpr5j5haL7T8WJY7ZS54JdlYL/7PToQOy505Mr/iH3qN4SMpJJVdvxFE1/KsWH0EjDxR9qVwRC/t6kLCJo+Y1AB+FD1qNjkbLyEQ+9aeQEF2Af/4bJqUDArewHHT879o5IqzHg/lcg= #TAModelUrl=https://cpf.95505.cn/tianan_cpf/access/car/queryCarModel.mvc #TAQuoteUrl=https://cpf.95505.cn/tianan_cpf/access/car/premiumAccurate.mvc #TAInsureUrl=https://cpf.95505.cn/tianan_cpf/access/car/insureConfirmation.mvc #TAPayUrl=https://cpf.95505.cn/tianan_cpf/common/pay/applyPay.do #TAUploadUrl=https://cpf.95505.cn/tianan_cpf/access/car/thirdUploadAttach.mvc #文件上传路径测试 filePath=C:/soft/apache-tomcat-7.0.93/webapps/upload/ #文件上传路径生产 #filePath=/usr/local/apache-tomcat-7.0.93/webapps/upload/ #文件上传下载相关配置 # 路径带上前后斜杆 upload.basepath=${filePath} upload.host= upload.username= upload.password= upload.url=${netUrl} ##测试地址 netUrl=http://10.23.69.88:8080/ ##生产地址 #netUrl=http://39.101.143.165:8080/ #特殊账号 #Specialaccount= Specialaccount=99999999999999 #mybatis xml文件扫描路径 mybatis.mapper-locations=classpath:mapper/**/*.xml mybatis.type-aliases-package=com.ydtech.modules.*.model #================ mybatis pagehelper ==============# pagehelper.helper-dialect=mysql pagehelper.reasonable=true pagehelper.support-methods-arguments=true pagehelper.params=count=countSql #================ 中保信接口对接--开始==============# ##接口地址 cbit.url_pre=http://88.88.1.51:5017 cbit.api2=/pjms/insurance/open/unify/order/getInitParams cbit.api3=/pjms/insurance/open/unify/order/generateOrderNo cbit.api4=/pjms/insurance/open/unify/vehicle/getTMBVerificationCode cbit.api5=/pjms/insurance/open/unify/vehicle/queryVehicleModel cbit.api6=/pjms/insurance/open/unify/vehicle/confirmVehicle cbit.api7=/pjms/insurance/open/unify/order/quote cbit.api8=/pjms/insurance/open/unify/order/postUnderwriting cbit.api9=/pjms/insurance/open/unify/order/applyPay cbit.api10=/pjms/insurance/open/unify/order/cancelUnderwriting cbit.api11=/pjms/insurance/open/unify/order/getVerificationCode cbit.api12=/pjms/insurance/open/unify/order/commitVerificationCode cbit.api14=/pjms/insurance/open/unify/order/sendEleApplicationSign cbit.api17=/pjms/insurance/open/unify/order/viewToPay cbit.api18=/pjms/insurance/open/unify/order/queryPolicy ##其他 ###中介机构id cbit.franchiserId=taiyuantianqin-001 cbit.franchiserChannelId_pingan=HNtj143y cbit.franchiserChannelCode_pingan=QIAOYRXX-00001 cbit.carDealerCode_pingan=224189117001 cbit.insurerBranchCode_pingan=130000 cbit.franchiserChannelId_taiping=SX00113 cbit.groupCode_taiping=S132001 cbit.insurerBranchCode_taiping=140000 cbit.franchiserChannelId_taipingyang=YBX_3020100 cbit.insurerBranchCode_taipingyang=320000 ###ip地址 cbit.ip=10.23.69.89 ### 中介平台-加解密秘钥对 私钥+公钥 cbit.ZJPT_PRIVATE_KEY=MIICdQIBADANBgkqhkiG9w0BAQEFAASCAl8wggJbAgEAAoGBAMpskeUA+JfNr0Dsx+zZwu/KwprkaN0y0bVBC/ygAOQCBx26NGrRodWM0VehWbtvUN2WEQB2EpcntfJj/bOgRumhThjHMh+2WgdnS93+Ti+ACDlt4f3vaOlZmPo3cRH4SBHvf5SLSnSl1chGMMXijyZZIvDxbxn3d4gu0uDQNw4jAgMBAAECgYAyOnqBPppw4KLqE1cQmIBcjA157c9vg9qxhTB6QSG3ciFd6QR0tQvZN5YCjpD7h4WjVkdlu+alBz+Io/MiDVVK1qt+EsqWBKSx7fAi5UFmoVPHcmw7ZrnBmQLlduo9CUbyTQKGvVlEY+lHwRjuko40jSDRJQVHCbIDc/kxmipukQJBAOqf44+b+agA3RJBYLPqsaUShK8ykor2nZptUNFtMBiuGPuQ0sT3cfZMB9upc586ckFDZcqChqFLUAfpmgMIgYUCQQDc3ay6RJ9owqkkPTKeeppeZqDoD5Nk3nipuMyJwTL0GR0A1AfUXcA0F8BxEQob1k65Tcw7ol2j7DmRqjA8uw2HAkAr92RUT/07r1W+CwRNEsjRTyQQFKEDa21jN+LyK8zcgxtpYN0uTdRMPDkov5tMFk68zh1wEn+aEBviL7NNqDVlAkBlu6mzBqbSj09vhMzLGLgAIY+eNIZ04NB9hMSZ8yawLt0gI4oTtLcyh3o52lpophcO3ZnkIg610bpWsSiU4KgDAkA+vyBe7spxLR1S/k4FhPP9YZay6vmuzwzSNUKF5JquTLuI9iqZRf+n3Yfy6wgQzkP2WIeQDRe074p09MFGc+pp cbit.ZJPT_PUBLIC_KEY=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDKbJHlAPiXza9A7Mfs2cLvysKa5GjdMtG1QQv8oADkAgcdujRq0aHVjNFXoVm7b1DdlhEAdhKXJ7XyY/2zoEbpoU4YxzIftloHZ0vd/k4vgAg5beH972jpWZj6N3ER+EgR73+Ui0p0pdXIRjDF4o8mWSLw8W8Z93eILtLg0DcOIwIDAQAB ### 合作伙伴-加解密秘钥对 私钥+公钥 cbit.HZHB_PRIVATE_KEY=MIICeAIBADANBgkqhkiG9w0BAQEFAASCAmIwggJeAgEAAoGBAJnWpyVLFBli1kakBXUjk/SmH+X1X0kGGik0ub1MXnNUOk9NBqRQjO6G9A6wdiGzo9j9w26u5u9R6R6De843YMhgW6iIoDodexvZzInxTE+YY52iUBDCcksHYAM7uHZBtdXKovm+bEzL0nwa89Xw6zyuCm8x7enoDiVzs/75WoqrAgMBAAECgYAnEcC5U+vy1oscvaM1MKfuxhHr0Pk2DnquZFmXncGPAKEeaq15JYvlOBjbci1OOdUu0qPDhF/Z/694tGPI53+If0MkS3VpxaOYc+i/G/KQiYZIu1hjUb2F8j8xQrF60WkIsqwzjJYF9T5MCjLEZvDg9cPzFY+QpS8yl5Cbl0aOYQJBAMd+0VtQYV9q3nsZgEk4ux6Vz19SakRbk9zkz1yBUKRfWcLa1T9DleaBqGdkdZbO8v6PCtyz6Fdymq+USYWeV3UCQQDFaU5O8GeNr07J6quTgHgsbN8IV28Wp4wKmDAXCWlehkGGoTm11FOL2zxItjgmmHGyXBA08osPCojBPptOazWfAkEAmG3K04WwUPLcOZy7i7cAKpd3ErNrJP4AFcjytBDOqDl+4UbJp4QhljW9kfqNaoSH4H81YntIbQDRNpUMND9PPQJBAKWfnBuOhtLQagHt6NVvy2M6VETjVkhjeZLJ7E7njofHi+IwEgMDiLSl0wYOGz4GWB2UL+S8OP79j47Rv+si93ECQQCNqD8nMcVXIHKze7aM9c8v1yfgEdk8IpVhAbiXbRs3ANTT4Jx2M6GNBEeEAorHqO4eOTxdObNuz/RADoRnpzHk cbit.HZHB_PUBLIC_KEY=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCZ1qclSxQZYtZGpAV1I5P0ph/l9V9JBhopNLm9TF5zVDpPTQakUIzuhvQOsHYhs6PY/cNurubvUekeg3vON2DIYFuoiKA6HXsb2cyJ8UxPmGOdolAQwnJLB2ADO7h2QbXVyqL5vmxMy9J8GvPV8Os8rgpvMe3p6A4lc7P++VqKqwIDAQAB #================ 中保信接口对接--结束==============# resp_json={"status":"Z00001","msg":"success","data":{"invoiceType":[],"payWayList":[{"payWayCode":"Z000005"}],"switchList":[{"cityName":null,"insurerId":null,"configCode":"Z00002","configValue":"ON","remark":"需要电子签名"},{"cityName":null,"insurerId":null,"configCode":"Z00009","configValue":"ON","remark":"需要前端提交跳转收银台支付"},{"cityName":null,"insurerId":null,"configCode":"Z00007","configValue":"ON","remark":"需要后置车型确认"},{"cityName":null,"insurerId":null,"configCode":"Z00001","configValue":"ON","remark":"需要发送短信(手机实名验证)"}]},"insurerId":"000108","baseParam":{"requestNo":"baodafang-00197e79fcc-f39c-4c54-86fc-a88668b0647e"},"success":true} #================ 阿里云部署对接保信服务器--开始==============# aly.cbit.url_pre=http://223.70.186.115:8080/CBIT/API/insCBIT aly.pay.url_pre=http://test.baoxianzhanggui.com:8080 aly.pay.html_path=C:\soft\apache-tomcat-7.0.93\webapps\html\ #================ 阿里云部署对接保信服务器--结束==============# #================ 保信回调阿里云接服务器--开始==============# cbit.aly.url_pre=http://47.92.254.66:8080/API/insCBIT #================ 阿里云部署对接保信服务器--结束==============#