1 5 package com.teamkonzept.webman.mainint.db.queries.sitetree; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 15 public class SdInsertNew extends TKPrepQuery{ 16 17 public final static boolean ISPREPARED = true; 18 19 public final static String [] PARAMORDER = 20 { 21 "SITE_NODE_ID", 22 "SITE_NODE_DOC_IDX", 23 "PRESENTATION_ID", 24 "DOCUMENT_NAME", 25 "DOCUMENT_SHORTNAME", 26 "INHERITABLE", 27 "DOCUMENT_TYPE", 28 "EXTERNAL_URL", 29 "INHERIT_END_LEVEL", 30 "INHERIT_BEGIN_LEVEL" 31 }; 32 33 public final static Object [][] PARAMTYPES = {{"EXTERNAL_URL", new Integer (Types.VARCHAR)}}; 34 public final static boolean[] SETRELEVANTS = null; 35 36 public final static String SQLSTRING = 37 " INSERT INTO SITE_DOCUMENT (SITE_NODE_ID, SITE_NODE_DOC_IDX, PRESENTATION_ID, DOCUMENT_NAME, DOCUMENT_SHORTNAME, INHERITABLE, DOCUMENT_TYPE, EXTERNAL_URL, INHERIT_END_LEVEL, INHERIT_BEGIN_LEVEL) VALUES ( ?, ? , ?, ?, ?, ?, ?, ?, ?, ?) "; 38 39 public void initQuery(Connection con) { 40 super.initQuery( 41 con, 42 ISPREPARED, 43 PARAMORDER, 44 PARAMTYPES, 45 SETRELEVANTS, 46 SQLSTRING ); 47 } 48 } 49 | Popular Tags |