|
1
4 package com.teamkonzept.webman.mainint.db.queries.sybase;
5
6 import com.teamkonzept.db.*;
7 import java.sql.*;
8
9 public class TKDBContentNewVersion extends TKPrepQuery {
10
11 public final static boolean isPrepared =
12 true;
13
14 public final static String  [] paramOrder = {
15 "INSTANCE_ID", "STATUS_ID", "VERS_INFO", "VERS_AUTHOR" };
16
17 public final static Object [][] paramTypes =
18 { {"VERS_INFO", new Integer (Types.VARCHAR)},
19 {"VERS_AUTHOR", new Integer (Types.VARCHAR)},
20 };
21
22 public final static boolean[] setRelevants = { false };
23
24 public final static String sqlString =
25 "DECLARE @VERS_ID INT " +
26 "DECLARE @CONT_ID INT " +
27 "DECLARE @INST_ID INT " +
28
29 "BEGIN TRANSACTION " +
30
31 "SELECT @INST_ID = ? " +
32
33 "SELECT @VERS_ID=ISNULL(MAX(VERSION_ID)+1, 1) " +
34 "FROM CONTENT_VERSION " +
35
36 "SELECT @CONT_ID= " +
37 " ( " +
38 " SELECT MAX (CONTENT_ID) " +
39 " FROM CONTENT_VERSION "+
40 " WHERE INSTANCE_ID = @INST_ID " +
41 " ) " +
42
43 "INSERT INTO CONTENT_VERSION (VERSION_ID, INSTANCE_ID, CONTENT_ID, STATUS_ID, VERSION_DATE, INFO, AUTHOR) " +
44 " VALUES (@VERS_ID, @INST_ID, @CONT_ID, ?, {fn NOW()}, ?, ?) " +
45
46 "COMMIT TRANSACTION " +
47
48 "SELECT CV.*, CI.NAME FROM CONTENT_VERSION CV, CONTENT_INSTANCE CI " +
49 "WHERE CV.VERSION_ID = @VERS_ID AND CI.INSTANCE_ID = @INST_ID ";
50
51 public void initQuery(Connection con) {
52 super.initQuery(
53 con,
54 isPrepared,
55 paramOrder,
56 paramTypes,
57 setRelevants,
58 sqlString );
59 }
60 }
61 |
Popular Tags |
Java API By Example, From Geeks To Geeks.