KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.refsel.db.queries.sybase;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /*
8  * TKWMDBGreatGrandMotherNode
9  * @author
10  * @version
11  */
12 public class TKWMDBGreatGrandMotherNode 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         "DECLARE @ID2 int " +
29         "SELECT " +
30         " @ID = SITE_NODE_PARENT " +
31         "FROM " +
32         " SITE_TREE " +
33         "WHERE " +
34         " SITE_NODE_ID = ? " +
35         
36         "SELECT " +
37         " @ID2 = SITE_NODE_PARENT " +
38         "FROM " +
39         " SITE_TREE " +
40         "WHERE " +
41         " SITE_NODE_ID = @ID " +
42         
43         "SELECT " +
44         " SITE_NODE_PARENT " +
45         "FROM " +
46         " SITE_TREE " +
47         "WHERE " +
48         " SITE_NODE_ID = @ID2 ";
49         
50     
51     public void initQuery(Connection con) {
52         super.initQuery(
53             con,
54             ISPREPARED,
55             PARAMORDER,
56             PARAMTYPES,
57             SETRELEVANTS,
58             SQLSTRING );
59     }
60 }
61
62
63
Popular Tags