KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > field > db > TKReadFormFromDB


1 package com.teamkonzept.field.db;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6 import com.teamkonzept.lib.*;
7 import com.teamkonzept.web.*;
8 import com.teamkonzept.field.*;
9 import com.teamkonzept.field.db.queries.*;
10 import org.apache.log4j.Category;
11
12 public class TKReadFormFromDB
13 {
14     private static Category cat = Category.getInstance(TKReadFormFromDB.class);
15
16     public TKVector formVector;
17
18     public TKReadFormFromDB() {};
19
20     public void getForms()
21     {
22
23         try {
24             TKQuery q = TKDBManager.newQuery(TKDBGetAllFormIds.class);
25             q.execute();
26             ResultSet rs = q.fetchResultSet();
27
28             formVector = new TKVector();
29
30             int x = 0;
31             while(rs.next()){
32                 x++;
33                 formVector.addElement( new TKOptionFieldEntry(rs.getString("FIELD_SHOW_NAME"),rs.getString("FORM_ID")));
34
35             }
36         }
37         catch( SQLException e ) {
38             cat.error("GetallForms: " + e.getMessage(), e);
39         }
40
41
42
43     }
44 }
45
Popular Tags