|
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 TKMarkupParamDefinitionDBData extends TKDBData
15 {
16 private static final Category cat = Category.getInstance(TKMarkupParamDefinitionDBData.class);
17
18 public TKMarkupParamDefinition param;
19
20 public TKMarkupParamDefinitionDBData () {
21
22 this.param = null;
23 }
24
25 public TKMarkupParamDefinitionDBData (TKMarkupParamDefinition param, StringBuffer  diagnostics) {
26
27 this.param = param;
28 }
29
30 public void insertPrimaryIntoQuery (TKQuery query) throws SQLException {
31
32 query.setQueryParams ("PARAMETER_ID",new Integer (param.id));
33 }
34
35 public void insertInitialIntoQuery (TKQuery query) throws SQLException {
36
37 query.setQueryParams( "NAME", param.name );
38 query.setQueryParams( "SELECTION_DATA", param.data());
39 query.setQueryParams( "SELECTION_CLASS_ID", new Integer (param.typeClass == null ? -1 : param.typeClass.id) );
40 query.setQueryParams( "IS_CASE_SENSITIVE", new Integer (param.isCaseSensitive ? 1 : 0) );
41 query.setQueryParams( "DEFAULT_VALUE", param.defaultValue());
42 }
43
44 public void insertIntoQuery (TKQuery query) throws SQLException {
45
46 insertPrimaryIntoQuery (query);
47 insertInitialIntoQuery (query);
48 }
49
50 public static TKMarkupParamDefinition newParamFromResultSet (ResultSet r) {
51
52 try {
53 int id = r.getInt ("PARAMETER_ID");
54 String name = r.getString("NAME");
55 String data = r.getString ("SELECTION_DATA");
56 int typeClassId = r.getInt ("SELECTION_CLASS_ID");
57 boolean isCaseSensitive = r.getBoolean ("IS_CASE_SENSITIVE");
58 String defaultValue = r.getString ("DEFAULT_VALUE");
59
60 return new TKMarkupParamDefinition (id,name,typeClassId,isCaseSensitive,defaultValue,data);
61
62 } catch (Exception ex)
63 {
64 cat.error("TKMarkupParamDefinitionDBData.newParamFromResultSet() failed", ex);
65 return null;
66 }
67 }
68
69 public void fill (ResultSet r) throws SQLException {
70
71 param = newParamFromResultSet (r);
72 }
73
74 public String toString() {
75
76 return "(MARKUP_PARAM_DEFINITION :=" + param + ")";
77 }
78 }
79
80 |
Popular Tags |
Java API By Example, From Geeks To Geeks.