KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > sitetree > StNextID


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/StNextID.java,v 1.5 2036/02/08 19:17:47 markus Exp $
3  *
4  */

5 package com.teamkonzept.webman.mainint.db.queries.sitetree;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /**
12  * @author
13  * @version
14  */

15 public class StNextID extends TKPrepQuery{
16
17     public final static boolean ISPREPARED = true;
18     public final static String JavaDoc[] PARAMORDER = null;
19     public final static Object JavaDoc[][] PARAMTYPES = null;
20     public final static boolean[] SETRELEVANTS = { true };
21         
22     public final static String JavaDoc SQLSTRING =
23         
24         "SELECT " + DBStringFactory.nvl() + "(max(SITE_NODE_ID) + 1,0) AS " + NEXT_SITE_ID + " FROM SITE_TREE ";
25
26     public void initQuery(Connection con) {
27         super.initQuery(
28             con,
29             ISPREPARED,
30             PARAMORDER,
31             PARAMTYPES,
32             SETRELEVANTS,
33             SQLSTRING );
34     }
35 }
36
37
38
Popular Tags