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 }