1 package com.teamkonzept.webman.mainint.db.queries.field; 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 { 13 "VERSION_ID", 14 "INSTANCE_ID", 15 "CONTENT_ID", 16 "STATUS_ID", 17 "DATE", 18 "VERS_INFO", 19 "VERS_AUTHOR" 20 }; 21 22 public final static Object [][] types = 23 { 24 {"VERS_INFO", new Integer (java.sql.Types.VARCHAR)}, 25 {"VERS_AUTHOR", new Integer (java.sql.Types.VARCHAR)}, 26 {"DATE", new Integer (java.sql.Types.TIMESTAMP)} 27 }; 28 29 public final static boolean[] relevants = { true }; 30 31 public final static String sqlString = "INSERT INTO CONTENT_VERSION (VERSION_ID, INSTANCE_ID, CONTENT_ID, STATUS_ID, VERSION_DATE, INFO, AUTHOR) VALUES (?, ?, ?, ?, ?, ?, ?)"; 32 33 public void initQuery(Connection con) { 34 super.initQuery( 35 con, 36 prepared, 37 order, 38 types, 39 relevants, 40 sqlString ); 41 } 42 43 } | Popular Tags |