KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > properties > SelectMaxPropertyGroup


1 package com.teamkonzept.webman.mainint.db.queries.properties;
2
3 import java.sql.Connection JavaDoc;
4 import java.sql.Types JavaDoc;
5 import com.teamkonzept.db.*;
6
7 public class SelectMaxPropertyGroup extends TKPrepQuery
8 {
9
10     public final static boolean PREPARED = true;
11
12     public final static String JavaDoc[] ORDER = null;
13
14     public final static Object JavaDoc[][] TYPES = null;
15
16     public final static boolean[] RELEVANTS = { true };
17
18     public final static String JavaDoc SQLSTRING = "SELECT " + DBStringFactory.nvl() + "(MAX(PROPERTY_GROUP_ID)+1, 0) FROM PROPERTY_GROUP";
19
20     public void initQuery(Connection JavaDoc con) {
21         super.initQuery(
22             con,
23             PREPARED,
24             ORDER,
25             TYPES,
26             RELEVANTS,
27             SQLSTRING );
28     }
29
30 }
31
Popular Tags