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

package com.teamkonzept.webman.mainint.db.queries;

import java.sql.*;

import com.teamkonzept.db.*;

/*
 * TKDBPresCompGet
 * input PRESENTATION_ID
 * output Alle freien Referenzen
 */
public class TKDBPresCompGetFreeRef 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 " +
    "FROM " +
    " PRESENTATION_COMPONENT PC " +
    "WHERE " +
    " PC.PRESENTATION_ID = ? " +
    " AND PC.COMPONENT_TYPE = 1";

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