KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > apache > juddi > datastore > jdbc > InstanceDetailsDescTable


1 /*
2  * Copyright 2001-2004 The Apache Software Foundation.
3  *
4  * Licensed under the Apache License, Version 2.0 (the "License");
5  * you may not use this file except in compliance with the License.
6  * You may obtain a copy of the License at
7  *
8  * http://www.apache.org/licenses/LICENSE-2.0
9  *
10  * Unless required by applicable law or agreed to in writing, software
11  * distributed under the License is distributed on an "AS IS" BASIS,
12  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13  * See the License for the specific language governing permissions and
14  * limitations under the License.
15  */
16 package org.apache.juddi.datastore.jdbc;
17
18 import java.sql.Connection JavaDoc;
19 import java.sql.PreparedStatement JavaDoc;
20 import java.sql.ResultSet JavaDoc;
21 import java.util.Vector JavaDoc;
22
23 import org.apache.commons.logging.Log;
24 import org.apache.commons.logging.LogFactory;
25 import org.apache.juddi.datatype.Description;
26
27 /**
28  * @author Steve Viens (sviens@apache.org)
29  */
30 class InstanceDetailsDescTable
31 {
32   // private reference to the jUDDI logger
33 private static Log log = LogFactory.getLog(InstanceDetailsDescTable.class);
34
35   static String JavaDoc insertSQL = null;
36   static String JavaDoc selectSQL = null;
37   static String JavaDoc deleteSQL = null;
38
39   static {
40     // buffer used to build SQL statements
41 StringBuffer JavaDoc sql = null;
42
43     // build insertSQL
44 sql = new StringBuffer JavaDoc(150);
45     sql.append("INSERT INTO INSTANCE_DETAILS_DESCR (");
46     sql.append("BINDING_KEY,");
47     sql.append("TMODEL_INSTANCE_INFO_ID,");
48     sql.append("INSTANCE_DETAILS_DESCR_ID,");
49     sql.append("LANG_CODE,");
50     sql.append("DESCR) ");
51     sql.append("VALUES (?,?,?,?,?)");
52     insertSQL = sql.toString();
53
54     // build selectSQL
55 sql = new StringBuffer JavaDoc(200);
56     sql.append("SELECT ");
57     sql.append("LANG_CODE,");
58     sql.append("DESCR, ");
59     sql.append("INSTANCE_DETAILS_DESCR_ID ");
60     sql.append("FROM INSTANCE_DETAILS_DESCR ");
61     sql.append("WHERE BINDING_KEY=? ");
62     sql.append("AND TMODEL_INSTANCE_INFO_ID=? ");
63     sql.append("ORDER BY INSTANCE_DETAILS_DESCR_ID");
64     selectSQL = sql.toString();
65
66     // build deleteSQL
67 sql = new StringBuffer JavaDoc(100);
68     sql.append("DELETE FROM INSTANCE_DETAILS_DESCR ");
69     sql.append("WHERE BINDING_KEY=?");
70     deleteSQL = sql.toString();
71   }
72
73   /**
74    * Insert new row into the INSTANCE_DETAILS_DESCR table.
75    *
76    * @param bindingKey String to the BindingTemplate object
77    * @param tModelInstanceInfoID String to the BusinessEntity object that owns the Contact to be inserted
78    * @param descList Vector of Description objects holding values to be inserted
79    * @param connection JDBC connection
80    * @throws java.sql.SQLException
81    */
82   public static void insert(
83     String JavaDoc bindingKey,
84     int tModelInstanceInfoID,
85     Vector JavaDoc descList,
86     Connection JavaDoc connection)
87     throws java.sql.SQLException JavaDoc
88   {
89     if ((descList == null) || (descList.size() == 0))
90       return; // everything is valid but no elements to insert
91
92     PreparedStatement JavaDoc statement = null;
93
94     try
95     {
96       statement = connection.prepareStatement(insertSQL);
97       statement.setString(1, bindingKey.toString());
98       statement.setInt(2, tModelInstanceInfoID);
99
100       int listSize = descList.size();
101       for (int descID = 0; descID < listSize; descID++)
102       {
103         Description desc = (Description) descList.elementAt(descID);
104
105         // okay, set the values to be inserted
106 statement.setInt(3, descID); // Sequence Number aka Desc ID
107 statement.setString(4, desc.getLanguageCode());
108         statement.setString(5, desc.getValue());
109
110         log.debug(
111           "insert into INSTANCE_DETAILS_DESCR table:\n\n\t"
112             + insertSQL
113             + "\n\t BINDING_KEY="
114             + bindingKey.toString()
115             + "\n\t TMODEL_INSTANCE_INFO_ID="
116             + tModelInstanceInfoID
117             + "\n\t INSTANCE_DETAILS_DESCR_ID="
118             + descID
119             + "\n\t LANG_CODE="
120             + desc.getLanguageCode()
121             + "\n\t DESCR="
122             + desc.getValue()
123             + "\n");
124
125         statement.executeUpdate();
126       }
127     }
128     finally
129     {
130       try
131       {
132         statement.close();
133       }
134       catch (Exception JavaDoc e)
135       { /* ignored */
136       }
137     }
138   }
139
140   /**
141    * Select all rows from the TMODEL_INST_INFO table for a given BusinessKey.
142    *
143    * @param bindingKey String
144    * @param tModelInstanceInfoID ID (sequence number) of the parent TModelInstanceInfo object
145    * @param connection JDBC connection
146    * @throws java.sql.SQLException
147    */
148   public static Vector JavaDoc select(
149     String JavaDoc bindingKey,
150     int tModelInstanceInfoID,
151     Connection JavaDoc connection)
152     throws java.sql.SQLException JavaDoc
153   {
154     Vector JavaDoc descList = new Vector JavaDoc();
155     PreparedStatement JavaDoc statement = null;
156     ResultSet JavaDoc resultSet = null;
157
158     try
159     {
160       // create a statement to query with
161 statement = connection.prepareStatement(selectSQL);
162       statement.setString(1, bindingKey.toString());
163       statement.setInt(2, tModelInstanceInfoID);
164
165       log.debug(
166         "select from INSTANCE_DETAILS_DESCR table:\n\n\t"
167           + selectSQL
168           + "\n\t BINDING_KEY="
169           + bindingKey.toString()
170           + "\n\t TMODEL_INSTANCE_INFO_ID="
171           + tModelInstanceInfoID
172           + "\n");
173
174       // execute the statement
175 resultSet = statement.executeQuery();
176       while (resultSet.next())
177       {
178         Description desc = new Description();
179         desc.setLanguageCode(resultSet.getString(1)); //("LANG_CODE"));
180 desc.setValue(resultSet.getString(2)); //("DESCR"));
181 descList.add(desc);
182         desc = null;
183       }
184
185       return descList;
186     }
187     finally
188     {
189       try
190       {
191         resultSet.close();
192         statement.close();
193       }
194       catch (Exception JavaDoc e)
195       { /* ignored */
196       }
197     }
198   }
199
200   /**
201    * Delete multiple rows from the INSTANCE_DETAILS_DESCR table that are
202    * assigned to the BindingKey specified.
203    *
204    * @param bindingKey String
205    * @param connection JDBC connection
206    * @throws java.sql.SQLException
207    */
208   public static void delete(String JavaDoc bindingKey, Connection JavaDoc connection)
209     throws java.sql.SQLException JavaDoc
210   {
211     PreparedStatement JavaDoc statement = null;
212
213     try
214     {
215       // prepare
216 statement = connection.prepareStatement(deleteSQL);
217       statement.setString(1, bindingKey.toString());
218
219       log.debug(
220         "delete from INSTANCE_DETAILS_DESCR table:\n\n\t"
221           + deleteSQL
222           + "\n\t BINDING_KEY="
223           + bindingKey.toString()
224           + "\n");
225
226       // execute
227 statement.executeUpdate();
228     }
229     finally
230     {
231       try
232       {
233         statement.close();
234       }
235       catch (Exception JavaDoc e)
236       { /* ignored */
237       }
238     }
239   }
240 }
241
Popular Tags