KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/StShiftLeftNrs.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 StShiftLeftNrs extends TKPrepQuery{
13
14     public final static boolean isPrepared =
15         true;
16     
17     public final static String JavaDoc[] paramOrder =
18         {NODE_ID};
19     public final static Object JavaDoc[][] paramTypes =
20         null;
21         
22     public final static boolean[] setRelevants =
23         null;
24         
25     public final static String JavaDoc sqlString =
26         
27         
28         
29        " update SITE_TREE "
30      + " set LEFT_NR = LEFT_NR + 2 "
31      + " where LEFT_NR > "
32      + " ( "
33      + " select RIGHT_NR "
34      + " from SITE_TREE "
35      + " where SITE_NODE_ID = ? "
36      + " ) " ;
37
38     public void initQuery(Connection con) {
39         super.initQuery(
40             con,
41             isPrepared,
42             paramOrder,
43             paramTypes,
44             setRelevants,
45             sqlString );
46     }
47 }
48
49
50
Popular Tags