使用Java程序連接各種數(shù)據(jù)庫的方法介紹

本文格式為Word版，下載可任意編輯——使用Java程序連接各種數(shù)據(jù)庫的方法介紹使用Java程序連接各種數(shù)據(jù)庫的方法介紹

導(dǎo)語：Java數(shù)據(jù)庫連接，是Java語言中用來模范客戶端程序如何來訪問數(shù)據(jù)庫的應(yīng)用程序接口，供給了諸如查詢和更新數(shù)據(jù)庫中數(shù)據(jù)的方法。

1、Oracle8/8i/9i數(shù)據(jù)庫thin模式

Class.forNameoracle.jdbc.driver.OracleDriver.newInstance;

Stringurl=jdbc:oracle:thin:@localhost:1521:orcl;//orcl為數(shù)據(jù)庫的SID

Stringuser=test;

Stringpassword=test;

Connectionconn=DriverManager.getConnectionurl,user,password;

2、DB2數(shù)據(jù)庫

Class.forNamecom.ibm.db2.jdbc.app.DB2Driver.newInstance;

Stringurl=jdbc:db2://localhost:5000/sample;//sample為你的.數(shù)據(jù)庫名

Stringuser=admin;

Stringpassword=;

Connectionconn=DriverManager.getConnectionurl,user,password;

3、SQLServer7.0/2000數(shù)據(jù)庫

Class.forNamecom.microsoft.jdbc.sqlserver.SQLServerDriver.newInstance;

Stringurl=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb;

//mydb為數(shù)據(jù)庫

Stringuser=sa;

Stringpassword=;

Connectionconn=DriverManager.getConnectionurl,user,password;

4、Sybase數(shù)據(jù)庫

Class.forNamecom.sybase.jdbc.SybDriver.newInstance;

Stringurl=jdbc:sybase:Tds:localhost:5007/myDB;//myDB為你的數(shù)據(jù)庫名

PropertiessysProps=System.getProperties;

SysProps.putuser,userid;

SysProps.putpassword,user_password;

Connectionconn=DriverManager.getConnectionurl,SysProps;

5、Informix數(shù)據(jù)庫

Class.forNrmix.jdbc.IfxDriver.newInstance;

Stringurl=jdbc:informix-sqli://9:1533/myDB:INFORMIXSERVER=myserver;

user=testuser;password=testpassword;//myDB為數(shù)據(jù)庫名

Connectionconn=DriverManager.getConnectionurl;

6、MySQL數(shù)據(jù)庫

Class.forNameorg.gjt.mm.mysql.Driver.newInstance;

//或者Class.forNamecom.mysql.jdbc.Driver;

Stringurl=jdbc:mysql://localhost/myDB?

user=softpassword=soft1234useUnicode=truecharacterEncoding=8859_1

//myDB為數(shù)據(jù)庫名

Connectionconn=DriverManager.getConnectionurl;

7、PostgreSQL數(shù)據(jù)庫

Class.forNameorg.postgresql.Driver.newInstance;

Stringurl=jdbc:postgresql://localhost/myDB//myDB為數(shù)據(jù)庫名

Stringuser=myuser;

Stringpassword=mypassword;

Connectionconn=DriverManager.getConnectionurl,user,password;

8、access數(shù)據(jù)庫直連用ODBC的

Class.forNamesun.jdbc.odbc.JdbcOdbcDriver;

Stringurl=jdbc:odbc:Driver=MicroSoftAccessDriver

*.mdb;DBQ=+application.getRealPath/Data