package com.chen.utils;
import java.sql.Connection;
import java.sql.DriverManager;
public class DBConnection {
private final String DBDriver = "oracle.jdbc.driver.OracleDriver"; //"com.mysql.jdbc.Driver";
private final String Database = "CHEN";
private final String DBUrl ="jdbc:oracle:thin:@58.154.193.124:1521:" + Database;// "jdbc:mysql://localhost:3306/neucourse";
private final String DBUser = "scott";
private final String DBPassword = "tiger";
private Connection conn = null;
//构造方法,加载驱动
public DBConnection(){
try{
Class.forName(DBDriver);
this.conn = DriverManager.getConnection(DBUrl, DBUser, DBPassword);
}catch(Exception e){
System.out.println("加载驱动失败");
}
}
//取得数据库连接
public Connection getConnection(){
return conn;
}
//关闭数据库连接
public void close(){
try{
if(conn!=null)
conn.close();
}catch(Exception e){
System.out.println("数据库关闭失败");
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
public class DBConnection {
private final String DBDriver = "oracle.jdbc.driver.OracleDriver"; //"com.mysql.jdbc.Driver";
private final String Database = "CHEN";
private final String DBUrl ="jdbc:oracle:thin:@58.154.193.124:1521:" + Database;// "jdbc:mysql://localhost:3306/neucourse";
private final String DBUser = "scott";
private final String DBPassword = "tiger";
private Connection conn = null;
//构造方法,加载驱动
public DBConnection(){
try{
Class.forName(DBDriver);
this.conn = DriverManager.getConnection(DBUrl, DBUser, DBPassword);
}catch(Exception e){
System.out.println("加载驱动失败");
}
}
//取得数据库连接
public Connection getConnection(){
return conn;
}
//关闭数据库连接
public void close(){
try{
if(conn!=null)
conn.close();
}catch(Exception e){
System.out.println("数据库关闭失败");
}
}
}