1 package com.teamkonzept.webman.mainint.db.queries.duplication.oracle; 2 3 import com.teamkonzept.db.*; 4 6 import java.io.*; 7 import java.util.*; 8 import java.sql.*; 9 10 11 12 17 public class TKDBContentNodeNameExtend extends TKPrepQuery{ 18 19 public final static boolean isPrepared = 20 true; 21 22 public final static String [] paramOrder = 23 { "NAME_EXT", "POS" , "CONTENT_NODE_ID" }; 24 25 public final static Object [][] paramTypes = 26 {{ "NAME_EXT ", new Integer (Types.VARCHAR) }}; 27 28 public final static boolean[] setRelevants = 29 null; 30 31 public final static String sqlString = 32 33 " DECLARE " 34 + " name_ext VARCHAR2(255); " 35 + " con_node_id INTEGER; " 36 + " pos INTEGER; " 37 + " BEGIN " 38 + " name_ext := ? ; " 39 + " pos := ?; " 40 + " con_node_id := ?; " 41 42 + " IF (pos = 0) THEN " 43 + " UPDATE CONTENT_TREE " 44 + " set CONTENT_NODE_NAME = name_ext || CONTENT_NODE_NAME " 45 + " WHERE CONTENT_NODE_ID = con_node_id; " 46 47 + " UPDATE CONTENT_TREE " 48 + " set CONTENT_NODE_SHORTNAME = name_ext || CONTENT_NODE_SHORTNAME " 49 + " WHERE CONTENT_NODE_ID = con_node_id; " 50 + " ELSE " 51 + " UPDATE CONTENT_TREE " 52 + " set CONTENT_NODE_NAME = CONTENT_NODE_NAME || name_ext " 53 + " WHERE CONTENT_NODE_ID = con_node_id; " 54 55 56 + " UPDATE CONTENT_TREE " 57 + " set CONTENT_NODE_SHORTNAME = CONTENT_NODE_SHORTNAME || name_ext " 58 + " WHERE CONTENT_NODE_ID = con_node_id; " 59 + " END IF ; " 60 + " END; " 61 62 ; 63 64 65 public void initQuery(Connection con) { 66 super.initQuery( 67 con, 68 isPrepared, 69 paramOrder, 70 paramTypes, 71 setRelevants, 72 sqlString ); 73 } 74 } 75 76 | Popular Tags |