KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > publishing > markups > db > queries > TKMarkupDefinitionUpdate


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/publishing/markups/db/queries/TKMarkupDefinitionUpdate.java,v 1.6 2001/11/06 16:18:36 markus Exp $
3  *
4  */
5 package com.teamkonzept.publishing.markups.db.queries;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /**
12  *
13  * @author
14  * @version
15  */
16 public class TKMarkupDefinitionUpdate extends TKPrepQuery {
17
18     public final static boolean ISPREPARED = true;
19     public final static String JavaDoc[] PARAMORDER =
20         { "NAME", "INFO", "IS_ATOM", "VALIDATION_ID",
21           "ID_PARAMETER_ID", "ATTRIBUTE_ID" };
22     
23     public final static Object JavaDoc[][] PARAMTYPES =
24         {{ "NAME", new Integer JavaDoc(Types.VARCHAR) },
25          { "INFO", new Integer JavaDoc(Types.LONGVARCHAR) }};
26         
27     public final static boolean[] SETRELEVANTS = { false };
28     
29     public final static String JavaDoc SQLSTRING =
30
31         "UPDATE TEXT_ATTRIBUTE " +
32         "SET " +
33         " NAME = ?, " +
34         " INFO = ?, " +
35         " IS_ATOM = ?, " +
36         " VALIDATION_ID = ?, " +
37         " ID_PARAMETER_ID = ? " +
38         "WHERE "+
39         " ATTRIBUTE_ID = ? ";
40         
41     public void initQuery(Connection con) {
42         super.initQuery(con,ISPREPARED,PARAMORDER,PARAMTYPES,SETRELEVANTS,SQLSTRING );
43     }
44 }
45
46
Popular Tags