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”)