1 package com.teamkonzept.webman.mainint.db.queries.accesscontrol; 2 3 import com.teamkonzept.db.TKPrepQuery; 4 import com.teamkonzept.db.DBStringFactory; 5 import java.sql.Connection ; 6 import java.sql.SQLException ; 7 8 public class SelectPropertyMax extends TKPrepQuery 9 { 10 11 public final static boolean PREPARED = true; 12 13 public final static String [] ORDER = null; 14 15 public final static Object [][] TYPES = null; 16 17 public final static boolean[] RELEVANTS = { true }; 18 19 public final static String SQL_STRING = "SELECT " + DBStringFactory.nvl() + "(MAX(WM_PROPERTIES_ID) + 1, 1) FROM WM_PROPERTIES"; 20 21 public void initQuery(Connection con) { 22 super.initQuery( 23 con, 24 PREPARED, 25 ORDER, 26 TYPES, 27 RELEVANTS, 28 SQL_STRING ); 29 } 30 31 } 32 | Popular Tags |