01: /*
02: * $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 $
03: *
04: */
05: package com.teamkonzept.webman.mainint.db.queries.sitetree;
06:
07: import java.sql.*;
08:
09: 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[] PARAMORDER = null;
19: public final static Object[][] PARAMTYPES = null;
20: public final static boolean[] SETRELEVANTS = { true };
21:
22: public final static String SQLSTRING =
23:
24: "SELECT " + DBStringFactory.nvl() + "(max(SITE_NODE_ID) + 1,0) AS "
25: + NEXT_SITE_ID + " FROM SITE_TREE ";
26:
27: public void initQuery(Connection con) {
28: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
29: SETRELEVANTS, SQLSTRING);
30: }
31: }
|