KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > sitetree > StGetLeftRight


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/StGetLeftRight.java,v 1.3 2001/10/19 13:58:42 markus Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.sitetree;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /**
12  * @author
13  * @version
14  */
15 public class StGetLeftRight extends TKPrepQuery {
16
17     public final static boolean ISPREPARED = true;
18     public final static String JavaDoc[] PARAMORDER = { NODE_ID };
19     public final static Object JavaDoc[][] PARAMTYPES =
20     {
21         { SITE_NODE_NAME, new Integer JavaDoc(Types.VARCHAR) },
22         { SITE_NODE_SHORTNAME, new Integer JavaDoc(Types.VARCHAR) }
23     };
24     public final static boolean[] SETRELEVANTS = { true };
25
26     public final static String JavaDoc SQLSTRING =
27
28             "SELECT LEFT_NR, RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?";
29
30     public void initQuery(Connection con) {
31         super.initQuery(
32             con,
33             ISPREPARED,
34             PARAMORDER,
35             PARAMTYPES,
36             SETRELEVANTS,
37             SQLSTRING );
38     }
39 }
40
41
42
Popular Tags