JDBC驱动加载注册及数据库接(集)

2019-04-14 21:57发布

站内文章 / 模拟电子
11114 0 1467
//Oracle8/8i/9i数据库(thin模试)
 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

//Sql Server7.0/2000数据库
Class.forName("com.microsoft.jdbc.sqlserver.SqlServerDriver").newInstance();

 //DB2数据库
 Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance();

//Informix数据库
 Class.forName("com.informix.jdbc.IfxDriver").newInstance();

//Sybase数据库
 Class.forName("com.sybase.jdbc.SybDriver").newInstance();

//MySql数据库
 Class.forName("com.mysql.jdbc.Driver").newInstance(); 

//PostgreSQL数据库
 Class.forName("org.postgresql.Driver").newInstance();


 //Oracle8/8i/9i数据库(thin模试)
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String user = "scott";
String password = "tiger";
Connection conn = DriverManager.getConnection(url, user, password);

//Sql Server7.0/2000数据库
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user = "sa";
String password = "";
Connection conn = DriverManager.getConnection(url, user, password);

//DB2数据库
String url = "jdbc:db2://localhost:5000/sample";
String user = "admin";
String password = "";
Connection conn = DriverManager.getConnection(url, user, password);

//Informix数据库
String url = "jdbc:informix-sqli://localhost:1533/testDB:INFORMIXSERVER=        myserver";
String user = "testuser";
String password = "testpassword";
Connection conn = DriverManager.getConnection(url);

//Sybase数据库
String url = "jdbc:sybase:Tds:localhost:5007/tsdata"; 
Properties sysProps = System.getProperties();
SysProps.put("user", "userid");
SysProps.put("password", "user_password");
Connection conn = DriverManager.getConnection(url, SysProps);

//MySql数据库
String url = "jdbc:mysql://localhost:3306/testDB?user=root&password=root&        useUnicode = true&characterEncoding=gb2312";
Connection conn = DriverManager.getConnection(url);

//PostgreSQL数据库
String url = "jdbc:postgresql://localhost/testDB" ;
String user = "myuser";
String password = "mypassword";
Donnecton conn = DriverManager.getConnection(url, user, password);

热门文章