package com.suypower.djbxt.sysmanger;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import org.apache.log4j.Logger;
public class DBconnect {
static Logger logger = Logger.getLogger(DBconnect.class.getName());
private Connection con;
private DataSource ds;
private Context ctx;
public DBconnect() throws NamingException{
ctx=this.getInitialContext();
}
public Connection getConection(){
try{
ds = (DataSource)ctx.lookup("djbxt");
con=ds.getConnection();
}catch(Exception e){
logger.error(e.toString());
e.printStackTrace();
}
return con;
}
public Context getInitialContext() throws NamingException {
Properties properties = null;
properties = new Properties();
properties.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
//properties.put(Context.PROVIDER_URL, "t3://localhost:7007");
return new InitialContext(properties);
}
public Connection getConectionByJdbc(){
String ClassName="COM.ibm.db2.jdbc.net.DB2Driver";
String url="jdbc:db2://172.23.23.4/djb";
Connection con;
try{
Class.forName(ClassName).newInstance();
con=DriverManager.getConnection(url,"db2admin","suypower");
return con;
}catch(Exception e){
logger.error(e.toString());
e.printStackTrace();
return null;
}
}
public Connection getConectionLocalhost(){
String ClassName="COM.ibm.db2.jdbc.net.DB2Driver";
String url="jdbc:db2://localhost/djb";
Connection con;
try{
Class.forName(ClassName).newInstance();
con=DriverManager.getConnection(url,"db2admin","sxz");
return con;
}catch(Exception e){
logger.error(e.toString());
e.printStackTrace();
return null;
}
}
}
collection 连接数据库
最新推荐文章于 2022-05-31 21:56:01 发布