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@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.Types;
49 import java.sql.Date;
50 import java.sql.ResultSet;
51 import java.sql.PreparedStatement;
52 import java.sql.SQLException;
53
54 /**
55 * A type for Normal dates.
56 */
57 public class DatePoemType extends AtomPoemType<Date> {
58
59 /**
60 * Constructor.
61 *
62 * @param nullable whether this type may contain <code>null</code>.
63 */
64 public DatePoemType(boolean nullable) {
65 super(Types.DATE, "DATE", nullable);
66 }
67
68 public DatePoemType(int sqlTypeCode, String sqlTypeName, boolean nullable) {
69 super(sqlTypeCode, sqlTypeName, nullable);
70 }
71
72 protected void _assertValidRaw(Object raw) {
73 if (raw != null && !(raw instanceof Date))
74 throw new TypeMismatchPoemException(raw, this);
75 }
76
77 protected Date _getRaw(ResultSet rs, int col) throws SQLException {
78 return rs.getDate(col);
79 }
80
81 protected void _setRaw(PreparedStatement ps, int col, Object raw)
82 throws SQLException {
83 ps.setDate(col, (Date)raw);
84 }
85
86 /**
87 * HACK reformat DDMMYYYY dates to YYYY-MM-DD
88 * @see org.melati.poem.BasePoemType#_rawOfString(java.lang.String)
89 */
90 protected Date _rawOfString(String raw) {
91 if (raw.length() == 8)
92 return Date.valueOf(raw.substring(4,8)+ "-" +
93 raw.substring(2,4) + "-" +
94 raw.substring(0,2));
95 return Date.valueOf(raw);
96 }
97
98 protected String _stringOfCooked(Object cooked,
99 PoemLocale locale, int style) {
100 return locale.dateFormat(style).format((Date)cooked);
101 }
102
103 protected boolean _canRepresent(SQLPoemType<?> other) {
104 return other instanceof DatePoemType;
105 }
106
107 /**
108 * The field type used in the Data Structure Definition language.
109 * {@inheritDoc}
110 * @see org.melati.poem.PoemType#toDsdType()
111 */
112 public String toDsdType() {
113 return "Date";
114 }
115
116 protected void _saveColumnInfo(ColumnInfo columnInfo)
117 throws AccessPoemException {
118 columnInfo.setTypefactory(PoemTypeFactory.DATE);
119 }
120 }