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.Timestamp;
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 * A Timestamp.
61 */
62 public class TimestampPoemType extends AtomPoemType<Timestamp> {
63
64 /** Simple date format. */
65 public static final DateFormat format =
66 new SimpleDateFormat("dd/MM/yyyy HH:mm:ss");
67
68 /**
69 * Constructor.
70 * @param nullable whether nullable
71 */
72 public TimestampPoemType(boolean nullable) {
73 super(Types.TIMESTAMP, "TIMESTAMP", nullable);
74 }
75
76 /**
77 * Constructor.
78 * @see org.melati.poem.dbms.SQLServer
79 */
80 public TimestampPoemType(int sqlTypeCode, String sqlTypeName, boolean nullable) {
81 super(sqlTypeCode, sqlTypeName, nullable);
82 }
83
84 protected void _assertValidRaw(Object raw) {
85 if (raw != null && !(raw instanceof Timestamp))
86 throw new TypeMismatchPoemException(raw, this);
87 }
88
89 protected Timestamp _getRaw(ResultSet rs, int col) throws SQLException {
90 return rs.getTimestamp(col);
91 }
92
93 protected void _setRaw(PreparedStatement ps, int col, Object raw)
94 throws SQLException {
95 ps.setTimestamp(col, (Timestamp)raw);
96 }
97
98 protected String _stringOfRaw(Object raw) {
99 return format.format((java.util.Date)raw);
100 }
101
102 protected Timestamp _rawOfString(String raw) {
103 try {
104 return new Timestamp(format.parse(raw).getTime());
105 }
106 catch (ParseException e) {
107 try {
108 return Timestamp.valueOf(raw);
109 } catch (IllegalArgumentException e2) {
110 throw new ParsingPoemException(this, raw, e2);
111 }
112 }
113 }
114
115 protected String _stringOfCooked(Object cooked,
116 PoemLocale locale, int style) {
117 return locale.timestampFormat(style).format((Timestamp)cooked);
118 }
119
120 protected boolean _canRepresent(SQLPoemType<?> other) {
121 return other instanceof TimestampPoemType;
122 }
123
124 /**
125 * {@inheritDoc}
126 * @see org.melati.poem.PoemType#toDsdType()
127 */
128 public String toDsdType() {
129 return "Timestamp";
130 }
131
132 protected void _saveColumnInfo(ColumnInfo columnInfo)
133 throws AccessPoemException {
134 columnInfo.setTypefactory(PoemTypeFactory.TIMESTAMP);
135 }
136
137 protected String _quotedRaw(Object raw) {
138 return StringUtils.quoted(_stringOfRaw(raw), '\'');
139 }
140
141 }