KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > content > db > queries > SelectShortnamesFromContentTree


1 package de.webman.content.db.queries;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5 /**
6  * Query zum Feststellen, ob Shortnames schon vergeben sind
7  * @author $Author: alex $
8  * @version $Revision: 1.2 $
9 */

10 public class SelectShortnamesFromContentTree extends TKPrepQuery
11 {
12
13     public final static boolean PREPARED = true;
14
15     public final static String JavaDoc[] ORDER = { "CONTENT_NODE_ID", "CONTENT_NODE_SHORTNAME" };
16
17     public final static Object JavaDoc[][] TYPES = null;
18
19     public final static boolean[] RELEVANTS = { true };
20
21     public final static String JavaDoc SQL_STRING = "SELECT CONTENT_NODE_SHORTNAME, CONTENT_NODE_ID FROM CONTENT_TREE "
22     + " WHERE CONTENT_NODE_PARENT = ? AND CONTENT_NODE_SHORTNAME = ? ";
23
24     public void initQuery(Connection JavaDoc con) {
25         super.initQuery(
26             con,
27             PREPARED,
28             ORDER,
29             TYPES,
30             RELEVANTS,
31             SQL_STRING );
32     }
33
34 }
Popular Tags