KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /**
7     Diese Query ist nur ein Hack für die Intershop Open
8     und sollte nicht allgemein verwendet werden !!
9 */

10 public class TKIntershopContentInstanceGet extends TKPrepQuery {
11
12     public final static boolean isPrepared =
13         true;
14     
15     public final static String JavaDoc[] paramOrder =
16         { "CONTENT_NODE_SHORTNAME" };
17     
18     public final static Object JavaDoc[][] paramTypes =
19         null;
20         
21     public final static boolean[] setRelevants =
22         { true };
23         
24     public final static String JavaDoc sqlString =
25         "SELECT INSTANCE_ID, CONTENT_NODE_ID FROM CONTENT_INSTANCE " +
26         "WHERE CONTENT_NODE_ID = (SELECT MAX(CONTENT_NODE_ID) FROM CONTENT_TREE WHERE " +
27         "CONTENT_NODE_SHORTNAME = ?) ";
28     
29     public void initQuery(Connection con) {
30         super.initQuery(
31             con,
32             isPrepared,
33             paramOrder,
34             paramTypes,
35             setRelevants,
36             sqlString );
37     }
38 }
39
Popular Tags