viewresult.java

java 数据库 功能强大 效率高 SmallSQL Database is a free DBMS library for the Java(tm) platform. It runs on

/* =============================================================
 * SmallSQL : a free Java DBMS library for the Java(tm) platform
 * =============================================================
 *
 * (C) Copyright 2004-2006, by Volker Berlin.
 *
 * Project Info:  http://www.smallsql.de/
 *
 * This library is free software; you can redistribute it and/or modify it 
 * under the terms of the GNU Lesser General Public License as published by 
 * the Free Software Foundation; either version 2.1 of the License, or 
 * (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful, but 
 * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY 
 * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public 
 * License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, 
 * USA.  
 *
 * [Java is a trademark or registered trademark of Sun Microsystems, Inc. 
 * in the United States and other countries.]
 *
 * ---------------
 * ViewResult.java
 * ---------------
 * Author: Volker Berlin
 * 
 * Created on 05.06.2004
 */
package smallsql.database;

import java.sql.*;


/**
 * @author Volker Berlin
 */
class ViewResult extends TableViewResult {
	
	final private View view;
	final private Expressions columnExpressions;
	final private CommandSelect commandSelect;


	ViewResult(View view){
		this.view = view;
		this.columnExpressions = view.commandSelect.columnExpressions;
		this.commandSelect     = view.commandSelect;
	}
	

	/**
	 * Constructor is used for UNION
	 * @throws Exception 
	 * 
	 */
	ViewResult(SSConnection con, CommandSelect commandSelect) throws SQLException{
		try{
			this.view = new View( con, commandSelect);
			this.columnExpressions = commandSelect.columnExpressions;
			this.commandSelect     = commandSelect;
		}catch(Exception e){
			throw Utils.createSQLException(e);
		}
	}
	
	
	/**
	 * Is used for compile() of different Commands
	 * 
	 * @param con
	 * @return true if now init; false if already init
	 * @throws Exception
	 */
	boolean init( SSConnection con ) throws Exception{
		if(super.init(con)){
			commandSelect.compile(con);
			return true;
		}
		return false;
	}




/*=====================================================================
 * 
 * Methods of base class TableViewResult
 * 
 ====================================================================*/	
	
	TableView getTableView(){
		return view;
	}
	
	
	void deleteRow() throws SQLException{
		commandSelect.deleteRow(con);
	}

	void updateRow(Expression[] updateValues) throws Exception{
		commandSelect.updateRow(con, updateValues);
	}
	
	void insertRow(Expression[] updateValues) throws Exception{
		commandSelect.insertRow(con, updateValues);
	}

/*=====================================================================
 * 
 * Methods of interface DataSource
 * 
 ====================================================================*/	
	boolean isNull(int colIdx) throws Exception {
		return columnExpressions.get(colIdx).isNull();
	}


	boolean getBoolean(int colIdx) throws Exception {
		return columnExpressions.get(colIdx).getBoolean();
	}


	int getInt(int colIdx) throws Exception {
		return columnExpressions.get(colIdx).getInt();
	}


	long getLong(int colIdx) throws Exception {
		return columnExpressions.get(colIdx).getLong();
	}


	float getFloat(int colIdx) throws Exception {
		return columnExpressions.get(colIdx).getFloat();
	}


	double getDouble(int colIdx) throws Exception {
		return columnExpressions.get(colIdx).getDouble();
	}


	long getMoney(int colIdx) throws Exception {
		return columnExpressions.get(colIdx).getMoney();
	}


	MutableNumeric getNumeric(int colIdx) throws Exception {
		return columnExpressions.get(colIdx).getNumeric();
	}


	Object getObject(int colIdx) throws Exception {
		return columnExpressions.get(colIdx).getObject();
	}


	String getString(int colIdx) throws Exception {
		return columnExpressions.get(colIdx).getString();
	}


	byte[] getBytes(int colIdx) throws Exception {
		return columnExpressions.get(colIdx).getBytes();
	}


	int getDataType(int colIdx) {
		return columnExpressions.get(colIdx).getDataType();
	}


	/*=====================================================
	 * 
	 * Methods of the interface RowSource
	 * 
	 =====================================================*/
	
	void beforeFirst() throws Exception {
		commandSelect.beforeFirst();
	}


	boolean isBeforeFirst() throws SQLException{
		return commandSelect.isBeforeFirst();
	}
	
	
	boolean isFirst() throws SQLException{
		return commandSelect.isFirst();
	}
	
	
	boolean first() throws Exception {
		return commandSelect.first();
	}


	boolean previous() throws Exception{
		return commandSelect.previous();
	}
	
	
	boolean next() throws Exception {
		return commandSelect.next();
	}


	boolean last() throws Exception{
		return commandSelect.last();
	}
	
	
	boolean isLast() throws Exception{
		return commandSelect.isLast();
	}


	boolean isAfterLast() throws Exception{
		return commandSelect.isAfterLast();
	}
    

	void afterLast() throws Exception{
		commandSelect.afterLast();
	}
	
	
	boolean absolute(int row) throws Exception{
		return commandSelect.absolute(row);
	}
	
	
	boolean relative(int rows) throws Exception{
		return commandSelect.relative(rows);
	}
	
	
	int getRow() throws Exception{
		return commandSelect.getRow();
	}
	
	
	long getRowPosition() {
		return commandSelect.join.getRowPosition();
	}


	void setRowPosition(long rowPosition) throws Exception {
		commandSelect.join.setRowPosition(rowPosition);
	}


	final boolean rowInserted(){
		return commandSelect.join.rowInserted();
	}
	
	
	final boolean rowDeleted(){
		return commandSelect.join.rowDeleted();
	}
	
	
	void nullRow() {
		commandSelect.join.nullRow();

	}


	void noRow() {
		commandSelect.join.noRow();
	}

	
	final void execute() throws Exception{
		commandSelect.join.execute();
	}
}