KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries.content;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 /**
7  *
8  * @author
9  * @version
10  */
11 public class CreateTempTableSiteNodeId extends TKPrepQuery
12 {
13
14     public final static boolean PREPARED = true;
15     public final static String JavaDoc[] ORDER = null;
16     public final static Object JavaDoc[][] TYPES = null;
17     public final static boolean[] RELEVANTS = { true };
18
19     public final static String JavaDoc SQLSTRING = (new StringBuffer JavaDoc("CREATE " + DBStringFactory.declareAsTemp() + " TABLE WEBMAN_TEMP2 ")
20                                       .append(" ( SITE_NODE_ID int null, ")
21                                       .append(" CONTENT_NODE_ID int null, ")
22                                       .append(" CONTENT_NODE_SHORTNAME VARCHAR(80) null, ")
23                                       .append(" CONTENT_NODE_TYPE int null, ")
24                                       .append(" DC_SITE_NODE_ID int null, ")
25                                       .append(" DC_SITE_NODE_DOC_IDX int null) ")
26                                       .append(DBStringFactory.declareForTransaction())).toString();
27
28     public void initQuery(Connection JavaDoc con) {
29         super.initQuery(
30             con,
31             PREPARED,
32             ORDER,
33             TYPES,
34             RELEVANTS,
35             SQLSTRING );
36     }
37
38 }
39
Popular Tags