01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/content/MediaGetNextID.java,v 1.6 2001/11/09 16:10:43 markus Exp $
03: *
04: */
05: package com.teamkonzept.webman.mainint.db.queries.content;
06:
07: import java.sql.*;
08:
09: import com.teamkonzept.db.*;
10:
11: /**
12: * @author
13: * @version
14: */
15: public class MediaGetNextID extends TKPrepQuery {
16:
17: public final static boolean IS_PREPARED = true;
18: public final static String[] PARAM_ORDER = null;
19: public final static Object[][] PARAM_TYPES = null;
20: public final static boolean[] SET_RELEVANTS = { true };
21:
22: public final static String SQL_STRING = "SELECT "
23: + DBStringFactory.nvl()
24: + "(MAX(MEDIA_ID)+1,1) AS NEXT_MEDIA_ID FROM MEDIA";
25:
26: public void initQuery(Connection con) {
27: super.initQuery(con, IS_PREPARED, PARAM_ORDER, PARAM_TYPES,
28: SET_RELEVANTS, SQL_STRING);
29: }
30: }
|