Frequently used JDBC Connection Database method _ database other

First, JDBC Connection DB2

Copy Code code as follows:

Class.forName ("Com.ibm.db2.jdbc.net.DB2Driver");
String url= "Jdbc:db2://dburl:port/dbname"
cn = Drivermanager.getconnection (URL, susr, spwd);

II. JDBC Connection Microsoft SQL Server (Microsoft)

Copy Code code as follows:

Class.forName ("Com.microsoft.jdbc.sqlserver.SQLServerDriver");
cn = Drivermanager.getconnection ("Jdbc:microsoft:sqlserver://dbserverip:1433;databasename=master", SUSR, SPWD);

Iii. JDBC Connection Sybase (Jconn2.jar)

Copy Code code as follows:

Class.forName ("Com.sybase.jdbc2.jdbc.SybDriver");
cn = Drivermanager.getconnection ("jdbc:sybase:tds:dbserverip:2638", Susr, spwd);

Four, JDBC connection mysql (Mm.mysql-3.0.2-bin.jar)

Copy Code code as follows:

Class.forName ("Org.gjt.mm.mysql.Driver");
cn = Drivermanager.getconnection ("Jdbc:mysql://dbserverip:3306/mydatabasename", Susr, spwd);

V. JDBC Connection PostgreSQL (Pgjdbc2.jar)

Copy Code code as follows:

Class.forName ("Org.postgresql.Driver");
cn = Drivermanager.getconnection ("Jdbc:postgresql://dbserverip/mydatabasename", Susr, spwd);

Vi. JDBC Connection Oracle (Classes12.jar)

Copy Code code as follows:

Class.forName ("Oracle.jdbc.driver.OracleDriver");
cn = Drivermanager.getconnection ("Jdbc:oracle:thin: @MyDbComputerNameOrIP: 1521:orcl", SUSR, spwd);

Vii. JDBC Connection ODBC

Copy Code code as follows:

Class.forName ("Sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn = Drivermanager.getconnection ("JDBC:ODBC:" + sdsn, SUSR, spwd);

Some database JDBC connection methods are not fixed, depends on the driver package you use.
For example, the Jtdsjar package for MSSQL:
Database url:jdbc:jtds:sqlserver://localhost:1433;databasename=xxx
Driver class: Net.sourceforge.jtds.jdbc.Driver

1, oracle8/8i/9i database (thin mode)

Copy Code code as follows:

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

Copy Code code as follows:

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

Copy Code code as follows:

Class.forName ("Com.microsoft.jdbc.sqlserver.SQLServerDriver"). newinstance ();
String url= "Jdbc:microsoft:sqlserver://localhost:1433;databasename=mydb";
MyDB as a database
String user= "SA";
String password= "";
Connection conn= drivermanager.getconnection (Url,user,password);

4. Sybase database

Copy Code code as follows:

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

Copy Code code as follows:

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 for Database name
Connection conn= drivermanager.getconnection (URL);

6. mysql Database

Copy Code code as follows:

Class.forName ("Org.gjt.mm.mysql.Driver"). newinstance (); or Class.forName ("Com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/mydb?user=soft&password=soft1234&useunicode=true& Characterencoding=8859_1 "
MyDB for Database name
Connection conn= drivermanager.getconnection (URL);

7. PostgreSQL Database

Copy Code code as follows:

Class.forName ("Org.postgresql.Driver"). newinstance ();
String url = "Jdbc:postgresql://localhost/mydb"//mydb for database name
String user= "MyUser";
String password= "MyPassword";
Connection conn= drivermanager.getconnection (Url,user,password);

8, Access database directly with the ODBC

Copy Code code as follows:

Class.forName ("Sun.jdbc.odbc.JdbcOdbcDriver");
String url= "Jdbc:odbc:driver={microsoft Access Driver (*.mdb)};D bq=" +application.getrealpath ("/data/reportdemo.mdb ");
Connection conn = drivermanager.getconnection (URL, "", "");