connsqlserver.java

来自「开发企业门户网站的最终目的是为企业提供一个简单、易用、开放、可扩展的企业信息门户」· Java 代码 · 共 72 行

package com.wsy;

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

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

public class connsqlserver {

	/** 
	 *   @param   args 
	 */
	private static Connection cn = null;

	private void getConnection() {
		if (cn != null) {
			return;
		}
		Context ctx;
		try {
			ctx = new InitialContext();
			DataSource ds = (DataSource) ctx
					.lookup("java:comp/env/jdbc/ConnectionPool");
			cn = ds.getConnection();
		} catch (NamingException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return;
	}

	public ResultSet executeQuery(String sql) {
		if (cn == null)
			getConnection();
		try {
			return cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql);
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		} finally {
		}
	}

	public int executeUpdate(String sql) {
		if (cn == null)
			getConnection();
		try {
			return cn.createStatement().executeUpdate(sql);
		} catch (SQLException e) {
			e.printStackTrace();
			return -1;
		} finally {
		}
	}

	public void close() {
		try {
			cn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			cn = null;
		}
	}
}