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 |