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