VersionStatusTransitionNew.java :  » Content-Management-System » webman » de » webman » content » workflow » db » queries » Java Open Source

package de.webman.content.workflow.db.queries;

import com.teamkonzept.db.*;
import java.sql.*;

/**
  * @author  $Author: alex $
  * @version $Revision: 1.1 $
*/
public class VersionStatusTransitionNew extends TKPrepQuery {

  public final static boolean IS_PREPARED =
    true;
  
  public final static String[] PARAM_ORDER =
    { "STATUS_ID", "NEW_STATUS_ID", "TRANSITION_ATTRIBUTES" };
  
  public final static Object[][] PARAM_TYPES =
    { {"TRANSITION_ATTRIBUTES", new Integer(Types.VARCHAR)} };
    
  public final static boolean[] SET_RELEVANTS =
    { true };
    
  public final static String SQL_STRING =
    "INSERT INTO VERSION_STATUS_TRANSITION (STATUS_ID, NEW_STATUS_ID, TRANSITION_ATTRIBUTES) " +
    "VALUES(?, ?, ?) ";
  
  
  public void initQuery(Connection con) {
    super.initQuery(
      con, 
      IS_PREPARED, 
      PARAM_ORDER, 
      PARAM_TYPES,
      SET_RELEVANTS,
      SQL_STRING ); 
  }
}