KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $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 $
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 ContSelNextID 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(SELECTION_ID) + 1,0) AS " + SELECTION_ID +
25         " FROM CONTENT_SELECTION " ;
26
27     public void initQuery(Connection con) {
28         super.initQuery(
29             con,
30             ISPREPARED,
31             PARAMORDER,
32             PARAMTYPES,
33             SETRELEVANTS,
34             SQLSTRING );
35     }
36 }
37
38
39
Popular Tags