1銆佹瘮杈冨父鐢?/strong>
try{
Class.forName("com.mysql.jdbc.Driver");//鍔犺澆鏁版嵁搴撻┍鍔?/span>
String url="jdbc:mysql://localhost:3306/databasename";//鏁版嵁搴撹繛鎺ュ瓙鍗忚
Connection conn=DriverManager.getConnection(url,"username","password");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from tablename");
while(rs.next()){//涓嶆柇鎸囧悜涓嬩竴鏉¤褰?/strong>
System.out.println("DeptNo:"+rs.getInt(1));
System.out.println("\tDeptName:"+rs.getString(2));
System.out.println("\tLOC:"+rs.getString(3));
}
rs.close();
stmt.close();
conn.close();
}catch(ClassNotFoundException e){
System.out.println("鎵句笉鍒版寚瀹氱殑椹卞姩紼嬪簭綾伙紒");
}catch(SQLException e){
e.printStackTrace();
}
2銆侀氳繃緋葷粺鐨勫睘鎬ц緗?/strong>
try{
System.setProperty("jdbc.driver","com.mysql.jdbc.Driver");//緋葷粺灞炴ф寚瀹氭暟鎹簱椹卞姩
String url="jdbc:mysql://localhost:3306/databasename";//鏁版嵁搴撹繛鎺ュ瓙鍗忚
Connection conn=DriverManager.getConnection(url,"username","password");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from tablename");
while(rs.next()){//涓嶆柇鎸囧悜涓嬩竴鏉¤褰?/strong>
System.out.println("DeptNo:"+rs.getInt(1));
System.out.println("\tDeptName:"+rs.getString(2));
System.out.println("\tLOC:"+rs.getString(3));
}
rs.close();
stmt.close();
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
3銆佺湅璧鋒潵姣旇緝鐩磋鐨勪竴縐嶆柟寮忥紝娉ㄥ唽鐩稿簲鐨刣b鐨刯dbc椹卞姩錛?鍦ㄧ紪璇戞椂闇瑕佸鍏ュ搴旂殑lib
try{
new com.mysql.jdbc.Driver();//鍒涘緩driver瀵硅薄錛屽姞杞芥暟鎹簱椹卞姩
String url="jdbc:mysql://localhost:3306/databasename";//鏁版嵁搴撹繛鎺ュ瓙鍗忚
Connection conn=DriverManager.getConnection(url,"username","password");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from tablename");
while(rs.next()){//涓嶆柇鎸囧悜涓嬩竴鏉¤褰?/strong>
System.out.println("DeptNo:"+rs.getInt(1));
System.out.println("\tDeptName:"+rs.getString(2));
System.out.println("\tLOC:"+rs.getString(3));
}
rs.close();
stmt.close();
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
]]>
DBConnection.java
import java.sql.*;
import java.util.Locale;
import java.util.PropertyResourceBundle;
/**
* @author study
*
* 浠庣粰瀹氱殑璧勬簮淇℃伅涓緱鍒版暟鎹簱鑱旀帴瀵硅薄
*
*/
public class DBConnection {
Connection conn = null;
/**
* 浠庣粰瀹氱殑璧勬簮鏂囦歡涓幏寰楄繛鎺ユ暟鎹簱鐨勫弬鏁?br />*
*/
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璇誨叆閿欒");
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 {
// 鍔犺澆椹卞姩紼嬪簭
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;
}
}
灞炴ф枃浠秔roduct_cn_CN.properties錛堢敤浜嶮SSQL錛?/p>
ConnectString=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DocManagerSystem
UserID=sa
Password=sa
JdbcDriverName=com.microsoft.jdbc.sqlserver.SQLServerDriver
灞炴ф枃浠秔roduct_cn_CN.properties錛堢敤浜嶮YSQL錛?/p>
ConnectString=jdbc:mysql://localhost:3306/mydata
UserID=sa
Password=sa
JdbcDriverName=com.mysql.jdbc.Driver
]]>
]]>