D:\CRM_Project\CRM_Metadata_Structure\NetBeamsICM_TestProject\ICM_DB_TestComponents\src\java\unstructured_data_idao\ExcelColumnMap2DAO.java |
1
2
3
4
5
6 package unstructured_data_idao;
7
8
9 To build an intelligent system is kind of vague, but the best answer is how spreadsheets calculate values on the run
10 Our first attempt here is build an IDAO which mimic spreadsheets and performs calculation based on formulas.
11
12 @author
13
14 public class ExcelColumnMap2DAO {
15
16
17 private int totalCount = 0;
18 private int booleanCount = 0;
19 private int blankCount = 0;
20 private int errorCount = 0;
21 private int formulaCount = 0;
22 private int formulaSumCount = 0;
23 private int formulaComplexCount = 0;
24 private int formulaMultiplicationCount = 0;
25 private int knownheaderCount = 0;
26 private int labelCount = 0;
27 private int commentCount = 0;
28 private int numericCount = 0;
29 private int unknownheaderCount = 0;
30 private int miscCount = 0;
31
32
33 public ExcelColumnMap2DAO () {
34
35 }
36
37
38 @return
39
40 public int getBooleanCount() {
41 return booleanCount;
42 }
43
44
45 @param
46
47 public void setBooleanCount(int booleanCount) {
48 this.booleanCount = booleanCount;
49 }
50
51
52 @return
53
54 public int getBlankCount() {
55 return blankCount;
56 }
57
58
59 @param
60
61 public void setBlankCount(int blankCount) {
62 this.blankCount = blankCount;
63 }
64
65
66 @return
67
68 public int getErrorCount() {
69 return errorCount;
70 }
71
72
73 @param
74
75 public void setErrorCount(int errorCount) {
76 this.errorCount = errorCount;
77 }
78
79
80 @return
81
82 public int getFormulaCount() {
83 return formulaCount;
84 }
85
86
87 @param
88
89 public void setFormulaCount(int formulaCount) {
90 this.formulaCount = formulaCount;
91 }
92
93
94 @return
95
96 public int getFormulaSumCount() {
97 return formulaSumCount;
98 }
99
100
101 @param
102
103 public void setFormulaSumCount(int formulaSumCount) {
104 this.formulaSumCount = formulaSumCount;
105 }
106
107
108 @return
109
110 public int getFormulaComplexCount() {
111 return formulaComplexCount;
112 }
113
114
115 @param
116
117 public void setFormulaComplexCount(int formulaComplexCount) {
118 this.formulaComplexCount = formulaComplexCount;
119 }
120
121
122 @return
123
124 public int getFormulaMultiplicationCount() {
125 return formulaMultiplicationCount;
126 }
127
128
129 @param
130
131 public void setFormulaMultiplicationCount(int formulaMultiplicationCount) {
132 this.formulaMultiplicationCount = formulaMultiplicationCount;
133 }
134
135
136 @return
137
138 public int getKnownheaderCount() {
139 return knownheaderCount;
140 }
141
142
143 @param
144
145 public void setKnownheaderCount(int knownheaderCount) {
146 this.knownheaderCount = knownheaderCount;
147 }
148
149
150 @return
151
152 public int getLabelCount() {
153 return labelCount;
154 }
155
156
157 @param
158
159 public void setLabelCount(int labelCount) {
160 this.labelCount = labelCount;
161 }
162
163
164 @return
165
166 public int getCommentCount() {
167 return commentCount;
168 }
169
170
171 @param
172
173 public void setCommentCount(int commentCount) {
174 this.commentCount = commentCount;
175 }
176
177
178 @return
179
180 public int getNumericCount() {
181 return numericCount;
182 }
183
184
185 @param
186
187 public void setNumericCount(int numericCount) {
188 this.numericCount = numericCount;
189 }
190
191
192 @return
193
194 public int getUnknownheaderCount() {
195 return unknownheaderCount;
196 }
197
198
199 @param
200
201 public void setUnknownheaderCount(int unknownheaderCount) {
202 this.unknownheaderCount = unknownheaderCount;
203 }
204
205
206 @return
207
208 public int getMiscCount() {
209 return miscCount;
210 }
211
212
213 @param
214
215 public void setMiscCount(int miscCount) {
216 this.miscCount = miscCount;
217 }
218
219 @return
220
221 public int getTotalCount() {
222 return totalCount;
223 }
224
225
226 @param
227
228 public void setTotalCount(int totalCount) {
229 this.totalCount = totalCount;
230 }
231
232
233
234
235 public String toString() {
236 return("total Count " + getTotalCount()
237 + "booleanCount " + getBooleanCount()
238 + "blankCount " + getBlankCount()
239 + "errorCount " + getErrorCount()
240 + "formulaCount " + getFormulaCount()
241 + "formulaSumCount " + getFormulaSumCount()
242 + "formulaComplexCount " + getFormulaComplexCount()
243 + "formulaMultiplicationCount " + getFormulaMultiplicationCount()
244 + "knownheaderCount " + getKnownheaderCount()
245 + "labelCount " + getLabelCount()
246 + "commentCount " + getCommentCount()
247 + "numericCount " + getNumericCount()
248 + "unknownheaderCount " + getUnknownheaderCount()
249 + "miscCount " + getMiscCount()
250 );
251 }
252
253
254
255
256 }
257