|
1 package com.teamkonzept.webman.mainint.db.queries.content;
2
3 import java.sql.Connection  ;
4 import com.teamkonzept.db.*;
5
6 public class InsertTempTableSiteNodeId extends TKPrepQuery
7 {
8
9 public static boolean prepared = true;
10 public static String [] order = {};
11 public static Object [][] types = null;
12 public static boolean[] relevants = { true };
13 public static String sqlString = "INSERT INTO WEBMAN_TEMP2 (SITE_NODE_ID, CONTENT_NODE_ID, CONTENT_NODE_SHORTNAME, CONTENT_NODE_TYPE, DC_SITE_NODE_ID, DC_SITE_NODE_DOC_IDX) " +
14 "SELECT ST.SITE_NODE_ID, CT.CONTENT_NODE_ID, CT.CONTENT_NODE_SHORTNAME, CT.CONTENT_NODE_TYPE, DC.SITE_NODE_ID, DC.SITE_NODE_DOC_IDX " +
15 "FROM SITE_TREE ST, DOCUMENT_CONTENT DC, CONTENT_TREE CT, WEBMAN_TEMP T " +
16 "WHERE " + DBStringFactory.leftOuterJoin("T.CONTENT_NODE_ID","ST.PG_CONTENT_NODE") +
17 " AND " + DBStringFactory.leftOuterJoin("T.CONTENT_NODE_ID","DC.CONTENT_NODE_ID") +
18 " AND " + DBStringFactory.leftOuterJoin("T.CONTENT_NODE_ID","CT.CONTENT_NODE_ID");
19
20 public void initQuery(Connection con) {
21 super.initQuery(
22 con,
23 prepared,
24 order,
25 types,
26 relevants,
27 sqlString );
28 }
29
30 }
31 |
Popular Tags |
Java API By Example, From Geeks To Geeks.