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>Double</code> on a query. Conversion from a string is provided using <code>Double.parseDouble()</code>.
29 *
30 * @author Matthew L. Wilson
31 * @version $Revision: 1.4 $ $Date: 2005/12/19 10:58:01 $
32 */
33 public class DoubleSetter extends AbstractSetter
34 {
35 /***
36 * @see net.mlw.vlh.adapter.jdbc.util.Setter#set(java.sql.PreparedStatement, int, java.lang.Object)
37 */
38 public int set(PreparedStatement query, int index, Object value) throws SQLException, ParseException
39 {
40 if (value instanceof Double)
41 {
42 query.setDouble(index++, ((Double) value).doubleValue());
43 }
44 else if (value instanceof String)
45 {
46 double doubleValue = Double.parseDouble((String) value);
47 query.setDouble(index++, doubleValue);
48 }
49 else if (value == null)
50 {
51 query.setNull(index++, Types.DOUBLE);
52 }
53 else
54 {
55 throw new IllegalArgumentException("Cannot convert value of class " + value.getClass().getName() + " to double at position "
56 + index);
57 }
58 return index;
59 }
60 }