01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/StUpdate.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 StUpdate extends TKPrepQuery {
12: public final static boolean isPrepared = true;
13:
14: public final static String[] paramOrder = { SITE_NODE_TYPE,
15: SITE_NODE_NAME, SITE_NODE_SHORTNAME, PG_CONTENT_NODE,
16: PG_SELECTION_ID, SITE_NODE_ID };
17:
18: public final static Object[][] paramTypes = {
19: { SITE_NODE_NAME, new Integer(Types.VARCHAR) },
20: { SITE_NODE_SHORTNAME, new Integer(Types.VARCHAR) } };
21: public final static boolean[] setRelevants = null;
22:
23: public final static String sqlString =
24:
25: " update SITE_TREE "
26: + " set SITE_NODE_TYPE = ?, SITE_NODE_NAME = ? , SITE_NODE_SHORTNAME = ?, "
27: + " PG_CONTENT_NODE = ?, PG_SELECTION_ID = ? "
28: + " where SITE_NODE_ID = ? ";
29:
30: public void initQuery(Connection con) {
31: super.initQuery(con, isPrepared, paramOrder, paramTypes,
32: setRelevants, sqlString);
33: }
34: }
|