KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > TKDBPropGetProp


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /*
8  * TKDBPropGetProp
9  * input (PROP_ID)
10  * output (PROP_ID, PROP_NAME, PROP_VALUE)
11  * @author
12  * @version
13  */

14 public class TKDBPropGetProp extends TKPrepQuery{
15
16     public final static boolean ISPREPARED =
17         true;
18     
19     public final static String JavaDoc[] PARAMORDER =
20         {"PROP_ID"};
21     
22     public final static Object JavaDoc[][] PARAMTYPES =
23         {{"PROP_ID", new Integer JavaDoc(Types.INTEGER)}};
24         
25     public final static boolean[] SETRELEVANTS =
26         { true };
27         
28     public final static String JavaDoc SQLSTRING =
29         "SELECT " +
30         " PROPERTY_ID AS PROP_ID, NAME AS PROP_NAME, VALUE AS PROP_VALUE " +
31         "FROM " +
32         " PROPERTY WHERE " +
33         " PROPERTY_ID = ? ";
34
35     
36     public void initQuery(Connection con) {
37         super.initQuery(
38             con,
39             ISPREPARED,
40             PARAMORDER,
41             PARAMTYPES,
42             SETRELEVANTS,
43             SQLSTRING );
44     }
45 }
46
47
Popular Tags