58,453
社区成员
发帖
与我相关
我的任务
分享
package com.jj.sx5.dao.connection;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.jj.sx5.utl.ConfigManager;
/**
* 功能:只完成与数据库的连接
*
* @author Administrator
*
*/
public class MyConnection {
//封装一个connection对象
public static Connection connection;
//指定数据库用户的帐号
private static String user = ConfigManager.getInstance().getValue("username");
//指定数据库用户的密码
private static String password = ConfigManager.getInstance().getValue("password");
//指定url
private static String url = ConfigManager.getInstance().getValue("url");
//指定一个数据库驱动
private static String dbDriver = ConfigManager.getInstance().getValue("dbDriver");
public static Connection getConnection(){
try{
//实例化驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//通过DriverManager对象创建connection
connection = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.106:1521:XE","TestAdmin","TestAdmin");
}catch(Exception e){
//错误信息
// System.out.print(e.getMessage());
e.printStackTrace();
}
return connection;
}
public static void closeConnection(){
if(connection != null){
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}