TKDBPresCompGet.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/TKDBPresCompGet.java,v 1.6 2000/10/24 20:22:24 alex Exp $
 *
 */
/**
 * Jedes Selectstatement erhaelt eine eigene Klasse
 */
package com.teamkonzept.webman.mainint.db.queries;

import java.sql.*;

import com.teamkonzept.db.*;

/*
 * TKDBPresCompGet
 * input PRESENTATION_ID
 * output (Alle DS aus PRESENTATION_COMPONENT, _CONTENT)  
 */
public class TKDBPresCompGet extends TKPrepQuery{

  public final static boolean isPrepared =
    true;
  
  public final static String[] paramOrder =
    {"PRESENTATION_ID"};
  
  public final static Object[][] paramTypes =
    null;
    
  public final static boolean[] setRelevants =
    { true };
    
  public final static String sqlString =
    "SELECT " +
    " PC.PRESENTATION_ID, PC.PRESENTATION_COMPONENT_IDX, " +
    " PC.COMPONENT_TYPE, PC.INTEGRATION_TYPE, PC.INTEGRATION_NAME, " +
    " PC.INTEGRATION_SHORTNAME, " +
    " PT.FORM_ID " +
    "FROM " +
    " PRESENTATION_COMPONENT PC, " +
    " PRESENTATION_CONTENT PT " +
    "WHERE " +
    " PC.PRESENTATION_ID = ? " +
    "AND " +
    " PC.PRESENTATION_ID = PT.PRESENTATION_ID " +
    "AND " +
    " PC.PRESENTATION_COMPONENT_IDX = PT.PRESENTATION_COMPONENT_IDX " +
    "ORDER BY " +
    " PC.PRESENTATION_COMPONENT_IDX ";

  
  public void initQuery(Connection con) {
    super.initQuery(
      con, 
      isPrepared, 
      paramOrder, 
      paramTypes,
      setRelevants,
      sqlString );
  }
}