KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > field > db > queries > sybase > TKDBFormNew


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/field/db/queries/sybase/TKDBFormNew.java,v 1.1 2001/10/15 10:03:51 markus Exp $
3  *
4  */
5 /**
6  * Jedes Selectstatement erhaelt eine eigene Klasse
7  */
8 package com.teamkonzept.field.db.queries.sybase;
9
10 import java.sql.*;
11
12 import com.teamkonzept.db.*;
13
14 /**
15  * @author
16  * @version
17  */
18 public class TKDBFormNew extends TKPrepQuery{
19
20     public final static boolean ISPREPARED = true;
21     public final static String JavaDoc[] PARAMORDER = {"FORM_TYPE", "FORM_TYPE"};
22     public final static Object JavaDoc[][] PARAMTYPES = null;
23     public final static boolean[] SETRELEVANTS = { true };
24         
25     public final static String JavaDoc SQLSTRING =
26         "DECLARE @ID INT " +
27         
28         "BEGIN TRANSACTION " +
29         
30         "SELECT " +
31         " @ID=ISNULL(MAX(FORM_ID)+1, 1) " +
32         "FROM " +
33         " FORM " +
34         
35         "INSERT INTO " +
36         "FORM " +
37         " (FORM_ID, FORM_TYPE) " +
38         "VALUES(@ID, ?) " +
39         
40         "COMMIT TRANSACTION " +
41         
42         "SELECT " +
43         " @ID AS FORM_ID, ? AS FORM_TYPE ";
44     
45     
46     public void initQuery(Connection con) {
47         super.initQuery(
48             con,
49             ISPREPARED,
50             PARAMORDER,
51             PARAMTYPES,
52             SETRELEVANTS,
53             SQLSTRING );
54     }
55 }
56
57
58
Popular Tags