01: /*
02: * $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 $
03: *
04: */
05: package com.teamkonzept.webman.mainint.db.queries.sitetree;
06:
07: import java.sql.*;
08:
09: 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[] PARAMORDER = { NODE_ID };
19: public final static Object[][] PARAMTYPES = {
20: { SITE_NODE_NAME, new Integer(Types.VARCHAR) },
21: { SITE_NODE_SHORTNAME, new Integer(Types.VARCHAR) } };
22: public final static boolean[] SETRELEVANTS = { true };
23:
24: public final static String SQLSTRING =
25:
26: "SELECT LEFT_NR, RIGHT_NR FROM SITE_TREE WHERE SITE_NODE_ID = ?";
27:
28: public void initQuery(Connection con) {
29: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
30: SETRELEVANTS, SQLSTRING);
31: }
32: }
|