KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > TKDBPropGroupRemoveMember


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPropGroupRemoveMember.java,v 1.2 2001/02/19 11:38:45 ralf Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /*
12  * TKDBPropUpdate
13  * input "PROP_NAME"
14  * input "PROP_VALUE"
15  * output neuer DS
16  * changes entry in PROPERTIES
17  */
18 public class TKDBPropGroupRemoveMember extends TKPrepQuery{
19     
20     public final static boolean isPrepared =
21     true;
22     
23     public final static String JavaDoc[] paramOrder =
24     { "PROP_ID", "PROP_GROUP_ID" };
25     
26     public final static Object JavaDoc[][] paramTypes =
27     { {"PROP_ID", new Integer JavaDoc(Types.INTEGER)},
28       {"PROP_GROUP_ID", new Integer JavaDoc(Types.INTEGER)}
29     };
30     
31     public final static boolean[] setRelevants =
32     { true };
33     
34     public final static String JavaDoc sqlString =
35     "DELETE " +
36     "PROPERTY_GROUP_MEMBER WHERE " +
37     " PROPERTY_ID = ? AND PROPERTY_GROUP_ID = ? ";
38     
39     public void initQuery(Connection con) {
40     super.initQuery(
41             con,
42             isPrepared,
43             paramOrder,
44             paramTypes,
45             setRelevants,
46             sqlString );
47     }
48 }
49
50
Popular Tags