东软实训，一个使用的数据库操纵类

package sdust.gink.util;

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

/*与数据库协作的类*/
public class DBUtil {

	static Connection connection = null;
	static Statement statement = null;
	static ResultSet resultSet = null;

	private static Connection getConnection() throws ClassNotFoundException,
			SQLException {
		// TODO Auto-generated method stub
		String driverName = "oracle.jdbc.driver.OracleDriver";

		String url = "jdbc:oracle:thin:@localhost:1521:oracle";
		String userName = "scott";
		String userPwd = "tiger";
		Class.forName(driverName);
		if (connection == null || connection.isClosed()) {
			connection = DriverManager.getConnection(url, userName, userPwd);
		}
		return connection;
	}

	public static int executeUpdate(String sql, Object[] params)
			throws ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub此函数实现增删改功能
		getConnection();
		java.sql.PreparedStatement preparedStatement = connection
				.prepareStatement(sql);

		if (params != null) {
			for (int i = 0; i < params.length; i++) {
				preparedStatement.setObject(i + 1, params[i]);
			}
		}
		int Ginkreturn = preparedStatement.executeUpdate();
		return Ginkreturn;
	}

	public static ResultSet executeQuery(String sql)
			throws ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub此函数重点实现查的功能

		getConnection();
		statement = connection.createStatement();
		resultSet = statement.executeQuery(sql);
		return resultSet;

	}

	public static void closeAll() throws SQLException {
		// TODO Auto-generated method stub

		if (resultSet != null) {
			resultSet.close();
		}
		if (statement != null) {
			statement.close();
		}
		if (connection != null) {
			connection.close();
		}

	}
}