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;
		}
	}
	
	
	

}