KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > sybase > TKDBPropDelete


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sybase/Attic/TKDBPropDelete.java,v 1.2 2001/08/15 12:50:09 markus Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.sybase;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /*
12  * TKDBPropDelete
13  * input "PROP_NAME"
14  * output nada
15  * delete entry in PROPERTIES
16  */
17 public class TKDBPropDelete extends TKPrepQuery{
18     
19     public final static boolean isPrepared =
20     true;
21     
22     public final static String JavaDoc[] paramOrder =
23     { "PROP_ID", "PROP_ID" };
24     
25     public final static Object JavaDoc[][] paramTypes =
26     {{"PROP_ID", new Integer JavaDoc(Types.INTEGER)}};
27     
28     public final static boolean[] setRelevants =
29     { true };
30     
31     public final static String JavaDoc sqlString =
32     
33     "BEGIN TRANSACTION " +
34     
35     "delete " +
36     "PROPERTY_GROUP_MEMBER " +
37     "where "+
38     " PROPERTY_ID = ? " +
39
40     "delete " +
41     "PROPERTY " +
42     "where " +
43     " PROPERTY_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