src/org/objectweb/cjdbc/common/sql/InsertRequest.java

説明を見る。

package org.objectweb.cjdbc.common.sql;

import java.io.Serializable;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.StringTokenizer;

import org.objectweb.cjdbc.common.sql.schema.DatabaseColumn;
import org.objectweb.cjdbc.common.sql.schema.DatabaseSchema;
import org.objectweb.cjdbc.common.sql.schema.DatabaseTable;
import org.objectweb.cjdbc.common.sql.schema.TableColumn;

public class InsertRequest extends AbstractWriteRequest implements Serializable
{
  public InsertRequest(String sqlQuery, boolean escapeProcessing, int timeout,
      String lineSeparator, DatabaseSchema schema, int granularity,
      boolean isCaseSensitive) throws SQLException
  {
    this(sqlQuery, escapeProcessing, timeout, lineSeparator);
    parse(schema, granularity, isCaseSensitive);
  }

  public InsertRequest(String sqlQuery, boolean escapeProcessing, int timeout,
      String lineSeparator)
  {
    super(sqlQuery, escapeProcessing, timeout, lineSeparator);
    cacheable = RequestType.UNCACHEABLE;
    isParsed = false;
  }

  public void parse(DatabaseSchema schema, int granularity,
      boolean isCaseSensitive) throws SQLException
  {
    if (granularity == ParsingGranularities.NO_PARSING)
    {
      isParsed = true;
      return;
    }

    // Sanity check
    if (schema == null)
      throw new SQLException(
          "Unable to parse request with an undefined database schema");

    String originalSQL = this.trimCarriageReturn();
    String sql = originalSQL.toLowerCase();

    // Strip 'insert into '
    sql = sql.substring(7).trim().substring(5).trim();

    // Look for the VALUES or SELECT clause
    int endIdx = sql.indexOf("values ");
    if (endIdx == -1)
    {
      endIdx = sql.indexOf("values(");
      if (endIdx == -1)
      {
        endIdx = sql.indexOf("select ");
        if (endIdx == -1)
          throw new SQLException(
              "Unable to find the VALUES or SELECT keyword in this INSERT statement: '"
                  + sqlQuery + "'");
      }
    }

    if (isCaseSensitive)
    {
      int shift = originalSQL.length() - sql.length();
      sql = originalSQL.substring(shift, shift + endIdx).trim();
    }
    else
      sql = sql.substring(0, endIdx).trim();

    int openParenthesisIdx = sql.indexOf("(");

    // Get the table on which INSERT occurs
    String insertTable;
    if (openParenthesisIdx == -1)
      insertTable = sql;
    else
      insertTable = sql.substring(0, openParenthesisIdx).trim();

    DatabaseTable t = schema.getTable(insertTable, isCaseSensitive);
    if (t == null)
      throw new SQLException("Unknown table '" + insertTable
          + "' in this INSERT statement: '" + sqlQuery + "'");
    else
      tableName = t.getName();

    if ((granularity == ParsingGranularities.COLUMN)
        || (granularity == ParsingGranularities.COLUMN_UNIQUE))
    {
      if (openParenthesisIdx != -1)
      {
        // Fetch the affected columns
        int closingParenthesisIdx = sql.indexOf(")");
        if ((closingParenthesisIdx == -1) || (closingParenthesisIdx > endIdx))
        {
          tableName = null;
          columns = null;
          throw new SQLException(
              "Syntax error in columns definition for this INSERT statement: '"
                  + sqlQuery + "'");
        }

        // Column names are separated by comas
        StringTokenizer columnTokens = new StringTokenizer(sql.substring(
            openParenthesisIdx + 1, closingParenthesisIdx), ",");
        columns = new ArrayList();
        DatabaseColumn col = null;
        while (columnTokens.hasMoreTokens())
        {
          String token = columnTokens.nextToken().trim();
          if ((col = t.getColumn(token)) == null)
          {
            tableName = null;
            columns = null;
            throw new SQLException("Unknown column name '" + token
                + "' in this INSERT statement: '" + sqlQuery + "'");
          }
          else
          {
            columns.add(new TableColumn(tableName, col.getName()));
          }
        }
      }
      else
      {
        // All columns are affected
        columns = new ArrayList();
        ArrayList cols = t.getColumns();
        int size = cols.size();
        for (int j = 0; j < size; j++)
        {
          columns.add(new TableColumn(tableName, ((DatabaseColumn) cols.get(j))
              .getName()));
        }
      }
    }

    isParsed = true;
  }

  public void cloneParsing(AbstractRequest request)
  {
    if (!request.isParsed())
      return;
    cloneTableNameAndColumns((AbstractWriteRequest) request);
    isParsed = true;
  }

  public boolean isInsert()
  {
    return true;
  }

  public boolean isUpdate()
  {
    return false;
  }

  public boolean isDelete()
  {
    return false;
  }

  public boolean isCreate()
  {
    return false;
  }

  public boolean isDrop()
  {
    return false;
  }

  public void debug()
  {
    super.debug();
    if (tableName != null)
      System.out.println("Inserted table: " + tableName);
    else
      System.out.println("No information about inserted table");

    if (columns != null)
    {
      System.out.println("Inserted columns:");
      for (int i = 0; i < columns.size(); i++)
        System.out.println("  "
            + ((TableColumn) columns.get(i)).getColumnName());
    }
    else
      System.out.println("No information about inserted columns");

    System.out.println("");
  }
  public boolean isAlter()
  {
    return false;
  }
}

---