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 55 public class XMLStructuredContentRetrieve 56 extends TKPrepQuery 57 { 58 60 62 65 private final static boolean IS_PREPARED = true; 66 67 70 private final static String [] PARAMETER_ORDER = 71 { 72 ContentConstants.CONTENT_ID 73 }; 74 75 78 private final static Object [][] PARAMETER_TYPES = 79 { 80 {ContentConstants.CONTENT_ID, new Integer (Types.INTEGER)} 81 }; 82 83 86 private final static boolean[] SET_RELEVANTS = 87 { 88 true 89 }; 90 91 94 private final static String SQL_STRING = (new StringBuffer ()).append("SELECT CONTENT.XML_TEXT, STRUCTURED_CONTENT.FORM_ID, FORM.FORM_NAME, FORM.FORM_DESCRIPTION ") 95 .append("FROM CONTENT, STRUCTURED_CONTENT, FORM ") 96 .append("WHERE CONTENT.CONTENT_ID = ? ") 97 .append("AND CONTENT.CONTENT_ID = STRUCTURED_CONTENT.CONTENT_ID ") 98 .append("AND STRUCTURED_CONTENT.FORM_ID = FORM.FORM_ID") 99 .toString(); 100 101 102 104 109 public void initQuery (Connection connection) 110 { 111 super.initQuery(connection, 112 IS_PREPARED, 113 PARAMETER_ORDER, 114 PARAMETER_TYPES, 115 SET_RELEVANTS, 116 SQL_STRING); 117 } 118 119 } 120 | Popular Tags |