KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > sybase > TKDBContentNewContent


1 /**
2  * Jedes Selectstatement erhaelt eine eigene Klasse
3  */
4 package com.teamkonzept.webman.mainint.db.queries.sybase;
5
6 import com.teamkonzept.db.*;
7 import java.sql.*;
8
9 public class TKDBContentNewContent extends TKPrepQuery {
10
11     public final static boolean isPrepared =
12         true;
13     
14     public final static String JavaDoc[] paramOrder =
15         { };
16     
17     public final static Object JavaDoc[][] paramTypes =
18         { };
19         
20     public final static boolean[] setRelevants =
21         { true };
22         
23     public final static String JavaDoc sqlString =
24         "DECLARE @CONT_ID INT " +
25
26         "SELECT @CONT_ID=ISNULL(MAX(CONTENT_ID)+1, 1) " +
27         "FROM CONTENT " +
28         
29         "INSERT INTO CONTENT (CONTENT_ID) " +
30         "VALUES(@CONT_ID) " +
31         
32         "SELECT @CONT_ID AS CONTENT_ID ";
33     
34     public void initQuery(Connection con) {
35         super.initQuery(
36             con,
37             isPrepared,
38             paramOrder,
39             paramTypes,
40             setRelevants,
41             sqlString );
42     }
43 }
44
Popular Tags