1 5 package com.teamkonzept.webman.mainint.db.queries.sitetree; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 15 public class StNextID 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() + "(max(SITE_NODE_ID) + 1,0) AS " + NEXT_SITE_ID + " FROM SITE_TREE "; 25 26 public void initQuery(Connection con) { 27 super.initQuery( 28 con, 29 ISPREPARED, 30 PARAMORDER, 31 PARAMTYPES, 32 SETRELEVANTS, 33 SQLSTRING ); 34 } 35 } 36 37 38 | Popular Tags |