Question

这是oracle 数据库外连接，想换成postgersql 数据库，该怎么写？

CREATE TABLE TMP_DZ_PBX_CASH_REG AS SELECT T1.SYS_NO, T1.PCODE, T1.CLEAR_DATE AS TRAN_DATE, T1.SEQNO, T1.CUR_TYPE, T1.CRDB, T1.TXAMT, T1.OPR_INST_NO, T1.OPR_TLR_NO,(CASE WHEN T1.OPR_INST_NO LIKE '%Z' THEN '17' ELSE '01' END) AS CHANNEL_TYPE,T1.STAT AS TRAN_TYPE,'00' AS STAT,'1' AS INTER_TYPE,'01' AS BALANCE_MODE FROM TMP_LSRH_PBX_CASH_REG T1, TMP_ZJQS_DZ_TMP T2, PBX_DETAILFUSION T3 WHERE (T1.SEQNO = T2.SEQNO AND T1.STAT = T2.STAT) AND (T1.PCODE(+) = T3.TRANCODE AND T1.SYS_NO(+) = (case when T3.MAPSYS='00100020000' then '99700010000' else T3.MAPSYS end));

Answer 1

Connection conn=DBUtil.getConnection();
这句是调用的DBUtil中的方法，如果你没有更改其中连接方法的话，应该会调用配置文件的配置信息
一般 配置文件的名字为jdbc.properties
修改其中内容
driver=com.microsoft.sqlserver.jdbc.SQLServerDrive
url=jdbc:sqlserver://localhost:1433;DatabaseName=TeacherSystem
username=sa
password=123