SPL:connect(drv,url) 连接不同数据库的写法
ORACLE
=connect(“oracle.jdbc.driver.OracleD
river”,“jdbc:oracle:thin:user/password@127.0.0.1:1521:orcl”)
MSSQL
=connect(“com.microsoft.sqlserver.jdbc.SQLServerDriver”,“jdbc:sqlserver://172.17.0.12:9043;DatabaseName=SAADB;user=zhangsan;password=zhangsan”)
MySQL
=connect(“com.mysql.jdbc.Driver”,“jdbc:mysql://127.0.0.1:3306/mysqlwp?user=root&password=root”)
MySQL8:
=connect(“com.mysql.jdbc.Driver”,“jdbc:mysql://127.0.0.1:3306/mybi?useCursorFetch=true&useSSL=false&user=root&password=root”)
集算器 SPL
=connect(“com.esproc.jdbc.InternalDriver”,“jdbc:esproc:local://”)
DB2(待测试)
String url = “jdbc:db2://mvs1.sj.ibm.com:5021/san_jose:user=dbadm;password=dbadm;”;
greenPlum
connect(“org.postgresql.Driver”,“jdbc:postgresql://43.136.21.186:5432/xpros-test?user=gpadmin&password=gpadmin”)