KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $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 $
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 public class StInsert extends TKPrepQuery {
13     public final static boolean isPrepared =
14         true;
15     
16     public final static String JavaDoc[] paramOrder =
17         {
18             NEXT_SITE_ID,
19             NODE_ID, // SITE_NODE_PARENT
20
SITE_NODE_TYPE,
21             SITE_NODE_NAME,
22             SITE_NODE_SHORTNAME,
23             RIGHT_NR,
24             RIGHT_NR,
25             PG_CONTENT_NODE,
26             SELECTION_ID // PG_SELECTION_ID
27
};
28     
29     public final static Object JavaDoc[][] paramTypes =
30     {
31         { SITE_NODE_NAME, new Integer JavaDoc(Types.VARCHAR) },
32         { SITE_NODE_SHORTNAME, new Integer JavaDoc(Types.VARCHAR) }
33     };
34     public final static boolean[] setRelevants =
35         null;
36         
37     public final static String JavaDoc sqlString =
38         
39             " insert into SITE_TREE " +
40             " (SITE_NODE_ID, SITE_NODE_PARENT, SITE_NODE_TYPE, SITE_NODE_NAME, " +
41             " SITE_NODE_SHORTNAME, LEFT_NR, RIGHT_NR, PG_CONTENT_NODE, PG_SELECTION_ID) " +
42             " values (?,?,?,?,?,?,? + 1 ,?,?) ";
43     
44     public void initQuery(Connection con) {
45         super.initQuery(
46             con,
47             isPrepared,
48             paramOrder,
49             paramTypes,
50             setRelevants,
51             sqlString );
52     }
53 }
54
55
56
Popular Tags