operation.java

来自「用最近的dojo1.2.1制作前端的ajax购书网站」· Java 代码 · 共 64 行

package server.database;
import java.util.*;
import java.sql.*;

public class Operation {
	private Initial database=new Initial();
	private void getstat()
	throws SQLException,InstantiationException,IllegalAccessException,ClassNotFoundException

	{
		if(database.stat==null)
		database.getStatement();
	}
	
	
	
	public int IDU(String sql)
	throws SQLException,InstantiationException,IllegalAccessException,ClassNotFoundException
	{
		getstat();
		return database.stat.executeUpdate(sql);
	}
	public ResultSet select(String sql)
	throws SQLException,InstantiationException,IllegalAccessException,ClassNotFoundException
	{
		getstat();
		database.rs=database.stat.executeQuery(sql);
	
		return database.rs;
	}
	private void initRS(String sql)
	throws SQLException,InstantiationException,IllegalAccessException,ClassNotFoundException
	{database.rs=select(sql);
	}
	public void init(String sql)
	throws SQLException,InstantiationException,IllegalAccessException,ClassNotFoundException

	{
		if(database.rs==null)
		initRS(sql);
	}
	
	public void closeResultSet()
	throws SQLException,InstantiationException,IllegalAccessException,ClassNotFoundException
	
	{database.closeResultSet();}
	public void closeStatement()
	throws SQLException,InstantiationException,IllegalAccessException,ClassNotFoundException
	
	{database.closeStatement();
	}
	public void closeConnection()
	throws SQLException,InstantiationException,IllegalAccessException,ClassNotFoundException
	
	{database.closeConnection();
	}
	
	
}