View Javadoc

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.BIGINT</code> on a query using <code>PreparedStatement.setLong()</code>.
29   * Conversion is provided from <code>java.lang.Long</code>. Conversion from a string is provided using method <code>Long.parseLong()</code>.
30   * 
31   * @see PreparedStatement#setLong(int, long)
32   * 
33   * @author Matthew L. Wilson
34   * @version $Revision: 1.3 $ $Date: 2005/12/19 10:58:01 $
35   */
36  public class LongSetter 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 Long)
44        {
45           query.setLong(index++, ((Long) value).longValue());
46        }
47        else if (value instanceof String)
48        {
49           long longValue = Long.parseLong((String) value);
50           query.setLong(index++, longValue);
51        }
52        else if (value == null)
53        {
54           query.setNull(index++, Types.BIGINT);
55        }
56        else
57        {
58           throw new IllegalArgumentException("Cannot convert value of class " + value.getClass().getName() + " to long at position " + index);
59        }
60        return index;
61     }
62  }