collection 连接数据库
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;}}}
页:
[1]