KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > accesscontrol > SelectPropertyMax


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