dbconnect.java

来自「这个程序是花了好几十万请人开发的」· Java 代码 · 共 38 行

package javabean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javabean.ConnectionPool;

public class dbconnect {
	
	private ConnectionPool pool;
	private Connection con;
	ResultSet rs;
	
	public dbconnect(){
		pool=ConnectionPool.getInstance();               //初始化连接池
	}
	
	public ResultSet executeQuery(String sql) throws SQLException
	{
		try
		{
			con=pool.getConnection();
			Statement statement = con.createStatement();
			rs = statement.executeQuery(sql);
		}
		catch(SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		con.commit();
		con.close();
		return rs;
	}

}