01: package de.webman.content.db.queries;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: /**
07: * Query zum Feststellen, ob Shortnames schon vergeben sind
08: * @author $Author: alex $
09: * @version $Revision: 1.2 $
10: */
11: public class SelectShortnamesFromContentTree extends TKPrepQuery {
12:
13: public final static boolean PREPARED = true;
14:
15: public final static String[] ORDER = { "CONTENT_NODE_ID",
16: "CONTENT_NODE_SHORTNAME" };
17:
18: public final static Object[][] TYPES = null;
19:
20: public final static boolean[] RELEVANTS = { true };
21:
22: public final static String SQL_STRING = "SELECT CONTENT_NODE_SHORTNAME, CONTENT_NODE_ID FROM CONTENT_TREE "
23: + " WHERE CONTENT_NODE_PARENT = ? AND CONTENT_NODE_SHORTNAME = ? ";
24:
25: public void initQuery(Connection con) {
26: super.initQuery(con, PREPARED, ORDER, TYPES, RELEVANTS,
27: SQL_STRING);
28: }
29:
30: }
|