01: /*
02: *
03: * The DbUnit Database Testing Framework
04: * Copyright (C)2002-2004, DbUnit.org
05: *
06: * This library is free software; you can redistribute it and/or
07: * modify it under the terms of the GNU Lesser General Public
08: * License as published by the Free Software Foundation; either
09: * version 2.1 of the License, or (at your option) any later version.
10: *
11: * This library is distributed in the hope that it will be useful,
12: * but WITHOUT ANY WARRANTY; without even the implied warranty of
13: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
14: * Lesser General Public License for more details.
15: *
16: * You should have received a copy of the GNU Lesser General Public
17: * License along with this library; if not, write to the Free Software
18: * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
19: *
20: */
21:
22: package org.dbunit.dataset.datatype;
23:
24: import org.slf4j.Logger;
25: import org.slf4j.LoggerFactory;
26:
27: import org.dbunit.dataset.ITable;
28:
29: import java.math.BigDecimal;
30: import java.sql.PreparedStatement;
31: import java.sql.ResultSet;
32: import java.sql.SQLException;
33:
34: /**
35: * @author Manuel Laflamme
36: * @version $Revision: 554 $
37: */
38: public class IntegerDataType extends AbstractDataType {
39:
40: /**
41: * Logger for this class
42: */
43: private static final Logger logger = LoggerFactory
44: .getLogger(IntegerDataType.class);
45:
46: IntegerDataType(String name, int sqlType) {
47: super (name, sqlType, Integer.class, true);
48: }
49:
50: ////////////////////////////////////////////////////////////////////////////
51: // DataType class
52:
53: public Object typeCast(Object value) throws TypeCastException {
54: logger.debug("typeCast(value=" + value + ") - start");
55:
56: if (value == null || value == ITable.NO_VALUE) {
57: return null;
58: }
59:
60: if (value instanceof Number) {
61: return new Integer(((Number) value).intValue());
62: }
63:
64: try {
65: return typeCast(new BigDecimal(value.toString()));
66: } catch (java.lang.NumberFormatException e) {
67: logger.error("typeCast()", e);
68:
69: throw new TypeCastException(value, this , e);
70: }
71: }
72:
73: public Object getSqlValue(int column, ResultSet resultSet)
74: throws SQLException, TypeCastException {
75: logger.debug("getSqlValue(column=" + column + ", resultSet="
76: + resultSet + ") - start");
77:
78: int value = resultSet.getInt(column);
79: if (resultSet.wasNull()) {
80: return null;
81: }
82: return new Integer(value);
83: }
84:
85: public void setSqlValue(Object value, int column,
86: PreparedStatement statement) throws SQLException,
87: TypeCastException {
88: logger.debug("setSqlValue(value=" + value + ", column="
89: + column + ", statement=" + statement + ") - start");
90:
91: statement
92: .setInt(column, ((Integer) typeCast(value)).intValue());
93: }
94: }
|