GenSiteDocs.java :  » Content-Management-System » webman » de » webman » generator » db » queries » Java Open Source

package de.webman.generator.db.queries; 

import com.teamkonzept.db.*;
import java.sql.*;

/*
 * DBGenSiteDocs
 * Holt alle Dokumente aller Knoten aus dem SITE_TREE
 *
 * Input: Keiner
 * Output: alle Dokumente aller Knoten aus aus Sitetree
 * @author  $Author: alex $
 * @version $Revision: 1.1 $
 */
public class GenSiteDocs extends TKPrepQuery {

  public static boolean isPrepared =
    true;
  
  public static String[] paramOrder =
    null;
  
  public static Object[][] paramTypes =
    null;
    
  public static boolean[] setRelevants =
    { true };
    
  public static String sqlString =
    "SELECT " +
    " SD.*, " +
    " T.TEMPLATE_NAME, " +
    " ST.LEFT_NR " +
    "FROM " +
    " SITE_TREE ST, SITE_DOCUMENT SD, PRESENTATION P, TEMPLATE T " +
    "WHERE " +
    " ST.SITE_NODE_ID = SD.SITE_NODE_ID " +
    "AND " +
    " SD.PRESENTATION_ID = P.PRESENTATION_ID " +
    "AND " +
    " P.TEMPLATE_ID = T.TEMPLATE_ID " +
    "ORDER BY " +
    " ST.LEFT_NR, SD.SITE_NODE_DOC_IDX";

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