KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > content > MediaGetNextID


1 /*
2  * $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 $
3  *
4  */

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

16 public class MediaGetNextID extends TKPrepQuery
17 {
18
19     public final static boolean IS_PREPARED = true;
20     public final static String JavaDoc[] PARAM_ORDER = null;
21     public final static Object JavaDoc[][] PARAM_TYPES = null;
22     public final static boolean[] SET_RELEVANTS = {true};
23         
24     public final static String JavaDoc SQL_STRING =
25         "SELECT " + DBStringFactory.nvl() + "(MAX(MEDIA_ID)+1,1) AS NEXT_MEDIA_ID FROM MEDIA";
26         
27         
28
29     public void initQuery(Connection con) {
30         super.initQuery(
31             con,
32             IS_PREPARED,
33             PARAM_ORDER,
34             PARAM_TYPES,
35             SET_RELEVANTS,
36             SQL_STRING );
37     }
38 }
39
Popular Tags