KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBTmplGetAll.java,v 1.9 2002/02/05 16:36:22 sebastian Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /**
12  * TKDBTmplGetAll
13  * input none
14  * output (TEMPLATE_ID, TEMPLATE_NAME)
15  * @author
16  * @version
17  */
18 public class TKDBTmplGetAll extends TKPrepQuery{
19
20     /** prepariert ? */
21     public static final boolean ISPREPARED = true;
22     public static final String JavaDoc[] PARAMORDER = null;
23     public static final Object JavaDoc[][] PARAMTYPES = null;
24     public static final boolean[] SETRELEVANTS = { true };
25     
26     /** die query */
27     public static final String JavaDoc SQLSTRING =
28         "SELECT TEMPLATE_ID, TEMPLATE_NAME " +
29         "FROM TEMPLATE ORDER BY " + DBStringFactory.upper_order() + "(TEMPLATE_NAME)";
30     
31     public void initQuery(Connection con) {
32         super.initQuery(
33             con,
34             ISPREPARED,
35             PARAMORDER,
36             PARAMTYPES,
37             SETRELEVANTS,
38             SQLSTRING );
39     }
40 }
41
42
Popular Tags