TKDBDocReferenceUpdate.java :  » Content-Management-System » webman » com » teamkonzept » webman » mainint » db » queries » Java Open Source

/*
 * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBDocReferenceUpdate.java,v 1.5 2000/05/22 15:01:47 careck Exp $
 *
 */
package com.teamkonzept.webman.mainint.db.queries;

import java.sql.*;

import com.teamkonzept.db.*;

/*
 * TKDBDocReferenceUpdate
 * Schreibt einen DS fuer eine Document_Reference
 *
 * Input: Kompl. DS
 * Output: none
 */
public class TKDBDocReferenceUpdate extends TKPrepQuery{

  public final static boolean isPrepared =
    true;
  
  public final static String[] paramOrder =
    { 
      "REFERENCE_TYPE",
      "DEST_SITE_NODE_ID", "DEST_SITE_NODE_DOC_SHORTNAME",
      "SELECTION_TYPE", "SELECTION_DATA", 
      "SRC_SITE_NODE_ID", "SRC_SITE_NODE_DOC_IDX", "SRC_PRESENTATION_COMPONENT_IDX"
     };
  
  public final static Object[][] paramTypes =
    {
      {"SELECTION_TYPE", new Integer(Types.VARCHAR)},
       {"SRC_SITE_NODE_DOC_SHORTNAME", new Integer(Types.VARCHAR)},
       {"SELECTION_DATA", new Integer(Types.LONGVARCHAR)}
     };
        
  public final static boolean[] setRelevants =
    { false };
    
  public final static String sqlString =
  
    "UPDATE " +
    " DOCUMENT_REFERENCE " +
    "SET " +
    " REFERENCE_TYPE = ?, " +
    " DEST_SITE_NODE_ID = ?, " +
    " DEST_SITE_NODE_DOC_SHORTNAME = ?, " +
    " SELECTION_TYPE = ?, " +
    " SELECTION_DATA = ? " +
    "WHERE " +
    " SRC_SITE_NODE_ID = ? " +
    "AND " + 
    " SRC_SITE_NODE_DOC_IDX = ? " +
    "AND " + 
    " SRC_PRESENTATION_COMPONENT_IDX = ? ";
  
  public void initQuery(Connection con) {
    super.initQuery(
      con, 
      isPrepared, 
      paramOrder, 
      paramTypes,
      setRelevants,
      sqlString ); 
  }
}