1 5 package com.teamkonzept.field.db; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 public class TKSubFieldTableData extends TKDBTableData { 12 public int form_id; 13 public int field_id; 14 public int sub_field_id; 15 public String name; 16 public int idx; 17 18 public TKSubFieldTableData () 19 { 20 } 21 22 public TKSubFieldTableData( int form_id, int field_id, int sub_field_id, String name, int idx ) 23 { 24 this.form_id = form_id; 25 this.field_id = field_id; 26 this.sub_field_id = sub_field_id; 27 this.name = name; 28 this.idx = idx; 29 } 30 31 public TKSubFieldTableData (ResultSet rs) 32 throws SQLException 33 { 34 this.form_id = rs.getInt("FORM_ID"); 35 this.field_id = rs.getInt("FIELD_ID"); 36 this.sub_field_id = rs.getInt("SUB_FIELD_ID"); 37 this.name = rs.getString("NAME"); 38 this.idx = rs.getInt("IDX"); 39 } 40 41 public TKDBTableData newFromResultSet( ResultSet r ) 42 throws SQLException 43 { 44 return new TKSubFieldTableData( r ); 45 } 46 47 public void insertIntoQuery(TKQuery query) 48 throws SQLException 49 { 50 query.setQueryParams("FORM_ID", new Integer (form_id)); 51 query.setQueryParams("FIELD_ID", new Integer (field_id)); 52 query.setQueryParams("SUB_FIELD_ID", new Integer (sub_field_id)); 53 query.setQueryParams("NAME", name); 54 query.setQueryParams("IDX", new Integer (idx)); 55 } 56 57 public String toString() 58 { 59 return "( FORM_ID="+String.valueOf( form_id ) 60 + ", FIELD_ID="+String.valueOf( field_id ) 61 + ", SUB_FIELD_ID="+String.valueOf( sub_field_id ) 62 + ", NAME="+name 63 + ", IDX="+String.valueOf( idx ) 64 + ")\n"; 65 } 66 } 69 70 | Popular Tags |