tinysqltable.java

有关JDBC的使用一些编程实例,有关与数据库连接的代码

/*
 *
 * tinySQLTable - abstract class for physical table access under tinySQL
 *
 * Copyright 1996, Brian C. Jepson
 *                 ([e-mail])
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program 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 General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
 *
 */
import java.util.*;
import java.lang.*;
import java.io.*;

public abstract class tinySQLTable {

  public String table; // the name of the table

  // Hashtable to contain info about columns in the table
  //
  public Hashtable column_info = new Hashtable();

  /**
   *
   * Closes the table.
   *
   */
  public abstract void close() throws tinySQLException;

  /**
   *
   * Returns the size of a column.
   *
   * @param column name of the column.
   *
   */
  public abstract int ColSize(String column);
  
  /**
   *
   * Returns the datatype of a column.
   *
   * @param column name of the column.
   *
   */
  public abstract String ColType(String column);

  /**
   *
   * Updates the current row in the table.
   *
   * @param c Ordered Vector of column names
   * @param v Ordered Vector (must match order of c) of values
   *
   */
  public abstract void UpdateCurrentRow(Vector c, Vector v)
    throws tinySQLException;

  /**
   *
   * Position the record pointer at the top of the table.
   *
   */
  public abstract void GoTop() throws tinySQLException;
  
  /**
   *
   * Advance the record pointer to the next record.
   *
   */
  public abstract boolean NextRecord() throws tinySQLException;
   
  /**
   *
   * Insert a blank row.
   *
   */
  public abstract void InsertRow() throws tinySQLException;
   
  /**
   *
   * Retrieve a column's string value from the current row.
   *
   * @param column the column name
   *
   */
  public abstract String GetCol ( String column ) throws tinySQLException ;

  /**
   *
   * Update a single column.
   *
   * @param column the column name
   * @param value the String value with which update the column
   *
   */
  public abstract void UpdateCol( String column, String value )
    throws tinySQLException;

  /**
   *
   * Delete the current row.
   *
   */
  public abstract void DeleteRow() throws tinySQLException;

  /** 
   *
   * Is the current row deleted?
   *
   */
  public abstract boolean isDeleted() throws tinySQLException;

}