网站开发公司的选择,网络营销与推广的概念,wordpress编辑栏不见了,网站开发报价单 doc巩固基础#xff0c;砥砺前行 。 只有不断重复#xff0c;才能做到超越自己。 能坚持把简单的事情做到极致#xff0c;也是不容易的。
SpringBoot JavaEE 简介
JavaEE的局限性#xff1a; 1、过于复杂#xff0c;JavaEE正对的是复杂的分布式企业应用#xff0c;然而现实…巩固基础砥砺前行 。 只有不断重复才能做到超越自己。 能坚持把简单的事情做到极致也是不容易的。
SpringBoot JavaEE 简介
JavaEE的局限性 1、过于复杂JavaEE正对的是复杂的分布式企业应用然而现实情况是大部分应用都是比较简单复杂的架构带来了复杂的开发方式和部署方式。
2、最求分布式大部分引用并非都是JavaEE 嘉定的分布式系统Spring曾经反对过这种分布式架构并只提供了容器管理名词获得了成功大型应用采用分布式架构不可避免Spring提供了其他的技术支持egRestFul架构
3、不能及时和流行开源技术整合比如消息处理除了有了标准的JMS支持现在还有新能更好的RabbitMQ和kalfa。JavaEE 并没有与之相对应的标准方二十Spring具有统一的实现消息处理模式
4、JavaEE 应用服务器都有商业公司提供价格不菲少有公司采用管理引用服务器和部署应用对初学者和自学者有一定门槛
Spring Spring通过ioc管理bean通过Aop方式增强bean功能它没有像JavaEE那样纤细规定容器提供的是何种服务和容器运行的具体组件类型。
Spring的缺点 尽管Spring很强大但是他也有JavaEE的缺点
1、使用门槛升高要入门spring需要较长时间
2、对过时技术支持导致使用复杂度升高
3、xml配置已经不再是流行的系统配置方式
4、集成第三方工具的时候程序员还要考虑工具之间的兼容性
5、系统启动慢不具备热部署功能完全依赖虚拟机或者web服务器的热部署
SpringBoot springboot简化了spring应用配置不需要配置就能就能运行spring应用springboot管理spring容器、第三方插件并提供了许多默认系统级的服务。大部分的spring应用无论是简单还是复杂都只需要少量的配置和代码就能完成。springboot通过starter来提供系统级别的服务。在使用的时候在pom.xml中引入对应的starter即可使用。
相比于springspringboot优点
1、实现约定大于配置是一个低配置的应用系统架构不像spring那样需要大量的配置。仅仅需要少量的配置就能完成大量的功能
2、提供了内置的tomcat或者jetty功能
3、通过加载jar包管理、自动装配技术容易支持与其他技术体系、工具集成
4、支持热加载开发体检好也支持springboot监控方便了解系统运行情况。
springboot 配置、加载
加载外部类的几种方式
使用Configuration Bean 的方式引入使用Configuration ImportResource 方式引入使用Configuration Import 方式引入
加载配置文件中的属性的方式
Value(“${}”) 加载单一的配置文件
person.last-name张三3333333333${random.uuid}
application.properties 文件中
Value(${person.last-name})
private String lastName;
使用Component、ConfigurationProperties(prefix “person”) 从全局的默认配置文件中加载属性
Component
ConfigurationProperties(prefix person)
public class Person {}application.properties文件中
person.last-name张三3333333333${random.uuid}
person.age${random.int}
person.birth2017/12/15
person.bossfalse
person.maps.k1v1
person.maps.k214
person.listsa,b,c
person.dog.name${person.hello:hello}_dog
person.dog.age15使用 Component、ConfigurationProperties 、PropertySource 三个注解 从指定位置加载属性
PropertySource(value {classpath:person.properties})
Component
ConfigurationProperties(prefix person)
public class Person {private String lastName;private Integer age;private Boolean boss;private Date birth;private MapString,Object maps;private ListObject lists;private Dog dog;
}
classPath 路径下 person.properties 文件中
person.last-name李四
person.age12
person.birth2017/12/15
person.bossfalse
person.maps.k1v1
person.maps.k214
person.listsa,b,c
person.dog.namedog
person.dog.age15
profiles
application.yml 中的文档块模式 server:port: 8081
spring:profiles:active: prod # 激活指定配置文件---
server:port: 8083
spring:profiles: dev---server:port: 8084
spring:profiles: prod # 该文件被激活在启动jar包的时候 动态指定jar的端口号
java -jar demo.jar --spring.profiles.activedev配置虚拟机参数
-Dspring.profiles.activedev在启动jar的时候指定外部的配置文件 java -jar demo.jar --spring.config.locationG:/application.properties配置文件的加载顺序
在相同位置的application.properties 和application.yml 配置文件的加载顺序从上到下加载谁在上就加载谁
application.propertiesserver.port8082application.ymlserver:port: 8081
application.properties 在 application.yml 之上,所以启动的端口号 是8082 maven简介
maven实现的目标
是构建项目变得同意maven屏蔽了构建的复杂过程统一了构建下项目的方式不同人、不同公司的羡慕都有同样的描述和构建项目的方式。maven通过pom.xml来描述项目并提供了一系列插件来构建项目。提出了一套开发项目的最佳实践。而不用每个项目都有不同机构和构建方式。比如源代码出现在scr/main/java中测试代码出现在scr/main/test中项目需要的配置文件放在scr/main/resources中包含不同环境项目的构建方式解决了依赖的问题只要申明使用的类库maven会自动冲仓库下载依赖的jar包并能协助你管理jar之间的冲突
pom中元素介绍
groupId 表示项目所属的组通常是一个公司或者组织的名称。如。org.springframework artifactId 项目的唯一标识如。spring-boot-start-web。groupId 和 artifactId 能唯一标识一个项目或者一个库通常称之为项目坐标。 packaging 项目类型常用的有jar和war两种 version 项目的版本号。通常来说项目版本号分为三段主版本、此版本、修订版本 主版本代表脚骨变动或者不见同实现 次版本是兼容性修改功能增强 修订版bug修复 modelVersion 代表pom文件的maven版本。 scope scope 代表次类库和项目的关系默认是compile也就是编译和打包都需要此类库。 test仅仅在单元测试的时候需要 provided标识在编译阶段需要词此类库但是打包不需要因为项目的目标环境已经提供了 runtime标识在编译和打包的时候都不需要但是在运行的时候需要 build 此项目在pom中可选build包含多个插件plugin用来辅助构建项目 面试的时候问过scope spring boot 发送邮件
1.引入jar
dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-mail/artifactId
/dependency2.application.yml配置
spring: mail: #发送消息的邮箱配置username: XXXqq.com#password是QQ邮箱的授权码 password: snnaaprastgfdebghost: smtp.qq.comproperties: mail: smtp: ssl: enable: true3.发送简单文本信息
Autowired
JavaMailSenderImpl mailSender;public void testContext() {SimpleMailMessage message new SimpleMailMessage();//邮件设置message.setSubject(Topic主题);message.setText(Message……);//发送到哪里message.setTo(XXX163.com);//从哪里发送message.setFrom(XXXqq.com);mailSender.send(message);
}4.发送带有附件的 public void testAA() throws Exception{//1、创建一个复杂的消息邮件MimeMessage mimeMessage mailSender.createMimeMessage();MimeMessageHelper helper new MimeMessageHelper(mimeMessage, true);//邮件设置helper.setSubject(XXXX);helper.setText(b stylecolor:redCCCC/b,true);helper.setTo(15513163.com);helper.setFrom(291506qq.com);//上传文件helper.addAttachment(1.jpg,new File(C:\\Users\\DELL\\Pictures\\1.jpg));helper.addAttachment(2.mp4,new File(C:\\\\Users\\\\DELL\\\\Pictures\\\\2.mp4));mailSender.send(mimeMessage);}springboot和redis缓存
redis缓存
1在pom中新增 dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-data-redis/artifactId/dependency2)在application.yml中新增redis配置.ookk spring: redis: host: localhost3配置redis序列化
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.redis.connection.RedisConnectionFactory;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.data.redis.serializer.Jackson2JsonRedisSerializer;
import org.springframework.data.redis.serializer.StringRedisSerializer;import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.PropertyAccessor;
import com.fasterxml.jackson.databind.ObjectMapper;Configuration
public class MyRedisConfig {Beanpublic RedisTemplateObject, Object redisTemplate(RedisConnectionFactory redisConnectionFactory) {RedisTemplateObject, Object redisTemplate new RedisTemplate();redisTemplate.setConnectionFactory(redisConnectionFactory);// 使用Jackson2JsonRedisSerialize 替换默认序列化Jackson2JsonRedisSerializer jackson2JsonRedisSerializer new Jackson2JsonRedisSerializer(Object.class);ObjectMapper objectMapper new ObjectMapper();objectMapper.setVisibility(PropertyAccessor.ALL, JsonAutoDetect.Visibility.ANY);objectMapper.enableDefaultTyping(ObjectMapper.DefaultTyping.NON_FINAL);jackson2JsonRedisSerializer.setObjectMapper(objectMapper);// 设置value的序列化规则和 key的序列化规则redisTemplate.setValueSerializer(jackson2JsonRedisSerializer);redisTemplate.setKeySerializer(new StringRedisSerializer());redisTemplate.afterPropertiesSet();return redisTemplate;}
}java操作redis工具类
import java.util.Collection;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.concurrent.TimeUnit;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.redis.core.BoundSetOperations;
import org.springframework.data.redis.core.HashOperations;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.data.redis.core.ValueOperations;
import org.springframework.stereotype.Component;
SuppressWarnings(value { unchecked, rawtypes })
Component
public class RedisCache
{Autowiredpublic RedisTemplate redisTemplate;/*** 缓存基本的对象Integer、String、实体类等** param key 缓存的键值* param value 缓存的值*/public T void setCacheObject(final String key, final T value){redisTemplate.opsForValue().set(key, value);}/*** 缓存基本的对象Integer、String、实体类等** param key 缓存的键值* param value 缓存的值* param timeout 时间* param timeUnit 时间颗粒度*/public T void setCacheObject(final String key, final T value, final Integer timeout, final TimeUnit timeUnit){redisTemplate.opsForValue().set(key, value, timeout, timeUnit);}/*** 设置有效时间** param key Redis键* param timeout 超时时间* return true设置成功false设置失败*/public boolean expire(final String key, final long timeout){return expire(key, timeout, TimeUnit.SECONDS);}/*** 设置有效时间** param key Redis键* param timeout 超时时间* param unit 时间单位* return true设置成功false设置失败*/public boolean expire(final String key, final long timeout, final TimeUnit unit){return redisTemplate.expire(key, timeout, unit);}/*** 获得缓存的基本对象。** param key 缓存键值* return 缓存键值对应的数据*/public T T getCacheObject(final String key){ValueOperationsString, T operation redisTemplate.opsForValue();return operation.get(key);}/*** 删除单个对象** param key*/public void deleteObject(final String key){redisTemplate.delete(key);}/*** 删除集合对象** param collection 多个对象* return*/public void deleteObject(final Collection collection){redisTemplate.delete(collection);}/*** 缓存List数据** param key 缓存的键值* param dataList 待缓存的List数据* return 缓存的对象*/public T long setCacheList(final String key, final ListT dataList){Long count redisTemplate.opsForList().rightPushAll(key, dataList);return count null ? 0 : count;}/*** 获得缓存的list对象** param key 缓存的键值* return 缓存键值对应的数据*/public T ListT getCacheList(final String key){return redisTemplate.opsForList().range(key, 0, -1);}/*** 缓存Set** param key 缓存键值* param dataSet 缓存的数据* return 缓存数据的对象*/public T BoundSetOperationsString, T setCacheSet(final String key, final SetT dataSet){BoundSetOperationsString, T setOperation redisTemplate.boundSetOps(key);IteratorT it dataSet.iterator();while (it.hasNext()){setOperation.add(it.next());}return setOperation;}/*** 获得缓存的set** param key* return*/public T SetT getCacheSet(final String key){return redisTemplate.opsForSet().members(key);}/*** 缓存Map** param key* param dataMap*/public T void setCacheMap(final String key, final MapString, T dataMap){if (dataMap ! null) {redisTemplate.opsForHash().putAll(key, dataMap);}}/*** 获得缓存的Map** param key* return*/public T MapString, T getCacheMap(final String key){return redisTemplate.opsForHash().entries(key);}/*** 往Hash中存入数据** param key Redis键* param hKey Hash键* param value 值*/public T void setCacheMapValue(final String key, final String hKey, final T value){redisTemplate.opsForHash().put(key, hKey, value);}/*** 获取Hash中的数据** param key Redis键* param hKey Hash键* return Hash中的对象*/public T T getCacheMapValue(final String key, final String hKey){HashOperationsString, String, T opsForHash redisTemplate.opsForHash();return opsForHash.get(key, hKey);}/*** 获取多个Hash中的数据** param key Redis键* param hKeys Hash键集合* return Hash对象集合*/public T ListT getMultiCacheMapValue(final String key, final CollectionObject hKeys){return redisTemplate.opsForHash().multiGet(key, hKeys);}/*** 获得缓存的基本对象列表** param pattern 字符串前缀* return 对象列表*/public CollectionString keys(final String pattern){return redisTemplate.keys(pattern);}
}springboot本地缓存
缓存
本地缓存 1启动类增加注解 EnableCaching // 开启缓存 2在service层代码中增加注解,进行测试 本地缓存使用的是currentHashMap import org.springframework.beans.factory.annotation.Autowired;import org.springframework.cache.annotation.CacheEvict;import org.springframework.cache.annotation.CachePut;import org.springframework.cache.annotation.Cacheable;import org.springframework.stereotype.Service;import com.ttzz.bean.Dog;import com.ttzz.mapper.DataDemo;Service/*** CacheConfig(cacheNames {},cacheManagerAAAA,cacheResolver {})*/public class DogService {Autowiredprivate DataDemo dataDemo;/*** Cacheable先在缓存中查找如果没有该缓存则创建查询数据放入缓存并返回数据* 参数1cacheNames/value* 2key* 3keyGenerator* 4cacheManager* 5)condition:* 6)unless: * 7)sync:*/Cacheable(value dog,/*cacheNames ,keyGenerator ,condition ,unless ,sync true*/key #id)public Dog getById(String id) {return dataDemo.getById(id);}/*** CachePut 先调用目标方法然后调用缓存信息*/CachePut(value dog,key#dog.id)public void save(Dog dog) {dataDemo.save(dog);}CachePut(value dog,key#dog.id)public void update(Dog dog) {dataDemo.update(dog);}/*** CacheEvict* allEntries:删除整个缓存中的数据* beforeInvocation执行方法前删除还是执行方法后删除*/CacheEvict(value dog /* allEntries true, beforeInvocation true*/,key#id)public void delete(String id) {dataDemo.delete(id);}/*** Caching复合注解* Caching(cacheable {Cacheable(value )},put {CachePut()})*/}SpringBoot以jar启动加载外部配置文件
SpringBoot以jar启动加载外部配置文件 通常需要将SpringBoot打成jar的方式来启动,有时候也需要将配置文件放到项目(jar)外。如何访问外部的配置文件呢 使用以下命令来操作
命令1
java -jar XXX.jar -Dspring.config.locationD:\workspace-test\work02\seed-java\seed-framework\target\_config\application.yml命令2
java -jar D:\workspace-test\work02\seed-java\seed-framework\target\XXX.jar -Dspring.config.locationD:\workspace-test\work02\seed-java\seed-framework\target\_config\application.yml -Dspring.profiles.activetestSpringBoot 读取应用配置文件
springboot读取配置文件有三种方式
使用environment类可以通过key-value的方式读取到application.properties中的数据使用value注解使用spel表达式注入属性值使用configurationProperties注解
environment environment是一个通用的读取应用运行时的环境变量的类可以读取application。properties命令函输入参数、系统属性、操作系统环境变量等 Autowired
private Environment env;使用方法env.getProperty(XXXX) value 直接通过value注入一个配置信息到bean configurationProperties 该注解可以将同样类型的配置映射成为一个类方便使用。一般和Configuration注解配合使用。它和value功能差不多它不能读取yml文件中的属性信息value可以value支持spel表达式。 SpringBoot之Jackson注解
Jackson有多个注解用来在序列化和反序列化操作
JsonProperty(XXXX) //为key指定一个别名
private String aa;JsonIgnore(XXXX) //忽略此属性
private String aa;JsonIgnoreProperties({XXXX,BBBB}) //忽略多个属性作用在类上
private class aa{}JsonFormat(pattern yyyy-mm-dd) //忽略此属性
private Date aa;Jackson支持三种序列化和反序列化的方式
使用JsonParser来解析json解析结果是一串tokens采用jsonGenerator来生成json这是最底层的方式采用树遍历的方式 json被读入到jsonnode对象中可以像操作xmldom那样读取json采用dataBind方式将实体类对象序列化成json或者反序列化成实体对象这是最简单的一种。对于应用程序来说最常用的是第三种。
SpringBoot Mock代码测试 增删改查代码 import java.net.URI;
import javax.annotation.Resource;import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.annotation.Rollback;
import org.springframework.test.context.junit4.SpringRunner;
import org.springframework.test.context.web.WebAppConfiguration;
import org.springframework.test.web.servlet.MockMvc;
import org.springframework.test.web.servlet.request.MockMvcRequestBuilders;
import org.springframework.test.web.servlet.result.MockMvcResultHandlers;
import org.springframework.test.web.servlet.result.MockMvcResultMatchers;
import org.springframework.test.web.servlet.setup.MockMvcBuilders;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.context.WebApplicationContext;RunWith(SpringRunner.class)
SpringBootTest(classes XXXX.class)
WebAppConfiguration
//配置事务的回滚,对数据库的增删改都会回滚,便于测试用例的循环利用
Transactional(transactionManager transactionManager)
Rollback(value true)
public class BySpecimenControllerTest {Autowiredprivate WebApplicationContext webApplicationContext;private MockMvc mockMvc;public String token;Resourceprivate SysLoginService loginService;Beforepublic void setupMockMvc() {mockMvc MockMvcBuilders.webAppContextSetup(webApplicationContext).build();
// token }Testpublic void testDeleteBySpecimen () throws Exception{String id 1;mockMvc.perform(MockMvcRequestBuilders.delete(/bySpecimens/delete/id)
// .header(Authorization, Bearer token)).andExpect(MockMvcResultMatchers.status().isOk()).andDo(MockMvcResultHandlers.print());}Testpublic void testFindBySpecimenById() throws Exception {String id 1;mockMvc.perform(MockMvcRequestBuilders.get(new URI(/bySpecimens/info)).param(opertationId, id)).andExpect(MockMvcResultMatchers.status().isOk()).andDo(MockMvcResultHandlers.print());}Testpublic void testFindBySpecimens () throws Exception{mockMvc.perform(MockMvcRequestBuilders.get(/bySpecimens/list)
// .header(Authorization, Bearer token)).andExpect(MockMvcResultMatchers.status().isOk()).andDo(MockMvcResultHandlers.print());}Testpublic void testSaveBySpecimen() throws Exception {mockMvc.perform(MockMvcRequestBuilders.post(/bySpecimens/save)
// .header(Authorization, Bearer token)// 标本标识.param(specimenId, value) .param(status, 0) ).andExpect(MockMvcResultMatchers.status().isOk()).andDo(MockMvcResultHandlers.print());}Testpublic void testUpdateBySpecimen () throws Exception {mockMvc.perform(MockMvcRequestBuilders.put(/bySpecimens/save)
// .header(Authorization, Bearer token)// 标本标识.param(specimenId, 1) .param(status, 1) ).andExpect(MockMvcResultMatchers.status().isOk()).andDo(MockMvcResultHandlers.print());}}
使用实体作为参数,需要在Controller 的参数 使用RequestBody 标记A domain new A();//设置参数//domain.setString jsonStr JSONObject.toJSONString(domain);mockMvc.perform(MockMvcRequestBuilders.put(/As/save).header(Authorization, Bearer token).accept(MediaType.APPLICATION_JSON_UTF8).contentType(MediaType.APPLICATION_JSON_UTF8).content(jsonStr)).andExpect(MockMvcResultMatchers.status().isOk()).andDo(MockMvcResultHandlers.print());SpringBootMybatis 实现多数据源配置(基于分包管理)、Swagger配置 1.本文主要是基于分包管理来实现多数据源的方式简单易用 2.Swagger配置 pom.xml配置
project xmlnshttp://maven.apache.org/POM/4.0.0 xmlns:xsihttp://www.w3.org/2001/XMLSchema-instance xsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsdmodelVersion4.0.0/modelVersiongroupIdXXX/groupIdartifactIdXXX/artifactIdversion0.0.1-SNAPSHOT/versionnamesXXX/namedescriptionXXX/descriptionparentgroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-parent/artifactIdversion2.1.13.RELEASE/versionrelativePath/ !-- lookup parent from repository --/parentpropertiesjava.version1.8/java.versionmybatis-plus.version3.1.2/mybatis-plus.versionpagehelper.spring.boot.starter.version1.2.5/pagehelper.spring.boot.starter.versiondruid.version1.1.17/druid.versionjwt.version0.9.1/jwt.versionfastjson.version1.2.60/fastjson.versionswagger.version2.9.2/swagger.versioncommons.version2.6/commons.versionbitwalker.version1.19/bitwalker.versionguava.version26.0-jre/guava.versioncommons.io.version2.5/commons.io.versionoshi.version3.9.1/oshi.versionseed.common.version0.0.1-SNAPSHOT/seed.common.versionoracle.version12.1.0.2/oracle.version/propertiesdependencies!-- https://mvnrepository.com/artifact/org.apache.clerezza.ext/org.json.simple --dependencygroupIdorg.apache.clerezza.ext/groupIdartifactIdorg.json.simple/artifactIdversion0.4/version/dependency!--常用工具类 --dependencygroupIdorg.apache.commons/groupIdartifactIdcommons-lang3/artifactId/dependency!--io常用工具类 --dependencygroupIdcommons-io/groupIdartifactIdcommons-io/artifactId/dependency!-- poi --dependencygroupIdorg.apache.poi/groupIdartifactIdpoi/artifactIdversion3.15/version/dependencydependencygroupIdorg.apache.poi/groupIdartifactIdpoi-ooxml/artifactIdversion3.15/version/dependency!-- 解析客户端操作系统、浏览器等 --dependencygroupIdeu.bitwalker/groupIdartifactIdUserAgentUtils/artifactId/dependency!-- 获取系统信息 --dependencygroupIdcom.github.oshi/groupIdartifactIdoshi-core/artifactId/dependencydependencygroupIdnet.java.dev.jna/groupIdartifactIdjna/artifactId/dependencydependencygroupIdnet.java.dev.jna/groupIdartifactIdjna-platform/artifactId/dependency!--Spring框架基本的核心工具--dependencygroupIdorg.springframework/groupIdartifactIdspring-context-support/artifactId/dependency!-- pagehelper 分页插件 --dependencygroupIdcom.github.pagehelper/groupIdartifactIdpagehelper-spring-boot-starter/artifactIdexclusionsexclusiongroupIdorg.mybatis/groupIdartifactIdmybatis/artifactId/exclusionexclusiongroupIdorg.mybatis/groupIdartifactIdmybatis-spring/artifactId/exclusion/exclusions/dependency!-- oracle 驱动 --dependencygroupIdcom.oracle/groupIdartifactIdojdbc7/artifactIdversion12.1.0.2/version/dependency!-- mysql 驱动 --dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion5.1.46/version/dependencydependencygroupIdorg.springframework.security/groupIdartifactIdspring-security-core/artifactIdversion5.1.8.RELEASE/versionscopecompile/scope/dependency!-- 引入freeMarker的依赖包. --dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-freemarker/artifactId/dependencydependencygroupIdnet.hasor/groupIdartifactIdhasor-spring/artifactIdversion4.1.3/version/dependencydependencygroupIdnet.hasor/groupIdartifactIdhasor-dataway/artifactIdversion4.1.3-fix20200414/version!-- 4.1.3 包存在UI资源缺失问题 --/dependency!-- 集成SpringMvc框架并实现自动配置 --dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-aop/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-actuator/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-configuration-processor/artifactIdoptionaltrue/optional/dependency!-- Redis --dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-data-redis/artifactId/dependencydependencygroupIdorg.apache.commons/groupIdartifactIdcommons-pool2/artifactId/dependency!-- mybatis-plus --dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion${mybatis-plus.version}/version/dependency!-- druid --dependencygroupIdcom.alibaba/groupIdartifactIddruid-spring-boot-starter/artifactIdversion${druid.version}/version/dependency!-- json --dependencygroupIdcom.alibaba/groupIdartifactIdfastjson/artifactIdversion${fastjson.version}/version/dependency!-- oracle驱动 --!--dependencygroupIdcom.oracle/groupIdartifactIdojdbc7/artifactIdversion${oracle.version}/version/dependency--!--lombok--dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdoptionaltrue/optional/dependency!-- Swagger API文档 --dependencygroupIdio.springfox/groupIdartifactIdspringfox-swagger2/artifactIdversion${swagger.version}/versionexclusionsexclusiongroupIdio.swagger/groupIdartifactIdswagger-annotations/artifactId/exclusionexclusiongroupIdio.swagger/groupIdartifactIdswagger-models/artifactId/exclusion/exclusions/dependencydependencygroupIdio.springfox/groupIdartifactIdspringfox-swagger-ui/artifactIdversion${swagger.version}/version/dependencydependencygroupIdio.springfox/groupIdartifactIdspringfox-bean-validators/artifactIdversion${swagger.version}/version/dependency!-- 防止进入swagger页面报类型转换错误排除2.9.2中的引用手动增加1.5.22版本 --dependencygroupIdio.swagger/groupIdartifactIdswagger-annotations/artifactIdversion1.5.22/version/dependencydependencygroupIdio.swagger/groupIdartifactIdswagger-models/artifactIdversion1.5.22/version/dependency!-- 测试单元 --dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/scope/dependency/dependenciesdependencyManagementdependencies!-- pagehelper 分页插件 --dependencygroupIdcom.github.pagehelper/groupIdartifactIdpagehelper-spring-boot-starter/artifactIdversion${pagehelper.spring.boot.starter.version}/version/dependency!--io常用工具类 --dependencygroupIdcommons-io/groupIdartifactIdcommons-io/artifactIdversion${commons.io.version}/version/dependency!-- 解析客户端操作系统、浏览器等 --dependencygroupIdeu.bitwalker/groupIdartifactIdUserAgentUtils/artifactIdversion${bitwalker.version}/version/dependency!-- 获取系统信息 --dependencygroupIdcom.github.oshi/groupIdartifactIdoshi-core/artifactIdversion${oshi.version}/version/dependency/dependencies/dependencyManagement/project多数据源配置代码
1.主数据源配置 Primary 标注的是主数据源 import javax.sql.DataSource;import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
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 org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.PlatformTransactionManager;Configuration
MapperScan(basePackages {包路径.mapper.数据库标识1mapper }, annotationClass Mapper.class, sqlSessionFactoryRef 数据库标识1SqlSessionFactory)
public class 数据库标识1MybatisConfig {/*** return 返回DataSource对象*/Bean(name 数据库标识1DataSource)Qualifier(数据库标识1DataSource)ConfigurationProperties(prefix spring.datasource.数据库标识1)Primarypublic DataSource cmsDataSource() {return DataSourceBuilder.create().build();}Bean(name 数据库标识1SqlSessionFactory)Primarypublic SqlSessionFactory sqlSessionFactory(Qualifier(数据库标识1DataSource) DataSource dataSource) throws Exception {SqlSessionFactoryBean sqlSessionFactoryBean new SqlSessionFactoryBean();sqlSessionFactoryBean.setDataSource(dataSource);sqlSessionFactoryBean.setMapperLocati数据库标识1(new PathMatchingResourcePatternResolver().getResources(classpath:mapper/数据库标识1mapper/*.xml));return sqlSessionFactoryBean.getObject();}Bean(name 数据库标识1PlatformTransactionManager)public PlatformTransactionManager transactionManager(Qualifier(数据库标识1DataSource) DataSource dataSource) {return new DataSourceTransactionManager(dataSource);}Bean(数据库标识1SqlSessionTemplate)// 表示这个数据源是默认数据源Primarypublic SqlSessionTemplate test1sqlsessiontemplate(Qualifier(数据库标识1SqlSessionFactory) SqlSessionFactory sessionfactory) {return new SqlSessionTemplate(sessionfactory);}
}2.第二个数据源配置 如何扩展 第三、第四数据源呢1复制第二数据源配置类简单修改注解中的名称 2在resource的mapper文件夹下创建XXXmapper,用来存放XXXXMapper.xml文件 特别注意没有primary修饰了哦 import javax.sql.DataSource;import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
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 org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.PlatformTransactionManager;Configuration
MapperScan(basePackages {包路径.mapper.数据库标识2mapper }, annotationClass Mapper.class, sqlSessionFactoryRef 数据库标识2SqlSessionFactory)
public class 数据库标识2MybatisConfig {/*** return 返回DataSource对象*/Bean(name 数据库标识2DataSource)Qualifier(数据库标识2DataSource)ConfigurationProperties(prefix spring.datasource.数据库标识2)public DataSource cmsDataSource() {return DataSourceBuilder.create().build();}Bean(name 数据库标识2SqlSessionFactory)Primarypublic SqlSessionFactory sqlSessionFactory(Qualifier(数据库标识2DataSource) DataSource dataSource) throws Exception {SqlSessionFactoryBean sqlSessionFactoryBean new SqlSessionFactoryBean();sqlSessionFactoryBean.setDataSource(dataSource);sqlSessionFactoryBean.setMapperLocati数据库标识2(new PathMatchingResourcePatternResolver().getResources(classpath:mapper/数据库标识2mapper/*.xml));return sqlSessionFactoryBean.getObject();}Bean(name 数据库标识2PlatformTransactionManager)public PlatformTransactionManager transactionManager(Qualifier(数据库标识2DataSource) DataSource dataSource) {return new DataSourceTransactionManager(dataSource);}Bean(数据库标识2SqlSessionTemplate)// 表示这个数据源是默认数据源Primarypublic SqlSessionTemplate test1sqlsessiontemplate(Qualifier(数据库标识2SqlSessionFactory) SqlSessionFactory sessionfactory) {return new SqlSessionTemplate(sessionfactory);}
}
resource下application.yml 中的数据源信息配置信息
spring:profiles: active: devmvc: static-path-pattern: /**resource: static-locations: classpath:/META-INF/resources/,classpath:/resources/,classpath:/static/,classpath:/public/datasource:
#数据库标识1数据源配置数据库标识1: jdbc-url: jdbc:mysql://ip:3306/d1?useUnicodetruecharacterEncodingutf8useSSLfalseusername: XXXpassword: XXXmaxActive: 50initialSize: 10maxWait: 60000minIdle: 1timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000maxOpenPreparedStatements: 2type: com.alibaba.druid.pool.DruidDataSourcedriver-class-name: com.mysql.jdbc.Driverfilters: statvalidationQuery: select version()testWhileIdle: truetestOnBorrow: falsetestOnReturn: falsepoolPreparedStatements: true
#数据库标识2数据源配置数据库标识2:jdbc-url: jdbc:oracle:thin:ip:1521:XXXusername: XXXpassword: XXXmaxActive: 50initialSize: 5maxWait: 60000minIdle: 1timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000maxOpenPreparedStatements: 2type: com.alibaba.druid.pool.DruidDataSourcedriver-class-name: oracle.jdbc.OracleDriverfilters: statvalidationQuery: select * from dualtestWhileIdle: truetestOnBorrow: falsetestOnReturn: falsepoolPreparedStatements: trueSwagger类配置 SwaggerConfig.java
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import springfox.documentation.builders.ApiInfoBuilder;
import springfox.documentation.builders.PathSelectors;
import springfox.documentation.builders.RequestHandlerSelectors;
import springfox.documentation.service.ApiInfo;
import springfox.documentation.service.ApiKey;
import springfox.documentation.service.Contact;
import springfox.documentation.service.AuthorizationScope;
import springfox.documentation.service.SecurityReference;
import springfox.documentation.spi.DocumentationType;
import springfox.documentation.spi.service.contexts.SecurityContext;
import springfox.documentation.spring.web.plugins.Docket;
import springfox.documentation.swagger2.annotations.EnableSwagger2;import java.util.ArrayList;
import java.util.List;
Configuration
EnableSwagger2
public class SwaggerConfig {/*** 创建API*/Beanpublic Docket createRestApi() {return new Docket(DocumentationType.SWAGGER_2).enable(true).apiInfo(apiInfo()).select().apis(RequestHandlerSelectors.withMethodAnnotation(ApiOperation.class)).paths(PathSelectors.any()).build()/* 设置安全模式swagger可以设置访问token */.securitySchemes(securitySchemes()).securityContexts(securityContexts());}/*** 安全模式这里指定token通过Authorization头请求头传递*/private ListApiKey securitySchemes() {ListApiKey apiKeyList new ArrayListApiKey();apiKeyList.add(new ApiKey(Authorization, Authorization, header));return apiKeyList;}/*** 安全上下文*/private ListSecurityContext securityContexts() {ListSecurityContext securityContexts new ArrayList();securityContexts.add(SecurityContext.builder().securityReferences(defaultAuth()).forPaths(PathSelectors.regex(^(?!auth).*$)).build());return securityContexts;}/*** 默认的安全上引用*/private ListSecurityReference defaultAuth() {AuthorizationScope authorizationScope new AuthorizationScope(global, accessEverything);AuthorizationScope[] authorizationScopes new AuthorizationScope[1];authorizationScopes[0] authorizationScope;ListSecurityReference securityReferences new ArrayList();securityReferences.add(new SecurityReference(Authorization, authorizationScopes));return securityReferences;}/*** 添加摘要信息*/private ApiInfo apiInfo() {// 用ApiInfoBuilder进行定制return new ApiInfoBuilder()// 设置标题.title(XXXX_接口文档)// 描述.description(XXXX所有API接口)// 作者信息.contact(new Contact(XXXX, null, null))// 版本.version(版本号:1.0 ).build();}
}
SpringBoot引入外部jar并将项目打包成jar包引发项目运行失败的问题
SpringBoot引入外部jar并将项目打包成jar包
正常打包操作
在src/main/resource 目录下创建一个lib文件夹将需要打如到项目中的jar放在这里通过build path 将这些jar加入到工程中以方便调用在pom.xml中增加,其中xxx看实际情况而定 dependenciesdependencygroupIdXXX/groupIdartifactIdXXX/artifactIdversionXXX/versionscopesystem/scopesystemPath${project.basedir}/src/main/resources/lib/XXX.jar/systemPath/dependency/dependencies在pom.xml中增加build 逻辑
buildpluginsplugingroupIdorg.springframework.boot/groupIdartifactIdspring-boot-maven-plugin/artifactIdconfigurationincludeSystemScopetrue/includeSystemScope/configuration/plugin/pluginsresourcesresourcedirectorylib/directorytargetPathBOOT-INF/lib//targetPathincludesinclude**/*.jar/include/includes/resourceresourcedirectorysrc/main/resources/directorytargetPathBOOT-INF/classes//targetPath/resource/resources/build特别注意: 上面的build中的代码仅仅是在打包的时候打开在运行项目的时候需要将上面的代码注释掉。不然会报错找不到XXXMapper.xml mybatis对应的xml文件。
【转载】springboot引入外部依赖jar包
今天项目(springboot项目)中需要导入外部的jar包在打包的时候需要将外部jar打到项目中。就这一个问题CSDN中有好多的提示的文章。真TM傻逼啊发文章之前自己就不测试一下吗自己在网上随便找一个案例正好满足自己的要求就直接用了标题都TM不调整一下也不看看人家的标题和你自己写的是不是一个意思。误人子弟。
正解文件连接
springboot引入外部依赖jar包_springboot引入外部jar包_半山惊竹的博客-CSDN博客
RestTemplateUtil 工具类 两个系统之间做数据交互一般都是使用接口的方式在SpringBoot中提供了一个RestTemplate类方便调用。 以下是一个简单封装方便使用
import java.util.Arrays;
import java.util.HashMap;
import java.util.Map;import org.springframework.http.HttpEntity;
import org.springframework.http.HttpHeaders;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
import org.springframework.web.client.RestTemplate;import com.alibaba.fastjson.JSONObject;import lombok.extern.slf4j.Slf4j;Slf4j
public class RestTemplateUtil {/*** restTemplate 发送post请求* param restTemplate* param url* param json* return*/public static ResponseEntityString getRestTemplatePost(RestTemplate restTemplate,String url,String json){HttpHeaders headers new HttpHeaders();headers.setAccept(Arrays.asList(MediaType.APPLICATION_JSON));headers.setContentType(MediaType.APPLICATION_JSON_UTF8);HttpEntityString requestEntity new HttpEntityString(json,headers);ResponseEntityString entity restTemplate.postForEntity(url, requestEntity, String.class);return entity;}/*** restTemplate 发送get请求* param restTemplate* param url* param json* return*/public static ResponseEntityString getRestTemplateGet(RestTemplate restTemplate,String url,String json){HttpHeaders headers new HttpHeaders();headers.setAccept(Arrays.asList(MediaType.APPLICATION_JSON));headers.setContentType(MediaType.APPLICATION_JSON_UTF8);HttpEntityString requestEntity new HttpEntityString(json,headers);ResponseEntityString entity restTemplate.getForEntity(url, String.class,json);return entity;}public static MapString, String parseResponseEntity(ResponseEntityString entity) {MapString,String map new HashMapString,String();log.info(ResponseEntityJSONObject.toJSONString(entity));Integer code entity.getStatusCodeValue();if(entity.getStatusCodeValue()200) {JSONObject obj JSONObject.parseObject(entity.getBody());map.put(code, code);map.put(data, obj.getString(data).toString());}log.info(JSONObject.toJSONString(map));return map;}}关于Transactional 的sao操作 关于Transactional 作用的一些测试 SpringBoot JavaEE 简介springboot 配置、加载加载外部类的几种方式加载配置文件中的属性的方式profiles在启动jar包的时候 动态指定jar的端口号配置虚拟机参数在启动jar的时候指定外部的配置文件 配置文件的加载顺序 maven简介maven实现的目标pom中元素介绍groupIdartifactIdpackagingversion modelVersionscopebuild spring boot 发送邮件1.引入jar2.application.yml配置3.发送简单文本信息4.发送带有附件的 springboot和redis缓存redis缓存 springboot本地缓存缓存 SpringBoot以jar启动加载外部配置文件 SpringBoot以jar启动加载外部配置文件使用以下命令来操作命令1命令2 SpringBoot 读取应用配置文件springboot读取配置文件有三种方式environmentvalueconfigurationProperties SpringBoot之Jackson注解Jackson支持三种序列化和反序列化的方式 SpringBoot Mock代码测试SpringBootMybatis 实现多数据源配置(基于分包管理)、Swagger配置pom.xml配置多数据源配置代码1.主数据源配置2.第二个数据源配置resource下application.yml 中的数据源信息配置信息 Swagger类配置 SwaggerConfig.java SpringBoot引入外部jar并将项目打包成jar包引发项目运行失败的问题正常打包操作**特别注意:** 上面的build中的代码仅仅是在打包的时候打开在运行项目的时候需要将上面的代码注释掉。不然会报错找不到XXXMapper.xml mybatis对应的xml文件。 【转载】springboot引入外部依赖jar包RestTemplateUtil 工具类以下是一个简单封装方便使用 关于Transactional 的sao操作case1 无try catch、无嵌套没有加 rollbackFor Exception.class 事务正常回滚case2 无try catch、无嵌套加 rollbackFor Exception.class 事务正常回滚case3 没有加 rollbackFor Exception.class 事务没有回滚case4 有try catch、无嵌套加 rollbackFor Exception.class 事务没有回滚case5 有try catch、无嵌套加 rollbackFor Exception.class ,抛出异常 。 事务正常回滚case6 有try catch、无嵌套加 rollbackFor Exception.class ,抛出异常。方法调用事务没有回滚case7 事务没有回滚case8 事务回滚case9 事务回滚case10 事务未回滚case11 事务回滚case12 事务未回滚case13 事务回滚case14 事务回滚case15 事务回滚 dynamic-datasource 使用 在使用Transactional 关键字的时候总会有这样 或者 那有的问题。一下做一些测试来验证问题
case1 无try catch、无嵌套没有加 rollbackFor Exception.class 事务正常回滚
Transactionalpublic int testSave() {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;}case2 无try catch、无嵌套加 rollbackFor Exception.class 事务正常回滚
Transactional(rollbackFor Exception.class)public int testSave() {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;}case3 没有加 rollbackFor Exception.class 事务没有回滚
Transactionalpublic int testSave() {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;} catch (Exception e) {// TODO: handle exception}return 0;}case4 有try catch、无嵌套加 rollbackFor Exception.class 事务没有回滚
Transactional(rollbackFor Exception.class)public int testSave() {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;} catch (Exception e) {// TODO: handle exception}return 0;}case5 有try catch、无嵌套加 rollbackFor Exception.class ,抛出异常 。 事务正常回滚
Transactional(rollbackFor Exception.class)public int testSave() throws Exception {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;} catch (Exception e) {throw new Exception(e.getMessage());}}case6 有try catch、无嵌套加 rollbackFor Exception.class ,抛出异常。方法调用事务没有回滚
public int testSave() throws Exception {return testSave2();}Transactional(rollbackFor Exception.class)public int testSave2() throws Exception {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;} catch (Exception e) {System.out.println(e.getMessage());throw new Exception(e.getMessage());}}case7 事务没有回滚
Transactionalpublic int testSave() throws Exception {return testSave2();}Transactional(rollbackFor Exception.class)public int testSave2() throws Exception {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;} catch (Exception e) {System.out.println(e.getMessage());throw new Exception(e.getMessage());}}case8 事务回滚
Transactional(rollbackFor Exception.class)public int testSave() throws Exception {return testSave2();}public int testSave2() throws Exception {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;} catch (Exception e) {System.out.println(e.getMessage());throw new Exception(e.getMessage());}}case9 事务回滚
Transactional(rollbackFor Exception.class)public int testSave() throws Exception {return testSave2();}Transactional(rollbackFor Exception.class)public int testSave2() throws Exception {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;} catch (Exception e) {System.out.println(e.getMessage());throw new Exception(e.getMessage());}}case10 事务未回滚
Transactionalpublic int testSave() throws Exception {return testSave2();}Transactional(rollbackFor Exception.class)public int testSave2() throws Exception {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;} catch (Exception e) {System.out.println(e.getMessage());throw new Exception(e.getMessage());}}case11 事务回滚
Transactional(rollbackFor Exception.class)public int testSave() throws Exception {return testSave2();}Transactionalpublic int testSave2() throws Exception {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;} catch (Exception e) {System.out.println(e.getMessage());throw new Exception(e.getMessage());}}case12 事务未回滚
Transactional(rollbackFor Exception.class)public int testSave() throws Exception {return testSave2();}Transactionalpublic int testSave2() {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);int m 1/0;return 1;} catch (Exception e) {System.out.println(e.getMessage());}return 0;}case13 事务回滚
Transactional(rollbackFor Exception.class)public int testSave() throws Exception {int m testSave2();int n 1/0;return m;}Transactionalpublic int testSave2() {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);return 1;} catch (Exception e) {System.out.println(e.getMessage());}return 0;}case14 事务回滚
Transactional(rollbackFor Exception.class)public int testSave() throws Exception {int m testSave2();int n 1/0;return m;}public int testSave2() {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);return 1;} catch (Exception e) {System.out.println(e.getMessage());}return 0;}case15 事务回滚
Transactional(rollbackFor Exception.class)public int testSave() throws Exception {int m testSave2();int n 1/0;return m;}Transactional(rollbackFor Exception.class)public int testSave2() {try {User user new User();user.setName(岳不群2);user.setAge(70);user.setEmail(lucyqq.com);userMapper.insert(user);return 1;} catch (Exception e) {System.out.println(e.getMessage());}return 0;}dynamic-datasource 使用
1在项目中引入dynamic-datasource该modul 2在application.yml中添加
dynamic:datasource:slave1: driver-class-name: oracle.jdbc.OracleDriverurl: jdbc:oracle:thin:XXX:orcl_tjhusername: XXpassword: XXvalidation-query: SELECT 1 FROM DUALslave2: driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/XXX?useUnicodetruecharacterEncodingUTF-8serverTimezoneAsia/Shanghaiusername: XXXXpassword: XXXX在项目中使用dynamic 配置的都是子数据源。 在访问的service 方法上 使用DataSource(数据源表示)如上的slave1
【临渊羡鱼不如退而结网】
