KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > content > db > queries > sybase > TKDBContentAttributeDelete


1 /**
2  * Jedes Selectstatement erhaelt eine eigene Klasse
3  */
4 package de.webman.content.db.queries.sybase;
5
6 import com.teamkonzept.db.*;
7 import java.sql.*;
8
9 public class TKDBContentAttributeDelete extends TKPrepQuery {
10
11     public final static boolean ISPREPARED =
12         true;
13     
14     public final static String JavaDoc[] PARAMORDER =
15         { "VALUE_ID" };
16     
17     public final static Object JavaDoc[][] PARAMTYPES = null;
18         
19         
20         
21     public final static boolean[] SETRELEVANTS =
22         { false };
23         
24     public final static String JavaDoc SQLSTRING =
25         "DECLARE @VAL_ID INT " +
26         
27         "BEGIN TRANSACTION " +
28         
29         "SELECT @VAL_ID = ? " +
30         
31         "DELETE FROM CONTENT_ATTRIBUTE_VALUE WHERE VALUE_ID = @VAL_ID " +
32         "DELETE FROM CONTENT_ATTRIBUTE WHERE VALUE_ID = @VAL_ID " +
33         "COMMIT TRANSACTION ";
34                 
35     public void initQuery(Connection con) {
36         super.initQuery(
37             con,
38             ISPREPARED,
39             PARAMORDER,
40             PARAMTYPES,
41             SETRELEVANTS,
42             SQLSTRING );
43     }
44 }
Popular Tags