KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > content > UpdateContentTreeLeftNr


1 package com.teamkonzept.webman.mainint.db.queries.content;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 public class UpdateContentTreeLeftNr extends TKPrepQuery
7 {
8
9     public final static boolean prepared = true;
10
11     public final static String JavaDoc[] order =
12   {
13     "DIFF", "LEFT_NR"
14   };
15
16     public final static Object JavaDoc[][] types = null;
17
18     public final static boolean[] relevants = { true };
19
20     public final static String JavaDoc sqlString = "UPDATE CONTENT_TREE SET LEFT_NR = LEFT_NR - ? WHERE LEFT_NR >= ?";
21
22     public void initQuery(Connection JavaDoc con) {
23         super.initQuery(
24             con,
25             prepared,
26             order,
27             types,
28             relevants,
29             sqlString );
30     }
31
32 }
Popular Tags