|
1 package com.teamkonzept.webman.mainint.db.queries.sybase;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 public class TKContentInstanceNew extends TKPrepQuery {
7
8 public final static boolean isPrepared =
9 true;
10
11 public final static String  [] paramOrder =
12 { "CONTENT_NODE_ID", "INST_NAME" };
13
14 public final static Object [][] paramTypes =
15 { {"INST_NAME", new Integer (Types.VARCHAR)} };
16
17 public final static boolean[] setRelevants =
18 { true };
19
20 public final static String sqlString =
21 "DECLARE @N_ID INT " +
22 "DECLARE @INST_ID INT " +
23
24 "BEGIN TRANSACTION " +
25
26 "SELECT @N_ID = ? " +
27
28 "SELECT @INST_ID=ISNULL(MAX(INSTANCE_ID)+1, 1) " +
29 "FROM CONTENT_INSTANCE " +
30
31 "INSERT INTO CONTENT_INSTANCE (CONTENT_NODE_ID, INSTANCE_ID, NAME) " +
32 "VALUES(@N_ID, @INST_ID, ?) " +
33
34 "COMMIT TRANSACTION " +
35
36 "SELECT * FROM CONTENT_INSTANCE " +
37 "WHERE INSTANCE_ID = @INST_ID ";
38
39
40 public void initQuery(Connection con) {
41 super.initQuery(
42 con,
43 isPrepared,
44 paramOrder,
45 paramTypes,
46 setRelevants,
47 sqlString );
48 }
49 }
50 |
Popular Tags |
Java API By Example, From Geeks To Geeks.