1 5 package com.teamkonzept.webman.mainint.db.queries.oracle; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 import com.teamkonzept.webman.mainint.db.queries.properties.*; 11 import com.teamkonzept.webman.mainint.WebmanExceptionHandler; 12 13 19 public class TKDBPropGroupNew extends TKExtendedPrepQuery 20 { 21 22 public final static boolean isPrepared = true; 23 24 public final static String [] paramOrder = { "PROPGROUP_NAME" }; 25 26 public final static Object [][] paramTypes = 27 { {"PROPGROUP_NAME", new Integer (Types.VARCHAR)} }; 28 29 public final static boolean[] setRelevants = { true }; 30 31 48 49 protected static Class [] queryClasses = { 50 SelectMaxPropertyGroup.class, InsertPropertyGroup.class }; 53 54 public boolean execute() 55 { 56 try 57 { 58 59 init(queryClasses); 61 boolean isNotOpen = aTKDBConnection.isAutoCommit(); 63 if (isNotOpen) 64 { 65 TKDBManager.beginTransaction(); } 67 68 Object propGroupId = null; 69 queries[0].execute(); 74 ResultSet rs = queries[0].fetchResultSet(); 75 if (rs != null && rs.next()) 76 { 77 propGroupId = rs.getObject(1); 78 } 79 80 81 queries[1].setQueryParams("PROPGROUP_ID", propGroupId); 87 queries[1].setQueryParams("PROPGROUP_NAME", 88 queryParams.get("PROPGROUP_NAME")); 89 queries[1].execute(); 90 91 if (isNotOpen) 93 { 94 aTKDBConnection.commitTransaction(); } 96 97 } 98 catch(Throwable t) 99 { 100 TKDBManager.safeRollbackTransaction(t); 101 } 102 return hasResults(); 103 } 104 105 106 public void initQuery(Connection con) 107 { 108 super.initQuery(con, 109 isPrepared, 110 paramOrder, paramTypes, setRelevants, sqlString); 111 } 112 } 113 | Popular Tags |