JAVA常用操作语句 项目中的总结三

获得mysql和oracle链接的类
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectDB {
private static final String MYSQL = "jdbc:mysql://";
private static final String ORACLE = "jdbc:oracle:thin:@";
private ConnectDB() {
}
public static Connection getInstance(String DBType, String url)
throws NoSuchDBException, SQLException
{
if ("mysql".equalsIgnoreCase(DBType))
return getMySqlConn(url);
if ("oracle".equalsIgnoreCase(DBType))
return getOracleConn(url);
return null;
}
public static void closeConn(Connection conn) {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
private static Connection getMySqlConn(String url) throws SQLException {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
conn = DriverManager.getConnection(MYSQL + url, "root", "root");
return conn;
}
private static Connection getOracleConn(String url) throws SQLException {
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
conn = DriverManager.getConnection(ORACLE + url, "scott", "tiger");
return conn;
}
}
数据库链接类——通过配置文件
/*
* Db.java
Created on 2007年8月20日, 上午 8:37
*/
import
java.io.
*
;
import
java.sql.
*
;
import
java.util.Properties;
public

class
Db {

private
String driver;

private
String url;

private
String user;

private
String password;

private
Connection conn;

private
Statement stm;

private
ResultSet rs;

public
Db(){

this
(
"
DBConf.properties
"
);
}