KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > content > db > queries > TKDBContentAttributeGetOldContentId


1 package de.webman.content.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /**
7  * @author
8  * @version
9  */
10 public class TKDBContentAttributeGetOldContentId extends TKPrepQuery {
11
12     public final static boolean ISPREPARED = true;
13     public final static String JavaDoc[] PARAMORDER = { "CONTENT_ID", "INSTANCE_ID" };
14     public final static Object JavaDoc[][] PARAMTYPES = null;
15     public final static boolean[] SETRELEVANTS = { true };
16         
17     public final static String JavaDoc SQLSTRING =
18         
19         "SELECT MAX(C.CONTENT_ID) AS OLD_CONTENT_ID FROM CONTENT C, CONTENT_VERSION CV " +
20         "WHERE C.CONTENT_ID = CV.CONTENT_ID AND C.CONTENT_ID < ? AND CV.INSTANCE_ID = ?";
21             
22     public void initQuery(Connection con) {
23         super.initQuery(
24             con,
25             ISPREPARED,
26             PARAMORDER,
27             PARAMTYPES,
28             SETRELEVANTS,
29             SQLSTRING );
30     }
31 }
32
Popular Tags