01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/StInsert.java,v 1.2 2000/12/13 11:29:31 marwan 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: public class StInsert extends TKPrepQuery {
12: public final static boolean isPrepared = true;
13:
14: public final static String[] paramOrder = { NEXT_SITE_ID,
15: NODE_ID, // SITE_NODE_PARENT
16: SITE_NODE_TYPE, SITE_NODE_NAME, SITE_NODE_SHORTNAME,
17: RIGHT_NR, RIGHT_NR, PG_CONTENT_NODE, SELECTION_ID // PG_SELECTION_ID
18: };
19:
20: public final static Object[][] paramTypes = {
21: { SITE_NODE_NAME, new Integer(Types.VARCHAR) },
22: { SITE_NODE_SHORTNAME, new Integer(Types.VARCHAR) } };
23: public final static boolean[] setRelevants = null;
24:
25: public final static String sqlString =
26:
27: " insert into SITE_TREE "
28: + " (SITE_NODE_ID, SITE_NODE_PARENT, SITE_NODE_TYPE, SITE_NODE_NAME, "
29: + " SITE_NODE_SHORTNAME, LEFT_NR, RIGHT_NR, PG_CONTENT_NODE, PG_SELECTION_ID) "
30: + " values (?,?,?,?,?,?,? + 1 ,?,?) ";
31:
32: public void initQuery(Connection con) {
33: super.initQuery(con, isPrepared, paramOrder, paramTypes,
34: setRelevants, sqlString);
35: }
36: }
|