1 package com.teamkonzept.webman.mainint.db.queries.content; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 6 public class InsertContentVersion extends TKPrepQuery 7 { 8 9 public final static boolean prepared = true; 10 11 public final static String [] order = { 12 "VERSION_ID", "INSTANCE_ID", "CONTENT_ID", "STATUS_ID", "DATE", "VERS_INFO", "VERS_AUTHOR" 13 }; 14 15 public final static Object [][] types = { 16 {"VERS_INFO", new Integer (java.sql.Types.VARCHAR)}, 17 {"VERS_AUTHOR", new Integer (java.sql.Types.VARCHAR)}, 18 {"DATE", new Integer (java.sql.Types.TIMESTAMP)} 19 }; 20 21 public final static boolean[] relevants = { true }; 22 23 public final static String sqlString = (new StringBuffer ("INSERT INTO CONTENT_VERSION (VERSION_ID, INSTANCE_ID, CONTENT_ID, STATUS_ID, VERSION_DATE, INFO, AUTHOR)") 24 .append("VALUES (?, ?, ?, ?, ?, ?, ?)")).toString(); 25 26 public void initQuery(Connection con) { 27 super.initQuery( 28 con, 29 prepared, 30 order, 31 types, 32 relevants, 33 sqlString ); 34 } 35 36 } | Popular Tags |