1 /***
2 * Copyright (c) 2003 held jointly by the individual authors.
3 *
4 * This library is free software; you can redistribute it and/or modify it
5 * under the terms of the GNU Lesser General Public License as published
6 * by the Free Software Foundation; either version 2.1 of the License, or
7 * (at your option) any later version.
8 *
9 * This library is distributed in the hope that it will be useful, but
10 * WITHOUT ANY WARRANTY; with out even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU Lesser General Public License for more details.
13 *
14 * You should have received a copy of the GNU Lesser General Public License
15 * along with this library; if not, write to the Free Software Foundation,
16 * Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
17 *
18 * > http://www.gnu.org/copyleft/lesser.html
19 * > http://www.opensource.org/licenses/lgpl-license.php
20 */
21 package net.mlw.vlh.adapter.jdbc.util.setter;
22
23 import java.sql.PreparedStatement;
24 import java.sql.SQLException;
25 import java.sql.Types;
26 import java.text.ParseException;
27
28 /*** Sets a <code>java.sql.Types.INTEGER</code> on a query using <code>PreparedStatement.setInt()</code>.
29 * Conversion is provided from <code>java.lang.Integer</code>. Conversion from a string is provided using <code>Integer.parseInt()</code>.
30 *
31 * @see PreparedStatement#setInt(int, int)
32 *
33 * @author Matthew L. Wilson
34 * @version $Revision: 1.4 $ $Date: 2005/12/19 10:58:01 $
35 */
36 public class IntegerSetter extends AbstractSetter
37 {
38 /***
39 * @see net.mlw.vlh.adapter.jdbc.util.Setter#set(java.sql.PreparedStatement, int, java.lang.Object)
40 */
41 public int set(PreparedStatement query, int index, Object value) throws SQLException, ParseException
42 {
43 if (value instanceof Integer)
44 {
45 query.setInt(index++, ((Integer) value).intValue());
46 }
47 else if (value instanceof String)
48 {
49 int intValue = Integer.parseInt((String) value);
50 query.setInt(index++, intValue);
51 }
52 else if (value == null)
53 {
54 query.setNull(index++, Types.INTEGER);
55 }
56 else
57 {
58 throw new IllegalArgumentException("Cannot convert value of class " + value.getClass().getName() + " to int at position " + index);
59 }
60 return index;
61 }
62 }