dbconnection.java

eclipse java/jsp 航空管理系统

package yinchao.ConnectionPool;

import javax.naming.*;
import javax.sql.*;
import java.sql.*;


/**
 * <p>Description : 用于连接数据库的类</p>
 * <p>Project     : ciqms
 * <p>Company     : 东软股份国际合作事业部</p>
 * <p>Create Date : 2005.4.24</P>
 * @author        : 康毅 | [e-mail]
 * @version       : 0.1
 *  
 */

public class DbConnection {

	Connection conn;

	Statement stmt;

	ResultSet rs = null;

	String foo = "Not Connected";

	int bar = -1;

	public DbConnection() {
		try {
			Context ctx = new InitialContext();
			if (ctx == null)
				throw new Exception("No Context！！");
            /*寻找TOMCAT下面 config.xml中对应的context*/
			DataSource ds = (DataSource) ctx
					.lookup("java:comp/env/jdbc/CiqDb");

			if (ds != null) {
				conn = ds.getConnection();

			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
    /*连接数据库方法*/
	public Connection getCon() {
		return conn;
	}

	public void d_close() throws SQLException {
		if (rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				;
			}
			rs = null;
		}
		if (stmt != null) {
			try {
				stmt.close();
			} catch (SQLException e) {
				;
			}
			stmt = null;
		}
		if (conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
				;
			}
			conn = null;
		}

	}

	protected void finalize() throws Throwable {
		try {
			d_close();
		} catch (SQLException e) {
			;
		}
	}

}