1 5 8 package com.teamkonzept.webman.mainint.db.queries; 9 10 import java.sql.*; 11 12 import com.teamkonzept.db.*; 13 14 19 public class TKDBPresCompGet extends TKPrepQuery{ 20 21 public final static boolean isPrepared = 22 true; 23 24 public final static String [] paramOrder = 25 {"PRESENTATION_ID"}; 26 27 public final static Object [][] paramTypes = 28 null; 29 30 public final static boolean[] setRelevants = 31 { true }; 32 33 public final static String sqlString = 34 "SELECT " + 35 " PC.PRESENTATION_ID, PC.PRESENTATION_COMPONENT_IDX, " + 36 " PC.COMPONENT_TYPE, PC.INTEGRATION_TYPE, PC.INTEGRATION_NAME, " + 37 " PC.INTEGRATION_SHORTNAME, " + 38 " PT.FORM_ID " + 39 "FROM " + 40 " PRESENTATION_COMPONENT PC, " + 41 " PRESENTATION_CONTENT PT " + 42 "WHERE " + 43 " PC.PRESENTATION_ID = ? " + 44 "AND " + 45 " PC.PRESENTATION_ID = PT.PRESENTATION_ID " + 46 "AND " + 47 " PC.PRESENTATION_COMPONENT_IDX = PT.PRESENTATION_COMPONENT_IDX " + 48 "ORDER BY " + 49 " PC.PRESENTATION_COMPONENT_IDX "; 50 51 52 public void initQuery(Connection con) { 53 super.initQuery( 54 con, 55 isPrepared, 56 paramOrder, 57 paramTypes, 58 setRelevants, 59 sqlString ); 60 } 61 } 62 63 | Popular Tags |