View Javadoc
1   /*
2    * $Source$
3    * $Revision$
4    *
5    * Copyright (C) 2000 William Chesters
6    *
7    * Part of Melati (http://melati.org), a framework for the rapid
8    * development of clean, maintainable web applications.
9    *
10   * Melati is free software; Permission is granted to copy, distribute
11   * and/or modify this software under the terms either:
12   *
13   * a) the GNU General Public License as published by the Free Software
14   *    Foundation; either version 2 of the License, or (at your option)
15   *    any later version,
16   *
17   *    or
18   *
19   * b) any version of the Melati Software License, as published
20   *    at http://melati.org
21   *
22   * You should have received a copy of the GNU General Public License and
23   * the Melati Software License along with this program;
24   * if not, write to the Free Software Foundation, Inc.,
25   * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA to obtain the
26   * GNU General Public License and visit http://melati.org to obtain the
27   * Melati Software License.
28   *
29   * Feel free to contact the Developers of Melati (http://melati.org),
30   * if you would like to work out a different arrangement than the options
31   * outlined here.  It is our intention to allow Melati to be used by as
32   * wide an audience as possible.
33   *
34   * This program is distributed in the hope that it will be useful,
35   * but WITHOUT ANY WARRANTY; without even the implied warranty of
36   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
37   * GNU General Public License for more details.
38   *
39   * Contact details for copyright holder:
40   *
41   *     William Chesters <williamc At paneris.org>
42   *     http://paneris.org/~williamc
43   *     Obrechtstraat 114, 2517VX Den Haag, The Netherlands
44   */
45  
46  package org.melati.poem;
47  
48  import java.sql.PreparedStatement;
49  import java.sql.ResultSet;
50  import java.sql.SQLException;
51  import java.sql.Time;
52  import java.sql.Types;
53  import java.text.DateFormat;
54  import java.text.ParseException;
55  import java.text.SimpleDateFormat;
56  
57  import org.melati.poem.util.StringUtils;
58  
59  /**
60   * An SQL Time.
61   */
62  public class TimePoemType extends AtomPoemType<Time> {
63  
64    /** Simple date format. */
65    public static final DateFormat format =
66        new SimpleDateFormat("HH:mm:ss");
67  
68    /**
69     * Constructor.
70     * @param nullable whether nullable
71     */
72    public TimePoemType(boolean nullable) {
73      super(Types.TIME, "TIME", nullable);
74    }
75    
76   /**
77    * Constructor.
78    */
79    public TimePoemType(int sqlTypeCode, String sqlTypeName, boolean nullable) {
80      super(sqlTypeCode, sqlTypeName, nullable);
81    }
82  
83    protected void _assertValidRaw(Object raw) {
84      if (raw != null && !(raw instanceof Time))
85        throw new TypeMismatchPoemException(raw, this);
86    }
87  
88    protected Time _getRaw(ResultSet rs, int col) throws SQLException {
89      return rs.getTime(col);
90    }
91  
92    protected void _setRaw(PreparedStatement ps, int col, Object raw)
93        throws SQLException {
94      ps.setTime(col, (Time)raw);
95    }
96  
97    protected String _stringOfRaw(Object raw) {
98      return format.format((java.util.Date)raw);
99    }
100 
101   protected Time _rawOfString(String raw) {
102     try {
103       return new Time(format.parse(raw).getTime());
104     }
105     catch (ParseException e) {
106       try {
107         return Time.valueOf(raw);
108       } catch (IllegalArgumentException  e2) {
109         throw new ParsingPoemException(this, raw, e2);
110       }
111     }
112   }
113 
114   protected String _stringOfCooked(Object cooked,
115                                    PoemLocale locale, int style) {
116     return locale.timestampFormat(style).format((Time)cooked);
117   }
118 
119   protected boolean _canRepresent(SQLPoemType<?> other) {
120     return other instanceof TimePoemType;
121   }
122 
123   /**
124    * {@inheritDoc}
125    * @see org.melati.poem.PoemType#toDsdType()
126    */
127   public String toDsdType() {
128     return "Time";
129   }
130 
131   protected void _saveColumnInfo(ColumnInfo columnInfo)
132       throws AccessPoemException {
133     columnInfo.setTypefactory(PoemTypeFactory.TIME);
134   }
135 
136   protected String _quotedRaw(Object raw) {
137     return StringUtils.quoted(_stringOfRaw(raw), '\'');
138   }
139   
140 }