01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/ContSelNextID.java,v 1.5 2001/11/09 16:46:53 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 ContSelNextID 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()
25: + "(MAX(SELECTION_ID) + 1,0) AS " + SELECTION_ID
26: + " FROM CONTENT_SELECTION ";
27:
28: public void initQuery(Connection con) {
29: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
30: SETRELEVANTS, SQLSTRING);
31: }
32: }
|