1 5 package com.teamkonzept.webman.mainint.db.queries.sitetree; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 12 public class StInsert extends TKPrepQuery { 13 public final static boolean isPrepared = 14 true; 15 16 public final static String [] paramOrder = 17 { 18 NEXT_SITE_ID, 19 NODE_ID, SITE_NODE_TYPE, 21 SITE_NODE_NAME, 22 SITE_NODE_SHORTNAME, 23 RIGHT_NR, 24 RIGHT_NR, 25 PG_CONTENT_NODE, 26 SELECTION_ID }; 28 29 public final static Object [][] paramTypes = 30 { 31 { SITE_NODE_NAME, new Integer (Types.VARCHAR) }, 32 { SITE_NODE_SHORTNAME, new Integer (Types.VARCHAR) } 33 }; 34 public final static boolean[] setRelevants = 35 null; 36 37 public final static String sqlString = 38 39 " insert into SITE_TREE " + 40 " (SITE_NODE_ID, SITE_NODE_PARENT, SITE_NODE_TYPE, SITE_NODE_NAME, " + 41 " SITE_NODE_SHORTNAME, LEFT_NR, RIGHT_NR, PG_CONTENT_NODE, PG_SELECTION_ID) " + 42 " values (?,?,?,?,?,?,? + 1 ,?,?) "; 43 44 public void initQuery(Connection con) { 45 super.initQuery( 46 con, 47 isPrepared, 48 paramOrder, 49 paramTypes, 50 setRelevants, 51 sqlString ); 52 } 53 } 54 55 56 | Popular Tags |