dbmanager.java

来自「使用jsp+Servlet,采用MVC模式,实现了一典型小型电子商务网站的全过程」· Java 代码 · 共 37 行

/**
 * 
 */
package com.eshop.util;

import java.sql.Connection;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;

/**
 * @author jonson
 *
 */
public class DBManager {
	public Connection GetConnection(){
		Connection conn = null;
		Context initCtx;
		try {
			initCtx = new InitialContext();
			Context ctx = (Context) initCtx.lookup("java:comp/env");
			Object obj = (Object) ctx.lookup("jdbc/eshop");
			javax.sql.DataSource ds = (javax.sql.DataSource) obj;
			conn = ds.getConnection();
			
		} catch (NamingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();		
		}
		return conn;
		}
	}