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@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 }