带有main方式 测试 :
package cn.com.systop.common;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class BaseDAO {
/*
private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
private static final String URL = "jdbc:oracle:thin:@localhost:1521:db_oracle";
private static final String UNAME = "accp";
private static final String UPWD = "accp";
*/
private static final String DRIVER = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost:3306/db_mysql";
private static final String UNAME = "root";
private static final String UPWD = "123456";
protected Connection con;
protected PreparedStatement pstm;
protected ResultSet rs;
public void getConnection() throws Exception {
Class.forName(DRIVER);
con = DriverManager.getConnection(URL,UNAME,UPWD);
System.out.println("数据库连接成功!");
}
public void closeAll() {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (pstm != null) {
try {
pstm.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
try {
if (con != null && con.isClosed() == false) {
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args){
BaseDAO baseDAO = new BaseDAO();
try {
baseDAO.getConnection();
} catch (Exception e) {
e.printStackTrace();
}
}
}