01: /**
02: * Jedes Selectstatement erhaelt eine eigene Klasse
03: */package de.webman.content.db.queries.sybase;
04:
05: import com.teamkonzept.db.*;
06: import java.sql.*;
07:
08: public class TKDBContentAttributeDelete extends TKPrepQuery {
09:
10: public final static boolean ISPREPARED = true;
11:
12: public final static String[] PARAMORDER = { "VALUE_ID" };
13:
14: public final static Object[][] PARAMTYPES = null;
15:
16: public final static boolean[] SETRELEVANTS = { false };
17:
18: public final static String SQLSTRING = "DECLARE @VAL_ID INT " +
19:
20: "BEGIN TRANSACTION " +
21:
22: "SELECT @VAL_ID = ? " +
23:
24: "DELETE FROM CONTENT_ATTRIBUTE_VALUE WHERE VALUE_ID = @VAL_ID "
25: + "DELETE FROM CONTENT_ATTRIBUTE WHERE VALUE_ID = @VAL_ID "
26: + "COMMIT TRANSACTION ";
27:
28: public void initQuery(Connection con) {
29: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
30: SETRELEVANTS, SQLSTRING);
31: }
32: }
|