数据库
rongyili88
Java老鸟一枚
展开
-
postgres crosstab 固定多列
原始数据如下SQL 如下select split_part(tnm_time, '~', 1) as tnm , split_part(tnm_time, '~', 2)::timestamp as tims ,"616" ,"622" ,"631" ,"648" ,"652" ,"699" from crosstab('select tp_id||''~''||dt,type1,value from tmp_test ','select distinc原创 2021-02-03 19:55:42 · 389 阅读 · 0 评论 -
JAVA DBCP 连接池
先上工程结构图链接池具体代码import java.io.InputStream;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;imp原创 2016-01-28 09:37:53 · 283 阅读 · 0 评论