KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > field > TKFieldTableData


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/field/TKFieldTableData.java,v 1.7 2001/12/03 13:25:13 ralf Exp $
3  *
4  */
5 package com.teamkonzept.field;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 public class TKFieldTableData extends TKDBTableData{
12     public int form_id;
13     public int field_id;
14     public String JavaDoc field_type;
15     public String JavaDoc field_name;
16     public String JavaDoc field_show_name;
17
18     public TKFieldTableData( )
19     {
20     }
21     
22     public TKFieldTableData( int form_id, int field_id, String JavaDoc field_type, String JavaDoc field_name, String JavaDoc field_show_name )
23     {
24         this.form_id = form_id;
25         this.field_id = field_id;
26         this.field_type = field_type;
27         this.field_name = field_name;
28         this.field_show_name = field_show_name;
29     }
30
31     public TKFieldTableData( ResultSet r )
32         throws SQLException
33     {
34         this.form_id = r.getInt("FORM_ID");
35         this.field_id = r.getInt("FIELD_ID");
36         this.field_type = r.getString("FIELD_TYPE");
37         this.field_name = r.getString("FIELD_NAME");
38         // cave: oracle's jdbc driver returns null if the column contains NULL whereas sybase
39 // and postgresql return an empty string ("").
40 if (this.field_name == null)
41         {
42             this.field_name = "";
43         }
44         this.field_show_name = r.getString("FIELD_SHOW_NAME");
45     }
46     
47     public TKDBTableData newFromResultSet( ResultSet r )
48         throws SQLException
49     {
50         return new TKFieldTableData( r );
51     }
52     
53     public void insertIntoQuery(TKQuery query)
54         throws SQLException
55     {
56         query.setQueryParams("FORM_ID", new Integer JavaDoc(form_id));
57         query.setQueryParams("FIELD_ID", new Integer JavaDoc(field_id));
58         query.setQueryParams("FIELD_TYPE", field_type);
59         query.setQueryParams("FIELD_NAME", field_name);
60         query.setQueryParams("FIELD_SHOW_NAME", field_show_name);
61     }
62         
63     public String JavaDoc toString()
64     {
65         return "( FORM_ID="+String.valueOf( form_id )
66             + ", FIELD_ID="+String.valueOf( field_id )
67             + ", FIELD_TYPE="+field_type
68             + ", FIELD_NAME="+field_name
69             + ", FIELD_SHOW_NAME="+field_show_name
70             + ")";
71     }
72     //{{DECLARE_CONTROLS
73 //}}
74 }
75
76
Popular Tags