1 5 package com.teamkonzept.webman.mainint.db.queries; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 17 public class TKDBSiteDocUpdate extends TKPrepQuery{ 18 19 public final static boolean isPrepared = 20 true; 21 22 public final static String [] paramOrder = 23 {"DOCUMENT_NAME", "DOCUMENT_SHORTNAME", 24 "INHERITABLE", "DOCUMENT_TYPE", "EXTERNAL_URL", "INHERIT_END_LEVEL", "INHERIT_BEGIN_LEVEL", 25 "SITE_NODE_ID", "SITE_NODE_DOC_IDX", }; 26 27 public final static Object [][] paramTypes = 28 {{"EXTERNAL_URL", new Integer (Types.VARCHAR)}}; 29 30 public final static boolean[] setRelevants = 31 { false }; 32 33 public final static String sqlString = 34 "UPDATE " + 35 " SITE_DOCUMENT " + 36 "SET " + 37 " DOCUMENT_NAME = ?," + 38 " DOCUMENT_SHORTNAME = ?," + 39 " INHERITABLE = ?, " + 40 " DOCUMENT_TYPE = ?, " + 41 " EXTERNAL_URL = ?, " + 42 " INHERIT_END_LEVEL = ?, " + 43 " INHERIT_BEGIN_LEVEL = ? " + 44 "WHERE " + 45 " SITE_NODE_ID = ? " + 46 "AND " + 47 " SITE_NODE_DOC_IDX = ? "; 48 49 public void initQuery(Connection con) { 50 super.initQuery( 51 con, 52 isPrepared, 53 paramOrder, 54 paramTypes, 55 setRelevants, 56 sqlString ); 57 } 58 } 59 60 | Popular Tags |