KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > field > InsertEmptyClob


1 package com.teamkonzept.webman.mainint.db.queries.field;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 public class InsertEmptyClob extends TKPrepQuery {
7
8     public final static boolean IS_PREPARED =
9         true;
10     
11     public final static String JavaDoc[] PARAM_ORDER =
12         { "CONTENT_ID", "CONTENT_NODE_ID", "IDX", MEDIA_ID };
13     
14     public final static Object JavaDoc[][] PARAM_TYPES =
15         null;
16         
17     public final static boolean[] SET_RELEVANTS =
18         { false };
19         
20     public final static String JavaDoc SQL_STRING =
21         "INSERT INTO CONTENT_VALUE " +
22         "(CONTENT_ID, CONTENT_NODE_ID, IDX, VALUE, MEDIA_ID) " +
23         " VALUES(?, ?, ?, empty_clob(), ?) ";
24
25     public void initQuery(Connection con) {
26         super.initQuery(
27             con,
28             IS_PREPARED,
29             PARAM_ORDER,
30             PARAM_TYPES,
31             SET_RELEVANTS,
32             SQL_STRING );
33     }
34 }
35
Popular Tags