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

最新推荐文章于 2023-03-30 14:58:01 发布

csjiedn

最新推荐文章于 2023-03-30 14:58:01 发布

阅读量433

点赞数 1

文章标签：数据库 jdbc string url user postgresql

本文链接：https://blog.csdn.net/csjiedn/article/details/2600401

版权

//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);