|
1
5 package com.teamkonzept.publishing.markups.db;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10 import com.teamkonzept.lib.*;
11 import com.teamkonzept.publishing.markups.*;
12 import org.apache.log4j.Category;
13
14 public class TKMarkupParamCallTableData extends TKDBTableData
15 {
16 private static final Category cat =Category.getInstance(TKMarkupParamCallTableData.class);
17
18 public int markupId;
19 public int paramId;
20 public TKMarkupParamCall param;
21
22 public TKMarkupParamCallTableData () {
23
24 this.markupId = -1;
25 this.paramId = -1;
26 this.param = null;
27 }
28
29 public TKMarkupParamCallTableData (int markupId,TKMarkupParamCall param) {
30
31 this.markupId = markupId;
32 this.paramId = param.param.id;
33 this.param = param;
34 }
35
36 public TKMarkupParamCallTableData (ResultSet r) throws SQLException {
37
38 try {
39 this.markupId = r.getInt ("ATTRIBUTE_ID");
40 this.paramId = r.getInt ("PARAMETER_ID");
41
42 String  name = r.getString ("NAME");
43 boolean isOptional = r.getBoolean ("IS_OPTIONAL");
44 boolean useDefault = r.getBoolean ("USE_DEFAULT");
45 boolean editable = r.getBoolean ("EDIT");
46 String defaultValue = r.getString ("DEFAULT_VALUE");
47
48 this.param = new TKMarkupParamCall(name,paramId,isOptional,
49 useDefault,editable,defaultValue);
50
51 } catch (Exception ex)
52 {
53 cat.error ("TKMarkupParamCallTableData.newCallFromResultSet() failed", ex);
54 }
55 }
56
57 public TKDBTableData newFromResultSet (ResultSet r) throws SQLException {
58
59 return new TKMarkupParamCallTableData (r);
60 }
61
62 public void insertIntoQuery (TKQuery query) throws SQLException {
63
64 query.setQueryParams( "ATTRIBUTE_ID", new Integer (this.markupId) );
65 query.setQueryParams( "PARAMETER_ID", new Integer (this.paramId) );
66
67 query.setQueryParams( "NAME", param.name );
68 query.setQueryParams( "IS_OPTIONAL", new Integer (param.isOptional ? 1 : 0) );
69 query.setQueryParams( "USE_DEFAULT", new Integer (param.useDefault ? 1 : 0) );
70 query.setQueryParams( "EDIT", new Integer (param.editable ? 1 : 0) );
71 query.setQueryParams( "DEFAULT_VALUE", param.defaultValue());
72 }
73
74 public String toString() {
75
76 return "(MARKUP_ID="+markupId+", PARAM_ID="+paramId+", "+param+")";
77 }
78 }
79
80 |
Popular Tags |
Java API By Example, From Geeks To Geeks.