|
1 package com.teamkonzept.webman.mainint.db.queries.content;
2
3 import java.sql.Connection  ;
4 import com.teamkonzept.db.*;
5
6 public class UpdateTempTableContentNodeIdNodeId extends TKPrepQuery
7 {
8
9 public final static boolean PREPARED = true;
10
11 public final static String [] ORDER = null;
12
13 public final static Object [][] TYPES = null;
14
15 public final static boolean[] RELEVANTS = { true };
16
17 public final static String SQLSTRING = (new StringBuffer ("UPDATE WEBMAN_TEMP_2 SET NODE_ID = ")
18 .append(" (SELECT CT.CONTENT_NODE_PARENT FROM CONTENT_TREE CT, WEBMAN_TEMP T ")
19 .append(" WHERE CT.CONTENT_NODE_ID = WEBMAN_TEMP_2.CONTENT_NODE_ID ")
20 .append(" AND CT.CONTENT_NODE_ID = T.CONTENT_NODE_ID)")
21 .append(" WHERE CONTENT_NODE_ID IN (SELECT CONTENT_NODE_ID FROM WEBMAN_TEMP)")).toString();
22
23 public void initQuery(Connection con) {
24 super.initQuery(
25 con,
26 PREPARED,
27 ORDER,
28 TYPES,
29 RELEVANTS,
30 SQLSTRING );
31 }
32
33 }
34 |
Popular Tags |
Java API By Example, From Geeks To Geeks.