jdbc连接数据库的代码片段

// 连接DB2数据库
Class.forName( " com.ibm.db2.jdbc.app.DB2Driver  " ).newInstance();
String url = " jdbc:db2://localhost:5000/sample " ; // sample为你的数据库名
String user = " db2 " ;
String password = " db2 " ;
Connection conn =  DriverManager.getConnection(url,user,password);

// 连接Informix数据库
Class.forName( " com.informix.jdbc.IfxDriver " ).newInstance();
String url  =
" jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;
user = testuser;password = testpassword " ;//myDB为你的数据库名
Connection conn =  DriverManager.getConnection(url); 

// 连接Sybase数据库
Class.forName( " com.sybase.jdbc.SybDriver " ).newInstance();
String url  = "  jdbc:sybase:Tds:localhost:5007/mydb " ; // mydb为你的数据库名
Connection conn =  DriverManager.getConnection(url,  " user " , " psw " );

// 连接PostgreSQL数据库
Class.forName( " org.postgresql.Driver " ).newInstance();
String url  = " jdbc:postgresql://localhost/soft " ; // soft为你的数据库名
Connection conn =  DriverManager.getConnection(url, " user " , " password " );