經(jīng)常忘記怎么連接數(shù)據(jù)庫(kù)，貼出來(lái)備用
DBConnection.java
import java.sql.*;
import java.util.Locale;
import java.util.PropertyResourceBundle;
/**
* @author study
*
* 從給定的資源信息中得到數(shù)據(jù)庫(kù)聯(lián)接對(duì)象
*
*/
public class DBConnection {
Connection conn = null;
/**
* 從給定的資源文件中獲得連接數(shù)據(jù)庫(kù)的參數(shù)
*
*/
public boolean getConnect() {
String str_URL = "";
String str_userName = "";
String str_passWord = ""; // the connect passWord
String str_JdbcDriverName = ""; // the connect JDBCDriverName
// Connection con = null;
try {
PropertyResourceBundle configBundle = (PropertyResourceBundle) PropertyResourceBundle
.getBundle("common.jiangbin.dms.product",
new Locale("cn", "CN"));
if (configBundle == null) {
System.out.println("文件product_cn_CN.properties讀入錯(cuò)誤");
return false;
}
// the connect URL
str_URL = configBundle.getString("ConnectString");
// the connect userName
str_userName = configBundle.getString("UserID");
// the connect passWord
str_passWord = configBundle.getString("Password");
// the connect JDBCDriverName
str_JdbcDriverName = configBundle.getString("JdbcDriverName");
try {
// 加載驅(qū)動(dòng)程序
Class.forName(str_JdbcDriverName).newInstance();
} catch (ClassNotFoundException e) {
System.out.println("Driver not found");
}
// DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
// DriverManager.registerDriver(null);
this.conn = DriverManager.getConnection(str_URL, str_userName,
str_passWord);
} catch (Exception e) {
e.printStackTrace();
return false;
}
return true;
}
/**
* Returns the conn.
*
* @return Connection
*/
public Connection getConn() {
return conn;
}
/**
* Sets the conn.
*
* @param conn
* The conn to set
*/
public void setConn(Connection conn) {
this.conn = conn;
}
}
屬性文件product_cn_CN.properties（用于MSSQL）
ConnectString=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DocManagerSystem
UserID=sa
Password=sa
JdbcDriverName=com.microsoft.jdbc.sqlserver.SQLServerDriver
屬性文件product_cn_CN.properties（用于MYSQL）
ConnectString=jdbc:mysql://localhost:3306/mydata
UserID=sa
Password=sa
JdbcDriverName=com.mysql.jdbc.Driver