KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > content > db > queries > SelectNextIdFromContentAttribute


1 package de.webman.content.db.queries;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 /**
7  * select DBStringFactory.nvl() (MAX(VALUE_ID)+1, 1) from content_attribute
8  * @author markus
9  * @version 1.0
10  */
11 public class SelectNextIdFromContentAttribute extends TKPrepQuery
12 {
13
14     public final static boolean PREPARED = true;
15     public final static String JavaDoc[] ORDER = null;
16     public final static Object JavaDoc[][] TYPES = null;
17     public final static boolean[] RELEVANTS = { true };
18
19     public final static String JavaDoc SQLSTRING = "SELECT " + DBStringFactory.nvl() + "(MAX(VALUE_ID)+1,1) FROM CONTENT_ATTRIBUTE";
20
21     public void initQuery(Connection JavaDoc con) {
22         super.initQuery(
23             con,
24             PREPARED,
25             ORDER,
26             TYPES,
27             RELEVANTS,
28             SQLSTRING );
29     }
30
31 }
32
Popular Tags