1 package com.teamkonzept.webman.mainint.db.queries.properties; 2 3 import java.sql.Connection ; 4 import java.sql.Types ; 5 import com.teamkonzept.db.*; 6 7 12 public class SelectMaxProperty extends TKPrepQuery 13 { 14 15 public final static boolean PREPARED = true; 16 17 public final static String [] ORDER = null; 18 19 public final static Object [][] TYPES = null; 20 21 public final static boolean[] RELEVANTS = { true }; 22 23 public final static String SQLSTRING = "SELECT " + DBStringFactory.nvl() + "(MAX(PROPERTY_ID)+1, 0) AS PROPERTY_MAX FROM PROPERTY"; 24 25 public void initQuery(Connection con) { 26 super.initQuery( 27 con, 28 PREPARED, 29 ORDER, 30 TYPES, 31 RELEVANTS, 32 SQLSTRING ); 33 } 34 35 } 36 | Popular Tags |