1 package com.teamkonzept.webman.mainint.db.queries.sitetree; 2 3 import java.sql.*; 4 5 import com.teamkonzept.db.*; 6 7 8 15 16 17 public class SdUpdate extends TKPrepQuery { 18 19 public final static boolean ISPREPARED = 20 true; 21 22 public final static String [] PARAMORDER = 23 { 24 PRESENTATION_ID, 25 DOCUMENT_NAME, 26 DOCUMENT_SHORTNAME, 27 INHERITABLE, 28 DOCUMENT_TYPE, 29 EXTERNAL_URL, 30 INHERIT_END_LEVEL, 31 INHERIT_BEGIN_LEVEL, 32 SITE_NODE_ID, 33 SITE_NODE_DOC_IDX 34 }; 35 36 public final static Object [][] PARAMTYPES = 37 {{"EXTERNAL_URL", new Integer (Types.VARCHAR)}}; 38 39 public final static boolean[] SETRELEVANTS = 40 null; 41 42 public final static String SQLSTRING = 43 44 "UPDATE " + 45 " SITE_DOCUMENT " + 46 "SET " + 47 " PRESENTATION_ID = ?," + 48 " DOCUMENT_NAME = ?," + 49 " DOCUMENT_SHORTNAME = ?," + 50 " INHERITABLE = ?, " + 51 " DOCUMENT_TYPE = ?, " + 52 " EXTERNAL_URL = ?, " + 53 " INHERIT_END_LEVEL = ?, " + 54 " INHERIT_BEGIN_LEVEL = ? " + 55 "WHERE " + 56 " SITE_NODE_ID = ? " + 57 "AND " + 58 " SITE_NODE_DOC_IDX = ? "; 59 public void initQuery(Connection con) { 60 super.initQuery( 61 con, 62 ISPREPARED, 63 PARAMORDER, 64 PARAMTYPES, 65 SETRELEVANTS, 66 SQLSTRING ); 67 } 68 69 } 70 71 72 73 | Popular Tags |