JDBC Connection Database Experience Technique collection

Skills | Connecting to a database Java database connection (JDBC) consists of a set of classes and interfaces written in the Java programming language. JDBC provides tools/database developers with a standard API that enables them to write database applications with a pure Java API. However, each developer's interface is not exactly the same, so the development environment changes will bring a certain configuration changes. This article mainly sets up the connection ways of different databases.

　　One, connect various database way quick look-up table

The following is a list of how the various databases use JDBC connections and can be used as a manual.

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

　　7. PostgreSQL Database

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

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, "", "");
Statement stmtnew=conn.createstatement ();

　　Two, JDBC connection MySQL Way

Here's a little tutorial on using JDBC to connect to MySQL

　　1. Find the driver

MySQL currently offers Java drivers for connection/j, which can be downloaded from the MySQL official website, and locate the Mysql-connector-java-3.0.15-ga-bin.jar file, which is a pure Java driver and does not require additional configuration.

　　2, dynamic designation Classpath

If you need to dynamically specify CLASSPATH when executing, use the-CP method at execution time. Otherwise, add the. jar file above to the CLASSPATH environment variable.

　　3. Load Driver

try{
Class.forName (Com.mysql.jdbc.Driver);
System.out.println (Success loading Mysql driver!);
}catch (Exception e)
{
System.out.println (Error loading Mysql driver!);
E.printstacktrace ();
}

　　4, set the URL of the connection

JDBC:MYSQL://LOCALHOST/DATABASENAME[?PA=VA][&PA=VA]

[1] [2] Next page