dbconn.java

MyEclipse6.0+SQL2000开发简单的通讯录系统

package org.dbUtil;

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

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

public class DBConn {
	public static Connection getConnection() throws SQLException, NamingException{
		Context context = new InitialContext();   
			//获得数据源   
		DataSource ds = (DataSource) context.lookup("java:comp/env/jdbc/PHCCS");   
			//获取连接   
		Connection conn = ds.getConnection();
		return conn;
	}

	public static void close(Connection con){
		if(con!=null){
			try{
				con.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	}
}