public class DBAccess {
// 连接SQLServer
private final static String DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private final static String URL = "jdbc:microsoft:sqlserver://tb704-16:1433;databasename = pubs";
private final static String USERNAME = "sa";
private final static String PASSWORD = "sa";// 连接oracle
private final static String DRIVER = "oracle.jdbc.driver.OracleDriver";
private final static String URL = "jdbc:oracle:thin:@tb704-16:1521;oracle";
private final static String USERNAME = "scott";
private final static String PASSWORD = "tiger";
Connection conn = null;
public DBAccessSQLServer(){
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
/**
* 获得数据库连接
* @return
*/
public Connection getConnection(){
try {
if(conn == null || conn.isClosed()){
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return conn;
}
/**
* 关闭数据库连接
*/
public void closeConnection(){
try {
if(conn != null){
conn.close();
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
/**
* 执行SQL语句
*/
public boolean executeSQL(String sql){
boolean isSuccess = false;
DBAccessSQLServer access = new DBAccessSQLServer();
Connection conn = access.getConnection();
Statement stmt = null;
getConnection();
try {
int result = stmt.executeUpdate(sql);
if(result > 0){
isSuccess = true;
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return isSuccess;
}
/**
* 返回结果集
*/
public ResultSet getResult(String sql){
Statement stmt = null;
ResultSet rs = null;
getConnection();
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return rs;
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成方法存根 // 测试数据库连接是否成功
DBAccessSQLServer access = new DBAccessSQLServer();
Connection conn = access.getConnection();
System.out.println("conn:" + conn);
access.closeConnection();
}}
// 连接SQLServer
private final static String DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private final static String URL = "jdbc:microsoft:sqlserver://tb704-16:1433;databasename = pubs";
private final static String USERNAME = "sa";
private final static String PASSWORD = "sa";// 连接oracle
private final static String DRIVER = "oracle.jdbc.driver.OracleDriver";
private final static String URL = "jdbc:oracle:thin:@tb704-16:1521;oracle";
private final static String USERNAME = "scott";
private final static String PASSWORD = "tiger";
Connection conn = null;
public DBAccessSQLServer(){
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
/**
* 获得数据库连接
* @return
*/
public Connection getConnection(){
try {
if(conn == null || conn.isClosed()){
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return conn;
}
/**
* 关闭数据库连接
*/
public void closeConnection(){
try {
if(conn != null){
conn.close();
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
/**
* 执行SQL语句
*/
public boolean executeSQL(String sql){
boolean isSuccess = false;
DBAccessSQLServer access = new DBAccessSQLServer();
Connection conn = access.getConnection();
Statement stmt = null;
getConnection();
try {
int result = stmt.executeUpdate(sql);
if(result > 0){
isSuccess = true;
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return isSuccess;
}
/**
* 返回结果集
*/
public ResultSet getResult(String sql){
Statement stmt = null;
ResultSet rs = null;
getConnection();
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return rs;
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成方法存根 // 测试数据库连接是否成功
DBAccessSQLServer access = new DBAccessSQLServer();
Connection conn = access.getConnection();
System.out.println("conn:" + conn);
access.closeConnection();
}}
解决方案 »
- JSTL异常
- javamail出错:com.sun.mail.util.FolderClosedIOException
- java:不使用流,如何实现文件复制上传(欢迎帮顶)
- Strur2中<S:select>问题急!
- 关于web工程的执行顺序和xml中的配置以及servlet和ajax的关系?
- Freemarker读取session 及判断语句的问题
- java.lang.ClassCastException: org.apache.struts.action.RequestProcessor
- 一个项目启动无异常,但是在tomcat管理页面看不到这个项目,好像是mysql驱动的原因,里面有启动信息和描述,解决立马给分
- 200分寻求Addison Wesley出版的《J2EE Web Services》
- jsp页面如何引用服务器本地磁盘资源
- weblogic连接池怎么配置spring事务?
- 系统集成问题
应该改为public DBAccess(){