Java实体生成 需要sql语句

SELECT  
    CONCAT("/**\r","* ",REPLACE(a.COLUMN_COMMENT,"\n",""),"\r*/\r",'private ', (CASE   
    WHEN a.DATA_TYPE ='bigint' THEN 'Long '  
    WHEN a.DATA_TYPE ='decimal' THEN 'BigDecimal '  
    WHEN a.DATA_TYPE ='int' THEN 'Integer '  
    WHEN a.DATA_TYPE ='tinyint' THEN 'Integer '  
    WHEN a.DATA_TYPE ='varchar' THEN 'String '  
    WHEN a.DATA_TYPE= 'timeStamp' THEN 'Date '  
    WHEN a.DATA_TYPE= 'datetime' THEN 'Date '  
                WHEN a.DATA_TYPE= 'float' THEN 'Float '  
                WHEN a.DATA_TYPE= 'double' THEN 'Double '  
    else '请补充类型 '  
    END  
),COLUMN_NAME ,";") COLUMN_NAME  
FROM  
    information_schema.COLUMNS  a  
WHERE  
    table_name = '表名（改这里即可）'  
)dd

打成了jar包用  java -jar -Dfile.encoding=utf-8运行不管用 还是乱码

控制台先执行

chcp 65001

再运行jar包

theme: jzman

打印日志

log.info("relust结果:{}", JSON.toJSONString(result));

stream流

//归类
Map<String, List<ReleaseProjectDO>> collect = releaseProjectDOSList.stream().collect(Collectors.groupingBy(ReleaseProjectDO::getCpCode));
//从大到小排序

List sortVersion = releaseProjectDOList.stream().sorted(Comparator.comparingInt(ReleaseProjectDO::getVersion).reversed()).collect(Collectors.toList());

内存分页

List<ReleaseProjectDO> data = res.getData();

long page = Long.parseLong("1");

long size = Long.parseLong(String.valueOf(data.size()));

List<ReleaseProjectDO> subList = data.stream().skip((page-1)*size).limit(size).collect(Collectors.toList());

return ResponseResultUtil.success(size,subList);
//内存分页

List<ReleaseProjectDO> value = new ArrayList<ReleaseProjectDO>(map.values());

List<ReleaseProjectDO> subList = value.stream().skip((dto.getPage() - 1) * dto.getSize()).limit(dto.getSize()).collect(Collectors.toList());

return ResponseResultUtil.success(subList.size(),subList);

前端文本换行空格处理

String content = req.getContent().replaceAll("\\n", "<br/>").replace("\\t", "  ");

map转对象

Map map = JSON.parseObject(JSON.toJSONString(data), Map.class);

Object rows = map.get("rows");

List<BdopScForm> bdopScFormList = JSON.parseArray(JSON.toJSONString(data), BdopScForm.class);

日期

System.out.println(LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));

利用反射给ArrayList添加String

public static void main(String[] args) throws Exception {
    ArrayList<Integer> list = new ArrayList<Integer>(); 
    list.add(1); 
    //这样调用 add 方法只能存储整形，因为泛型类型的实例为 Integer 
    //在程序中定义了一个ArrayList泛型类型实例化为Integer对象，如果直接调用add()方法，那么只能存储整数数据，不过当我们利用反射调用add()方法的时候，却可以存储字符串，这说明了Integer泛型实例在编译之后被擦除掉了，只保留了原始类型 
    list.getClass().getMethod("add", Object.class).invoke(list, "asd"); 
    for (int i = 0; i < list.size(); i++) { 
        System.out.println(list.get(i)); 
     } 
}

作者：ytKing
链接：https://juejin.cn/post/7131953899111448612
来源：稀土掘金

根据年月日返回date（生日）

Calendar calendar = Calendar.getInstance();

calendar.set(year, month, day);

return calendar.getTime();

}

不把本地服务注册到注册中心

-Dspring.cloud.nacos.discovery.register-enabled=false   
-Deureka.client.register-with-eureka=false      
各位本地使用 test 启动应用请加上这个参数(不把自己注册到注册中心),第一个是使用nacos做为注册中心,第二个是eureka的,已经有很多同学找,问为什么有些接口偶尔失败的,大部分都是这个原因,把自己本地的服务注册上去,导致网关请求不到

工作中遇到的问题，必看！_spring

多数据源的方式

方法1：aop

spring.datasource.price.username = root
spring.datasource.price.password = 123
spring.datasource.price.driver-class-name = com.mysql.jdbc.Driver
spring.datasource.ware.url = jdbc:mysql://192.233.0.101:3303,192.233.0.102:4000/ware?useUnicode=true&characterEncoding=utf-8&useSSL=false&allowMultiQueries=true
spring.datasource.ware.username = root
spring.datasource.ware.password = 123
spring.datasource.ware.driver-class-name = com.mysql.jdbc.Driver
import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;  
import org.springframework.boot.context.properties.ConfigurationProperties;  
import org.springframework.context.annotation.Bean;  
import org.springframework.context.annotation.Configuration;  
import org.springframework.context.annotation.Primary;  
import org.springframework.stereotype.Component;  
import javax.sql.DataSource;  
import java.util.HashMap;  
import java.util.Map;  
  
@Configuration  
@Component  
public class DynamicDataSourceConfig {  
  
@Bean(name = "priceDataSource")  
@ConfigurationProperties("spring.datasource.price")  
public DataSource priceDataSource(){  
return DruidDataSourceBuilder.create().build();  
}  
  
@Bean(name = "wareDataSource")  
@ConfigurationProperties("spring.datasource.ware")  
public DataSource wareDataSource(){  
return DruidDataSourceBuilder.create().build();  
}  
  
@Bean  
@Primary  
public DynamicDataSource dataSource(DataSource priceDataSource, DataSource wareDataSource) {  
Map<Object, Object> targetDataSources = new HashMap<>();  
targetDataSources.put("priceDataSource",priceDataSource);  
targetDataSources.put("wareDataSource", wareDataSource);  
return new DynamicDataSource(priceDataSource, targetDataSources);  
}  
  
}
import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;  
import javax.sql.DataSource;  
import java.util.Map;  
  
public class DynamicDataSource extends AbstractRoutingDataSource {  
  
private static final ThreadLocal<String> contextHolder = new ThreadLocal<>();  
  
public DynamicDataSource(DataSource defaultTargetDataSource, Map<Object, Object> targetDataSources) {  
super.setDefaultTargetDataSource(defaultTargetDataSource);  
super.setTargetDataSources(targetDataSources);  
super.afterPropertiesSet();  
}  
  
@Override  
protected Object determineCurrentLookupKey() {  
return getDataSource();  
}  
  
public static void setDataSource(String dataSource) {  
contextHolder.set(dataSource);  
}  
  
public static String getDataSource() {  
return contextHolder.get();  
}  
  
public static void clearDataSource() {  
contextHolder.remove();  
}  
  
}
import cn.hutool.core.util.ObjectUtil;  
import com.hydee.h3.devopstask.annotation.DataSource;  
import com.hydee.h3.devopstask.config.DynamicDataSource;  
import org.aspectj.lang.ProceedingJoinPoint;  
import org.aspectj.lang.annotation.Around;  
import org.aspectj.lang.annotation.Aspect;  
import org.aspectj.lang.annotation.Pointcut;  
import org.aspectj.lang.reflect.MethodSignature;  
import org.springframework.stereotype.Component;  
import java.lang.reflect.Method;  
  

@Aspect  
@Component  
public class DataSourceAspect {  
@Pointcut("@annotation(com.hydee.h3.devopstask.annotation.DataSource)")  
public void dataSourcePointCut() {  
  
}  
  
@Around("dataSourcePointCut()")  
public Object around(ProceedingJoinPoint point) throws Throwable {  
MethodSignature signature = (MethodSignature) point.getSignature();  
Method method = signature.getMethod();  
  
DataSource dataSource = method.getAnnotation(DataSource.class);  
if(ObjectUtil.isNull(dataSource)){  
DynamicDataSource.setDataSource("priceDataSource");  
}else {  
DynamicDataSource.setDataSource(dataSource.name());  
}  
  
try {  
return point.proceed();  
} finally {  
DynamicDataSource.clearDataSource();  
}  
}  
}
import java.lang.annotation.*;  
  
/**  
* @description:  
* @author: linqi 00118792  
* @date: 2022/5/11 20:46  
*/  
@Target(ElementType.METHOD)  
@Retention(RetentionPolicy.RUNTIME)  
@Documented  
public @interface DataSource {  
String name() default "";  
}

方法2：@DS()方式 方法简单 但是需要引入依赖

code-block-extension-codeShowNum" lang=""><groupId>com.baomidou</groupId>  
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>  
<version>3.5.1</version>  
</dependency>  
  
<dependency>  
<groupId>mysql</groupId>  
<artifactId>mysql-connector-java</artifactId>  
<version>8.0.26</version>  
</dependency>

在实现类impl上添加@DS("ware") 不添加走默认配置

spring.datasource.dynamic.primary = price
spring.datasource.dynamic.strict = false
spring.datasource.dynamic.datasource.price.username = 
spring.datasource.dynamic.datasource.price.password = 
spring.datasource.dynamic.datasource.price.driver-class-name = 
spring.datasource.dynamic.datasource.price.url = 

spring.datasource.dynamic.datasource.ware.password = 
spring.datasource.dynamic.datasource.ware.url = 
spring.datasource.dynamic.datasource.ware.username = 
spring.datasource.dynamic.datasource.ware.driver-class-name =


作者：AOSIDING
链接：https://juejin.cn/post/7134505647797698574
来源：稀土掘金
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。