- 博客(13)
- 收藏
- 关注
RSS订阅
1原创 【oracel死锁】ORA-00060: deadlock detected while waiting for resource
ORA-00060: deadlock detected while waiting for resource
2023-02-25 00:40:21
2173
原创 pg自定义排序
pg自定义排序order by position(sfzh::text in '1,2,13')order by position(字段::字段类型 in '根据啥排序')
2021-05-25 16:33:18
1011
原创 ONLY_FULL_GROUP_BY
关于select字段仅支持group by1.select identity from employee group by identity 2.select id,identity from employee group by identity 3.select * from employee group by identity 当2.3都失败报错,将ONLY_FULL_GROUP_BY去掉select @@global.sql_modeSET sql_mode=(SE
2021-05-12 23:47:58
51
原创 根据某字段数据去重
delete from employee where id in( select id from ( select *from employee where identity in (select identity from employee group by identity having count(identity) > 1) and id not in (select min(id) from employee group by identity having.
2021-05-12 22:57:45
181
原创 sql查询时间
关于日期查询格式化 例如 查出特定某天的数据:select starttime,* from table where 1=1 and starttime >=to_timestamp('2021-04-14', 'YYYY-MM-DD') 带上时间的日期查询是:select starttime,* from table where 1=1 and starttime >to_timestamp('2021-04-13 00:00:00', 'YYYY-MM-DD HH24:MI:SS.
2021-04-16 14:56:50
591
原创 创建zip压缩文件
创建zip压缩文件public class AAA { public static void main(String[] args) throws Exception { File zipFile = new File("D://123.zip"); FileOutputStream fileOutputStream = new FileOutputStream(zipFile); CheckedOutputStream checkedOutputStream = new CheckedOu
2021-03-31 09:49:54
433
原创 zip中添加文件夹
ZipEntry zipEntry = new ZipEntry(folder.substring(folder.lastIndexOf("\\")+1)+"\\"+filename + hz.substring(hz.lastIndexOf(".")));//zip中添加文件夹,直接new ZipEntry("年度重大项目申请书\test.doc")public boolean FoldersToZip(ArrayList<java.io.File> sourceFiles, Stri.
2021-03-18 17:09:51
2419
原创 杀端口进程
杀端口进程C:\Users\Administrator>netstat -ano | findstr 8300 TCP 0.0.0.0:8300 0.0.0.0:0 LISTENING 17376 TCP [::]:8300 [::]:0 LISTENING 17376C:\Users\Administrator>taskkill -pid 1
2020-11-29 19:52:39
128
原创 整合alipay-sdk-java-4.8.73.ALL.jar到maven
mvn install:install-file -DgroupId=com.alipay.sdk -DartifactId=alipay-sdk-java -Dversion=4.8.73.ALL -Dpackaging=jar -Dfile=alipay-sdk-java-4.8.73.ALL.jar
2020-11-29 11:13:34
875
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人