KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > field > SelectMaxForm


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/field/SelectMaxForm.java,v 1.4 2001/11/09 16:43:12 markus Exp $
3  *
4  */
5 /**
6  * Jedes Selectstatement erhaelt eine eigene Klasse
7  */
8 package com.teamkonzept.webman.mainint.db.queries.field;
9
10 import java.sql.*;
11
12 import com.teamkonzept.db.*;
13
14 /**
15  * @author
16  * @version
17  */
18 public class SelectMaxForm extends TKPrepQuery {
19
20     public final static boolean ISPREPARED =
21         true;
22     
23     public final static String JavaDoc[] PARAMORDER = null;
24     
25     public final static Object JavaDoc[][] PARAMTYPES =
26         null;
27         
28     public final static boolean[] SETRELEVANTS =
29         { true };
30         
31     public final static String JavaDoc SQLSTRING =
32         "SELECT " + DBStringFactory.nvl() + "(MAX(FORM_ID)+1, 1) AS MAX FROM FORM";
33     
34     public void initQuery(Connection con) {
35         super.initQuery(
36             con,
37             ISPREPARED,
38             PARAMORDER,
39             PARAMTYPES,
40             SETRELEVANTS,
41             SQLSTRING );
42     }
43 }
44
45
46
Popular Tags