KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/SdNextIdx.java,v 1.5 2036/02/08 19:17:04 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 /**
13  *
14  * @author
15  * @version
16  */
17 public class SdNextIdx extends TKPrepQuery{
18
19     public final static boolean ISPREPARED = true;
20     public final static String JavaDoc[] PARAMORDER = { "SITE_NODE_ID" };
21     public final static Object JavaDoc[][] PARAMTYPES = null;
22     public final static boolean[] SETRELEVANTS = { true };
23     
24     public final static String JavaDoc SQLSTRING =
25         
26         " SELECT " + DBStringFactory.nvl() +
27         "(MAX(SITE_NODE_DOC_IDX) + 1,0) AS SITE_NODE_DOC_IDX FROM SITE_DOCUMENT WHERE SITE_NODE_ID = ? ";
28
29     public void initQuery(Connection con) {
30         super.initQuery(
31             con,
32             ISPREPARED,
33             PARAMORDER,
34             PARAMTYPES,
35             SETRELEVANTS,
36             SQLSTRING );
37     }
38 }
39
Popular Tags