1 package de.webman.content.db.queries; 2 3 import java.sql.Connection ; 4 import java.sql.Types ; 5 import com.teamkonzept.db.TKPrepQuery; 6 import de.webman.content.db.ContentConstants; 7 import de.webman.content.db.StructuredContentConstants; 8 import de.webman.form.db.FormConstants; 9 10 50 public class XMLStructuredContentDescribe 51 extends TKPrepQuery 52 { 53 55 57 60 private final static boolean IS_PREPARED = true; 61 62 65 private final static String [] PARAMETER_ORDER = 66 { 67 ContentConstants.CONTENT_ID 68 }; 69 70 73 private final static Object [][] PARAMETER_TYPES = 74 { 75 {ContentConstants.CONTENT_ID, new Integer (Types.INTEGER)} 76 }; 77 78 81 private final static boolean[] SET_RELEVANTS = 82 { 83 true 84 }; 85 86 89 private final static String SQL_STRING = (new StringBuffer ()).append("SELECT STRUCTURED_CONTENT.FORM_ID, FORM.FORM_NAME, FORM.FORM_DESCRIPTION ") 90 .append("FROM CONTENT, STRUCTURED_CONTENT, FORM ") 91 .append("WHERE CONTENT.CONTENT_ID = ? ") 92 .append("AND CONTENT.CONTENT_ID = STRUCTURED_CONTENT.CONTENT_ID ") 93 .append("AND STRUCTURED_CONTENT.FORM_ID = FORM.FORM_ID") 94 .toString(); 95 96 97 99 104 public void initQuery (Connection connection) 105 { 106 super.initQuery(connection, 107 IS_PREPARED, 108 PARAMETER_ORDER, 109 PARAMETER_TYPES, 110 SET_RELEVANTS, 111 SQL_STRING); 112 } 113 114 } 115 | Popular Tags |