1 5 package com.teamkonzept.webman.mainint.db.queries.content; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 12 16 public class MediaGetNextID extends TKPrepQuery 17 { 18 19 public final static boolean IS_PREPARED = true; 20 public final static String [] PARAM_ORDER = null; 21 public final static Object [][] PARAM_TYPES = null; 22 public final static boolean[] SET_RELEVANTS = {true}; 23 24 public final static String SQL_STRING = 25 "SELECT " + DBStringFactory.nvl() + "(MAX(MEDIA_ID)+1,1) AS NEXT_MEDIA_ID FROM MEDIA"; 26 27 28 29 public void initQuery(Connection con) { 30 super.initQuery( 31 con, 32 IS_PREPARED, 33 PARAM_ORDER, 34 PARAM_TYPES, 35 SET_RELEVANTS, 36 SQL_STRING ); 37 } 38 } 39 | Popular Tags |