Java connection instances of various databases
Last Update:2017-02-28
Source: Internet
Author: User
Data | Database The code in this article lists the key code that connects the database, the other Access database code is omitted
1, oracle8/8i/9i database (thin mode)
class.forname ("Oracle.jdbc.driver.OracleDriver"). newinstance ();
String url= "Jdbc:oracle:thin: @localhost: 1521:ORCL";
//ORCL is the SID of the database
String user= "test";
String password= "test";
Connection conn= drivermanager.getconnection (Url,user,password);
2, DB2 database
class.forname ("Com.ibm.db2.jdbc.app.DB2Driver"). newinstance ();
String url= "Jdbc:db2://localhost:5000/sample";
//sample for your database name
String user= "admin";
String password= "";
Connection conn= drivermanager.getconnection (Url,user,password);
3, SQL server7.0/2000 database
class.forname ("Com.microsoft.jdbc.sqlserver.SQLServerDriver"). newinstance ();
String url= "Jdbc:microsoft:sqlserver://localhost:1433;databasename=mydb";
//mydb for Database
String user= "sa";
String password= "";
Connection conn= drivermanager.getconnection (Url,user,password);
4, Sybase database
class.forname ("Com.sybase.jdbc.SybDriver"). newinstance ();
String url = "Jdbc:sybase:tds:localhost:5007/mydb";
//mydb for your database name
Properties sysprops = system.getproperties ();
sysprops.put ("User", "userid");
sysprops.put ("Password", "User_password");
Connection conn= drivermanager.getconnection (URL, sysprops);
5, Informix Database
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 is a database name
Connection conn= drivermanager.getconnection (URL);
6, MySQL database
class.forname ("Org.gjt.mm.mysql.Driver"). newinstance ();
String url = "jdbc:mysql://localhost/mydb?user=soft&password=soft1234&useunicode=true& Characterencoding=8859_1 "
//mydb is a database name
Connection conn= drivermanager.getconnection (URL);
7, PostgreSQL database
class.forname ("Org.postgresql.Driver"). newinstance ();
String url = "Jdbc:postgresql://localhost/mydb"
//mydb is a database name
String user= "MyUser";
String password= "MyPassword";
Connection conn= drivermanager.getconnection (Url,user,password);