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