TKDBPropGroupGetAllProps.java :  » Content-Management-System » webman » com » teamkonzept » webman » mainint » db » queries » Java Open Source

package com.teamkonzept.webman.mainint.db.queries;

import java.sql.*;

import com.teamkonzept.db.*;

/*
 * TKDBPropGroupGetAllProps
 * input
 * output (PROPERPTY_ID, NAME, VALUE)
 * selects all properties.
 * @author
 * @version
 */
public class TKDBPropGroupGetAllProps extends TKPrepQuery{

  public final static boolean ISPREPARED =
    true;
  
  public final static String[] PARAMORDER = null;
//    {"PROPGROUP_ID"};
  
  public final static Object[][] PARAMTYPES = null;
//    {{"PROPGROUP_ID", new Integer(Types.INTEGER)}};
    
  public final static boolean[] SETRELEVANTS =
    { true };
    
  public final static String SQLSTRING =
    "SELECT PROPERTY_ID AS PROP_ID, NAME AS PROP_NAME, VALUE AS PROP_VALUE " +
    " FROM PROPERTY ";
    
  public void initQuery(Connection con) {
    super.initQuery(
      con, 
      ISPREPARED, 
      PARAMORDER, 
      PARAMTYPES,
      SETRELEVANTS,
      SQLSTRING ); 
  }
}