随笔分类 - 笔记
两个list 对比去重
摘要:ResultBaseDTO<List<OccupyQueryResultDTO>> listResultBaseDTO = InvoicePoolUtil.invoiceOccupyQuery(queryDTO);final List<String> importedInvoiceCodes = t
阅读全文
http发送请求的几种方式笔记
摘要:CloseableHttpResponse方式 get请求 public String logoutByToken (String token)throws IOException { String code =null; if(token == null){ return "500"; }else
阅读全文
SQL语句实现两张表之间同步数据,不存在则插入
摘要:INSERT into contract_service.voucher_contract_mapping_info (uuid,contract_id, contract_name,external_contract_id,external_contract_name)select uuid,co
阅读全文
SQL Server查看锁表与解锁表
摘要:--查看被锁表 SELECT request_session_id spid, --锁表进程ID OBJECT_NAME( resource_associated_entity_id ) tableName --锁表表名 FROM sys.dm_tran_locks WHERE resource_t
阅读全文
SQL的判断重复新增或者修改
摘要:<insert id="insertTankStatisticData" parameterType="java.util.Map"> <selectKey keyProperty="count" resultType="int" order="BEFORE"> select count(*) AS
阅读全文
读取Properties
摘要:package com.infotech.common.util; import java.io.FileNotFoundException; import java.io.IOException; import java.util.Properties; /** * @ClassName Confkit.java * @Description TODO * * @author D.C * @ve
阅读全文
sqlserver 导出数据库表结构
摘要:https://www.cnblogs.com/miaomiaoquanfa/p/6909835.html
阅读全文