KickJava   Java API By Example, From Geeks To Geeks.

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


1 /**
2  * Jedes Selectstatement erhaelt eine eigene Klasse
3  */
4 package com.teamkonzept.webman.mainint.db.queries.sybase;
5
6 import com.teamkonzept.db.*;
7 import java.sql.*;
8
9 /**
10  * @author marwan
11  * @version
12  */
13 public class TKDBContentNewVersionByVersionId extends TKPrepQuery {
14
15     /**
16      *
17      */
18     public final static boolean ISPREPARED =
19         true;
20     /**
21      *
22      */
23     public final static String JavaDoc[] PARAMORDER = {
24         "INSTANCE_ID", "VERSION_ID", "STATUS_ID", "VERS_INFO", "VERS_AUTHOR" };
25     /**
26      *
27      */
28     public final static Object JavaDoc[][] PARAMTYPES =
29         { {"VERS_INFO", new Integer JavaDoc(Types.VARCHAR)},
30           {"VERS_AUTHOR", new Integer JavaDoc(Types.VARCHAR)}
31         };
32     /**
33      *
34      */
35     public final static boolean[] SETRELEVANTS = { false };
36     /**
37      *
38      */
39     public final static String JavaDoc SQLSTRING =
40         "DECLARE @VERS_ID INT " +
41         "DECLARE @NEW_VERS_ID INT " +
42         "DECLARE @INST_ID INT " +
43         "DECLARE @CONT_ID INT " +
44         "DECLARE @STAT_ID INT " +
45         "DECLARE @VERS_INFO VARCHAR " +
46         "DECLARE @VERS_AUTHOR VARCHAR " +
47
48         "BEGIN TRANSACTION " +
49
50         "SELECT @INST_ID = ? " +
51         "SELECT @VERS_ID = ? " +
52         "SELECT @STAT_ID = ? " +
53         "SELECT @VERS_INFO = ? " +
54         "SELECT @VERS_AUTHOR = ? " +
55
56         "SELECT @CONT_ID= (SELECT CONTENT_ID FROM CONTENT_VERSION WHERE VERSION_ID = @VERS_ID) " +
57
58         "SELECT @NEW_VERS_ID=ISNULL(MAX(VERSION_ID)+1, 1) " +
59         " FROM CONTENT_VERSION " +
60
61         "INSERT INTO CONTENT_VERSION (VERSION_ID, INSTANCE_ID, CONTENT_ID, STATUS_ID, VERSION_DATE, INFO, AUTHOR) " +
62         " VALUES (@NEW_VERS_ID, @INST_ID, @CONT_ID, @STAT_ID, {fn NOW()}, @VERS_INFO, @VERS_AUTHOR) " +
63
64         "COMMIT TRANSACTION ";
65
66     /**
67      * @param con a database connection
68      */
69     public void initQuery(Connection con) {
70         super.initQuery(
71             con,
72             ISPREPARED,
73             PARAMORDER,
74             PARAMTYPES,
75             SETRELEVANTS,
76             SQLSTRING );
77     }
78 }
79
Popular Tags