connectionfactory.java

来自「Java协同办公系统。实现公司内部的人事」· Java 代码 · 共 68 行

package com.icss.oa.utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
import java.util.ResourceBundle;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class ConnectionFactory {
	
	public static Connection getConnection(){
			
			Connection conn  = null;
			
			Properties properties = new Properties();
		
			try {
				
				ResourceBundle resources = ResourceBundle.getBundle("db");
	
				String driverClass = resources.getString("driver");
				
				Class.forName(driverClass);
	
				String url = resources.getString("url");
				
				String username=resources.getString("username");
				String userpass=resources.getString("userpass");
				
				conn = DriverManager.getConnection(url,username,userpass);
	
				System.out.println("conn:================"+conn);
				
			} catch (Exception e) {
			
				e.printStackTrace();
			}
			return conn;
	
		}
	
   public static Connection getConnectionByJNDI(){
		
		Connection conn  = null;
		
		try {
			System.out.println("asdfsadf");

			Context initCtx = new InitialContext();
			
			DataSource ds = (DataSource) initCtx.lookup("java:comp/env/jdbc/che");

			conn = ds.getConnection();
			
			System.out.println("JNDIconn:"+conn);
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
}