Jzq0006的博客

select （自增索引名）GJGX_seq.nextval into:new.id from dual;GJGX_QUERYLOG（表名） for each row。

java多线程异步操作批量数据

今天用tomcat启动springboot项目的时候出现SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/D:/maven-3.3.3/m2/repository/ch/qos/logback/logback-classic/1.2.3/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]日志..

首先你要下载一个freeSSHd 这个是用来创建sftp服务的软件使用：创建用户：SSH ，地址选本地地址连接访问密码设置权限sftp文件默认路径 一定注意在c盘会因为没有权限而操作失败好了这样基本上就软件配置成功了接下来就是代码了/** * ClassName: SFTPUtil.java * @date 2019年8月31日 */ package com.whxg.modules.utils;import java.io.ByteA

yml：spring: datasource:# 正式数据库 first: url: jdbc:oracle:thin:@127.0.0.1:1521:ORCL username: root password: root# 测试数据库 second: url: jdbc:oracle:thin:@127.0.0.1:1521:ORCL username: root password: roo.

首先你要有svn服务器和svn客户端 安装好 接下来就跟着步骤走就可以了ok 只需八步就可以实现了

Oracle中的分页查询以scott账户中的emp表和dept表为例最内层：主要负责排序String sql = "select e.* from emp e inner join dept d on e.deptNo = d.deptNo where order by orderStd orderType";1orderStd :排序字段名orderType：排序类型（desc asc）中间层：主要负责使用rownum关键字来进行分页 以及起别名、做小于项的设置sql = "selec

数据格式为：{"ww_djsq_tmp":{"sqbh":"ZYYH-20210221-0002","sqrq":"2021-02-2111:50:50","djdl":"910","djxl":"抵押首次（房屋）","ajzt":"0","sqr":"张三","blwd":"中原银行","bdcdyh":"410402003002GB00012F00160005","fwzl":"建设路西肯特街北11层车库1101C","lcmc":"抵押首次（...

最近调用外部厂商提供的Post接口，总结了几种方法：一、项目的maven依赖： <dependency> <groupId>org.apache.httpcomponents</groupId> <artifactId>httpcore</artifactId> <version>4.4.5</version> &lt...

/** * 去除html所有标签返回文字 */ public static String htmlTagFilter(String inputStr, int len) { if (inputStr == null || "".equals(inputStr.trim())) { return ""; } String outStr = inputStr.replaceAll("\\&[a-zA-..

po对象@ApiModel("文档说明分类集合查询结果响应")@Datapublic class DocumentCategoryQueryResultDTO extends BaseQueryResultVO { /** * 编号 */ @ApiModelProperty("编号") private Long id; /** * 父级分类编号 */ @ApiModelProperty("父级分类编号") p.

代码：​ public DocumentCategoryPO getParentCategoryObject(DocumentCategoryPO category) { //category.getParentId() == 0 0为根目录可随意变化 if (category.getParentId() == 0) { return category; } QueryConditions quer.

首先我们需要引人两个依赖<dependency><groupId>com.google.zxing</groupId><artifactId>core</artifactId><version>3.3.3</version></dependency><dependency><groupId>com.google.zxing</groupId>&l

boolean bool=userScoreList.stream().anyMatch(a -> a.getIsFlag().equals(IsFlagEnum.YES.getCode()));

首先把需要对比的字段单独抽离出来：List<Long> courseQuestionsIds = courseChapterPeriodQuestionsList.stream().map(CourseChapterPeriodQuestions::getCourseQuestionsId).collect(Collectors.toList());这是要对比的list数据：Page<AuthCourseTestQuestionsListDTO> authCourseT..

List<Long> courseQuestionsIds = courseChapterPeriodQuestionsList.stream().map(CourseChapterPeriodQuestions::getCourseQuestionsId).collect(Collectors.toList());这样就把id给单独抽出来组成了新的list

String redisLockKey ="";//自定义Boolean lockRet = redisTemplate.opsForValue().setIfAbsent(redisLockKey, redisLockKey);// 对应setnx命令if (lockRet) { redisTemplate.expire(redisLockKey, 1, TimeUnit.SECONDS);//设置时间为1秒 超过一秒就销毁//里面写要加锁的内容方法}else{re...

/** * Copyright 2015-现在 广州市领课网络科技有限公司 */package com.roncoo.education.common.core.tools;import java.lang.management.ManagementFactory;import java.net.InetAddress;import java.net.NetworkInterface;import java.sql.Timestamp;import java.util.UUID;imp.

@Getter@AllArgsConstructorpublic enum ActTypeEnum { COUPON(1, "优惠券"), DISCOUNT(2, "立减"), SECKILL(3, "秒杀"); private Integer code; private String desc; public static ActTypeEnum getActType(int value) { for (ActTypeEnum actTypeEnum : .

工具类：public final class BeanUtil<T extends Serializable> { private BeanUtil() { } /** * @param source * @param clazz * @return * @throws IllegalAccessException * @throws InvocationTargetException * @throws Instantia.

根据年查询select * FROM school_file_info WHERE file_type=2 AND video_type=1 AND user_no=64288 AND DATE_FORMAT( gmt_create, '%Y' )= DATE_FORMAT('2020-01-01', '%Y') order by根据月查询 select * FROM school_file_info WHERE file_type=2 AND video_type=1 AND us...

删除需求：* 1、假设有多级分类* 2、当删除一级分类的时候，同时删除一级分类下面的所有分类controller：@DeleteMapping("{oneId}") public R deleteOneId(@PathVariable("oneId") String oneId){ boolean flag = eduSubjectService.deleByOneId(oneId); if (flag){ return R....

封装类：@Data@Accessors(chain = true)@ApiModel(value="SchoolFilePathDTO", description="")public class SchoolFilePathDTO implements Serializable { private static final long serialVersionUID = 1L; @JsonSerialize(using = ToStringSerializer....

//把list转化为分页 public List getListByPage(List list,int page,int pageSize) { if(list.size() > 0 ){ int firstIndex = (page - 1) * pageSize; int lastIndex = page * pageSize; int actualLastIndex = 0; .

schoolFileInfoDTOS为要进行排序的list数据 if (schoolFileInfoDTOS.size() > 1) { //list 集合正续 schoolFileInfoDTOS.sort((a1, a2) -> { try { return a2.getGmtCreate().compareTo(a1.getGmtCreate()); } catch (Exception e) ...