KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > net > mlw > vlh > adapter > jdbc > util > setter > DoubleSetter


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 JavaDoc;
24 import java.sql.SQLException JavaDoc;
25 import java.sql.Types JavaDoc;
26 import java.text.ParseException JavaDoc;
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 JavaDoc query, int index, Object JavaDoc value) throws SQLException JavaDoc, ParseException JavaDoc
39    {
40       if (value instanceof Double JavaDoc)
41       {
42          query.setDouble(index++, ((Double JavaDoc) value).doubleValue());
43       }
44       else if (value instanceof String JavaDoc)
45       {
46          double doubleValue = Double.parseDouble((String JavaDoc) 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 JavaDoc("Cannot convert value of class " + value.getClass().getName() + " to double at position "
56                + index);
57       }
58       return index;
59    }
60 }
Popular Tags