DBAccess.java
package database;
import java.sql.*;
/**
* @author Administrator
*
*/
public class DBAccess {
private Connection m_conn;
private Statement m_stmt;
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;databasename=sc";
String uName = "sa";
String uPwd = "sa";
/**
*
*/
public DBAccess() {
this.setDriver(driver);
this.setConnection(url, uName, uPwd);
}
public DBAccess(String driver, String url, String userName, String userPWD) {
try {
m_conn = DriverManager.getConnection(url, userName, userPWD);
m_stmt = m_conn.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
}
public boolean setDriver(String driver) {
try {
Class.forName(driver);
return true;
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
public boolean setConnection(String url, String userName, String userPWD) {
try {
m_conn = DriverManager.getConnection(url, userName, userPWD);
m_stmt = m_conn.createStatement();
return true;
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
// 處理查詢
public ResultSet sendQuery(String sql) {
try {
ResultSet m_rs = m_stmt.executeQuery(sql);
return m_rs;
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}
// 處理數據更新
public int sendUpdate(String sql) {
try {
return m_stmt.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
return -1;
}
}
// 測試程序
public static void main(String[] arg) {
DBAccess db = new DBAccess();
String sql = "select * from Student";
ResultSet rs = db.sendQuery(sql);
try {
if (rs != null) {
while (rs.next()) {
System.out.println(rs.getInt("Sno") + " "
+ rs.getString("Sname"));
}
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
下面羅列了各種數據庫使用JDBC連接的方式，可以作為一個手冊使用。
1、Oracle8/8i/9i數據庫（thin模式）
Class.forName('oracle.jdbc.driver.OracleDriver').newInstance();
String url='jdbc:oracle:thin:@localhost:1521:orcl'; //orcl為數據庫的SID
String user='test';
String password='test';
Connection conn= DriverManager.getConnection(url,user,password);
2、DB2數據庫
Class.forName('com.ibm.db2.jdbc.app.DB2Driver ').newInstance();
String url='jdbc:db2://localhost:5000/sample'; //sample為你的數據庫名
String user='admin';
String password='';
Connection conn= DriverManager.getConnection(url,user,password);
3、Sql Server7.0/2000數據庫
Class.forName('com.microsoft.jdbc.sqlserver.SQLServerDriver').newInstance();
String url='jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb';
//mydb為數據庫
String user='sa';
String password='';
Connection conn= DriverManager.getConnection(url,user,password);
4、Sybase數據庫
Class.forName('com.sybase.jdbc.SybDriver').newInstance();
String url =' jdbc:sybase:Tds:localhost:5007/myDB';//myDB為你的數據庫名
Properties sysProps = System.getProperties();
SysProps.put('user','userid');
SysProps.put('password','user_password');
Connection conn= DriverManager.getConnection(url, SysProps);
5、Informix數據庫
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為數據庫名
Connection conn= DriverManager.getConnection(url);
6、MySQL數據庫
Class.forName('org.gjt.mm.mysql.Driver').newInstance(); //或者Class.forName('com.mysql.jdbc.Driver');
String url ='jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1'
//myDB為數據庫名
Connection conn= DriverManager.getConnection(url);
7、PostgreSQL數據庫
Class.forName('org.postgresql.Driver').newInstance();
String url ='jdbc:postgresql://localhost/myDB' //myDB為數據庫名
String user='myuser';
String password='mypassword';
Connection conn= DriverManager.getConnection(url,user,password);
8、access數據庫直連用ODBC的
Class.forName('sun.jdbc.odbc.JdbcOdbcDriver') ;
String url='jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ='+application.getRealPath('/Data/ReportDemo.mdb');
Connection conn = DriverManager.getConnection(url,'','');
Statement stmtNew=conn.createStatement() ;