企业官网建设流程全解析

做网站的好处在哪里,展览设计网站推荐,网页制作和网站建设,qq是哪个国家公司开发的软件有一个这样子的需求#xff0c;线上正在跑的业务#xff0c;由于业务发展需要#xff0c;需重新开发一套新系统#xff0c;等新系统开发完成后#xff0c;需要无缝对接切换#xff0c;当初具体设计见草图。添加依赖#!--lombok--dependencygroupId线上正在跑的业务由于业务发展需要需重新开发一套新系统等新系统开发完成后需要无缝对接切换当初具体设计见草图。添加依赖#!--lombok-- dependency groupIdorg.projectlombok/groupId artifactIdlombok/artifactId version1.18.16/version !--scopeprovided说明它是在编译阶段生效不需要打入包中Lombok在编译期将带Lombok注解的Java文件正确编译为完整的Class文件-- scopeprovided/scope /dependency !--mysql-- dependency groupIdmysql/groupId artifactIdmysql-connector-java/artifactId /dependency !--mybatis plus和spring boot整合-- dependency groupIdcom.baomidou/groupId artifactIdmybatis-plus-boot-starter/artifactId version3.4.0/version /dependency dependency groupIdcom.alibaba/groupId artifactIddruid/artifactId version1.1.10/version /dependencyapplication.properties#server.port9999 spring.datasource.master.driver-class-namecom.mysql.cj.jdbc.Driver spring.datasource.master.urljdbc:mysql://127.0.0.1/test?useUnicodetruecharacterEncodingutf-8useSSLfalse spring.datasource.master.usernameroot spring.datasource.master.passwordroot spring.datasource.slave.driver-class-namecom.mysql.cj.jdbc.Driver spring.datasource.slave.jdbc-urljdbc:mysql://127.0.0.1/test2?useUnicodetruecharacterEncodingutf-8useSSLfalse spring.datasource.slave.usernameroot spring.datasource.slave.passwordroot2种方式创建DataSource#Master配置使用druid连接池#import com.alibaba.druid.pool.DruidDataSource; import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean; import org.apache.ibatis.session.SqlSessionFactory; import org.mybatis.spring.annotation.MapperScan; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.Primary; import org.springframework.core.env.Environment; import javax.sql.DataSource; /** * Authorchenyanbin */ Configuration MapperScan(basePackages com.example.demo.mapper, sqlSessionFactoryRef masterSqlSessionFactory) public class MasterDataSourceConfig { Autowired private Environment env; Primary Bean(name masterDataSource) // ConfigurationProperties(spring.datasource.master) public DataSource masterDataSource() { // return DataSourceBuilder.create().build(); DruidDataSource dataSource new DruidDataSource(); dataSource.setUrl(env.getProperty(spring.datasource.master.url)); dataSource.setUsername(env.getProperty(spring.datasource.master.username)); dataSource.setPassword(env.getProperty(spring.datasource.master.password)); dataSource.setDriverClassName(env.getProperty(spring.datasource.master.driver-class-name)); //配置初始化大小、最小、最大 dataSource.setMinIdle(10); //配置初始化大小、最小、最大 dataSource.setMaxActive(200); //配置初始化大小、最小、最大 dataSource.setInitialSize(10); //配置获取连接等待超时的时间 dataSource.setMaxWait(60000); //配置一个连接在池中最小生存的时间,单位是毫秒 dataSource.setMinEvictableIdleTimeMillis(300000); //配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 dataSource.setTimeBetweenEvictionRunsMillis(60000); //默认的testWhileIdletrue,testOnBorrowfalse,testOnReturnfalse dataSource.setValidationQuery(SELECT 1); //申请连接时执行validationQuery检测连接是否有效 dataSource.setTestOnBorrow(false); //建议配置为true不影响性能并且保证安全性。 dataSource.setTestWhileIdle(true); //是否缓存preparedStatement也就是PSCache dataSource.setPoolPreparedStatements(false); return dataSource; } Bean(name masterSqlSessionFactory) public SqlSessionFactory sqlSessionFactory(Qualifier(masterDataSource) DataSource dataSource) throws Exception { MybatisSqlSessionFactoryBean sessionFactoryBean new MybatisSqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); return sessionFactoryBean.getObject(); } }Slave配置#import com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean; import org.apache.ibatis.session.SqlSessionFactory; import org.mybatis.spring.annotation.MapperScan; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.boot.context.properties.ConfigurationProperties; import org.springframework.boot.jdbc.DataSourceBuilder; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import javax.sql.DataSource; /** * Authorchenyanbin */ Configuration MapperScan(basePackages com.example.demo.mapper2,sqlSessionFactoryRef slaveSqlSessionFactory) public class SlaveDataSourceConfig { Bean(name slaveDataSource) ConfigurationProperties(spring.datasource.slave) public DataSource slaveDataSource(){ return DataSourceBuilder.create().build(); } Bean(name slaveSqlSessionFactory) public SqlSessionFactory sqlSessionFactory(Qualifier(slaveDataSource) DataSource dataSource) throws Exception { MybatisSqlSessionFactoryBean sessionFactoryBean new MybatisSqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); return sessionFactoryBean.getObject(); } }注意#master和slave扫描不同的mapper包路径如果需要指定.xml文件需这样配置Bean(name masterSqlSessionFactory) public SqlSessionFactory sqlSessionFactory(Qualifier(masterDataSource) DataSource dataSource) throws Exception { MybatisSqlSessionFactoryBean sessionFactoryBean new MybatisSqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); sessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver() .getResources(classpath:mapper/**/*.xml)); return sessionFactoryBean.getObject(); }启动类#SpringBootApplication( exclude {DataSourceAutoConfiguration.class, MybatisPlusAutoConfiguration.class} )启动类上排查自动装配使用我们自定义的多数据源演示#多个数据源同时也是支持事务的