conn.java

是一个企业的进销存系统。账号问1001密码为123456

package com.jxc.dao;

import java.sql.Connection;
import java.sql.SQLException;

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

public class Conn {

public static Connection getConnection(){
	Connection conn=null;
	try {
		Context initCtx=new InitialContext();
		if(initCtx==null)
			throw new Exception("不能获取Context!");
		Context ctx=(Context)initCtx.lookup("java:comp/env");
		Object obj=(Object)ctx.lookup("jdbc_test");//获取连接池对象
		javax.sql.DataSource ds=(javax.sql.DataSource)obj; //类型转换
		conn=ds.getConnection();
	} catch (NamingException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return conn;
}
}