常用数据库连接写法全攻略牛

甯哥敤鏁版嵁搴揓DBC杩炴帴鍐欐硶

1. MySQL()r

rName( \"iver\" );

cn = tConnection( \"jdbc: sUsr, sPwd );

2. PostgreSQL()r

rName( \"iver\" );

不管怎样 cn = tConnection( \"jdbc: sUsr, sPwd );

3. Oracle(

rName( \"acleDriver\" );

cn = tConnection( \"jdbcracle:thin:@MyDbComputerNameOrIP:1521:ORCL\", sUsr, sPwd );

4. Sybase()r

rName( \"bDriver\" );

cn = tConnection( \"jdbc:sybase:Tds:MyDbComputerNameOrIP:2638\", sUsr, sPwd );

//(Default-Username/Password: \"dba\"/\"sql\")

5. Microsoft SQLServer()

rName( \"iver\" );

cn = tConnection( \"jdbc:jtds: sUsr, sPwd );

6. Microsoft SQLServer()

rName( \"LServerDriver\" );

cn = tConnection( \"jdbc:microsoft: sUsr, sPwd );

7. ODBC

rName( \"bcOdbcDriver\" );

Connection cn = tConnection( \"jdbcdbc:\" + sDsn, sUsr, sPwd );

2

rName(\"2Driver\");

String url=\"jdbc:db2://192.9.200.108:6789/SAMPLE\"

cn = tConnection( url, sUsr, sPwd ); 鏌ョ湅鏈枃鏉ユ簮