dbconnection.java

来自「用于餐饮类的源代码！只能在java下使用！！！」· Java 代码 · 共 99 行

package imis_mate.DAO;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

/**
 * @author jingyigang 2008-1-6
 * 
 * 这个类是连接数据库，创建连接池，创建连接对象。
 */
public class DBConnection {	
	
	private static Connection conn = null;
	private static DataSource ds = null;
		
	public static DataSource getDataSource(){	
		try {
			
			InitialContext initCtx = new InitialContext();

			Context envCtx = (Context)initCtx.lookup("java:comp/env");

			ds = (DataSource)envCtx.lookup("jdbc/SqlServerDB");
		 
		} catch (NamingException e) {
			
			e.printStackTrace();
		}
		
		return ds;		
	}
	
	public static Connection getConnection(){
		ds = getDataSource();
		try {
			conn = ds.getConnection();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
	
	public static void close(Connection conn){
		try {
			if(conn!=null){
				conn.close();
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public static void close(PreparedStatement ps){
		try{
			if(ps != null){
				ps.close();
			}
				
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
	
	public static void close(Statement stmt){
		try {
			if(stmt!=null){
				stmt.close();
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public static void close(ResultSet rs){
		try {
			if(rs!=null){
				rs.close();
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}    
}