1 5 package com.teamkonzept.webman.mainint.db.queries.sybase; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 17 public class TKDBPropGroupDelete extends TKPrepQuery{ 18 19 public final static boolean isPrepared = 20 true; 21 22 public final static String [] paramOrder = 23 { "PROPGROUP_ID", "PROPGROUP_ID" }; 24 25 public final static Object [][] paramTypes = 26 {{"PROPGROUP_ID", new Integer (Types.INTEGER)}}; 27 28 public final static boolean[] setRelevants = 29 { true }; 30 31 public final static String sqlString = 32 33 "BEGIN TRANSACTION " + 34 35 "delete " + 36 "PROPERTY_GROUP_MEMBER " + 37 "where "+ 38 " PROPERTY_GROUP_ID = ? " + 39 40 "delete " + 41 "PROPERTY_GROUP " + 42 "where " + 43 " PROPERTY_GROUP_ID = ? " + 44 45 "COMMIT TRANSACTION " ; 46 47 public void initQuery(Connection con) { 48 super.initQuery( 49 con, 50 isPrepared, 51 paramOrder, 52 paramTypes, 53 setRelevants, 54 sqlString ); 55 } 56 } 57 58 | Popular Tags |