|
1 package com.teamkonzept.webman.mainint.db.queries.sybase;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7
16 public class TKDBPresCompInsert extends TKPrepQuery{
17
18 public final static boolean isPrepared =
19 true;
20
21 public final static String  [] paramOrder =
22 {"PRESENTATION_ID", "COMPONENT_TYPE", "INTEGRATION_TYPE",
23 "INTEGRATION_NAME", "INTEGRATION_SHORTNAME" };
24
25 public final static Object [][] paramTypes =
26 {{"INTEGRATION_NAME", new Integer (Types.VARCHAR)},
27 {"INTEGRATION_SHORTNAME", new Integer (Types.VARCHAR)}};
28
29 public final static boolean[] setRelevants =
30 { true };
31
32 public final static String sqlString =
33 "DECLARE @PIDX int " +
34 "DECLARE @PID int " +
35
36 "SELECT @PID = ? " +
37
38 "BEGIN TRANSACTION " +
39
40 "SELECT " +
41 " @PIDX=ISNULL(MAX(PRESENTATION_COMPONENT_IDX)+1, 0) " +
42 "FROM " +
43 " PRESENTATION_COMPONENT " +
44 "WHERE " +
45 " PRESENTATION_ID = @PID " +
46
47 "INSERT INTO " +
48 " PRESENTATION_COMPONENT " +
49 " (PRESENTATION_ID, PRESENTATION_COMPONENT_IDX, " +
50 " COMPONENT_TYPE, INTEGRATION_TYPE, " +
51 " INTEGRATION_NAME, INTEGRATION_SHORTNAME) " +
52 "VALUES " +
53 " (@PID, @PIDX, ?, ?, ?, ?) " +
54
55 "SELECT " +
56 " * " +
57 "FROM " +
58 " PRESENTATION_COMPONENT " +
59 "WHERE " +
60 " PRESENTATION_ID = @PID " +
61 "AND " +
62 " PRESENTATION_COMPONENT_IDX = @PIDX " +
63
64 "COMMIT ";
65
66 public void initQuery(Connection con) {
67 super.initQuery(
68 con,
69 isPrepared,
70 paramOrder,
71 paramTypes,
72 setRelevants,
73 sqlString );
74 }
75 }
76
77 |
Popular Tags |
Java API By Example, From Geeks To Geeks.