KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > refsel > db > queries > sybase > TKWMDBGrandMotherNode


1 package com.teamkonzept.webman.refsel.db.queries.sybase;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /*
8  * TKWMDBGrandMotherNode
9  * @author
10  * @version
11  */
12 public class TKWMDBGrandMotherNode extends TKPrepQuery {
13
14     public final static boolean ISPREPARED =
15         true;
16     
17     public final static String JavaDoc[] PARAMORDER =
18         {"SITE_NODE_ID"};
19     
20     public final static Object JavaDoc[][] PARAMTYPES =
21         null;
22                 
23     public final static boolean[] SETRELEVANTS =
24         { true };
25         
26     public final static String JavaDoc SQLSTRING =
27         "DECLARE @ID int " +
28         "SELECT " +
29         " @ID = SITE_NODE_PARENT " +
30         "FROM " +
31         " SITE_TREE " +
32         "WHERE " +
33         " SITE_NODE_ID = ? " +
34         "SELECT " +
35         " SITE_NODE_PARENT " +
36         "FROM " +
37         " SITE_TREE " +
38         "WHERE " +
39         " SITE_NODE_ID = @ID ";
40         
41     
42     public void initQuery(Connection con) {
43         super.initQuery(
44             con,
45             ISPREPARED,
46             PARAMORDER,
47             PARAMTYPES,
48             SETRELEVANTS,
49             SQLSTRING );
50     }
51 }
52
53
54
Popular Tags