View Javadoc
1   /*
2    * Copyright 2004-2025 the original author or authors.
3    *
4    * Licensed under the Apache License, Version 2.0 (the "License");
5    * you may not use this file except in compliance with the License.
6    * You may obtain a copy of the License at
7    *
8    *    https://www.apache.org/licenses/LICENSE-2.0
9    *
10   * Unless required by applicable law or agreed to in writing, software
11   * distributed under the License is distributed on an "AS IS" BASIS,
12   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13   * See the License for the specific language governing permissions and
14   * limitations under the License.
15   */
16  package com.ibatis.sqlmap.engine.type;
17  
18  import java.sql.CallableStatement;
19  import java.sql.PreparedStatement;
20  import java.sql.ResultSet;
21  import java.sql.SQLException;
22  import java.util.Date;
23  
24  /**
25   * Date (and time) implementation of TypeHandler.
26   */
27  public class DateTypeHandler extends BaseTypeHandler implements TypeHandler {
28  
29    /** The Constant DATE_FORMAT. */
30    private static final String DATE_FORMAT = "yyyy/MM/dd hh:mm:ss";
31  
32    @Override
33    public void setParameter(PreparedStatement ps, int i, Object parameter, String jdbcType) throws SQLException {
34      ps.setTimestamp(i, new java.sql.Timestamp(((Date) parameter).getTime()));
35    }
36  
37    @Override
38    public Object getResult(ResultSet rs, String columnName) throws SQLException {
39      java.sql.Timestamp sqlTimestamp = rs.getTimestamp(columnName);
40      if (rs.wasNull()) {
41        return null;
42      }
43      return new java.util.Date(sqlTimestamp.getTime());
44    }
45  
46    @Override
47    public Object getResult(ResultSet rs, int columnIndex) throws SQLException {
48      java.sql.Timestamp sqlTimestamp = rs.getTimestamp(columnIndex);
49      if (rs.wasNull()) {
50        return null;
51      }
52      return new java.util.Date(sqlTimestamp.getTime());
53    }
54  
55    @Override
56    public Object getResult(CallableStatement cs, int columnIndex) throws SQLException {
57      java.sql.Timestamp sqlTimestamp = cs.getTimestamp(columnIndex);
58      if (cs.wasNull()) {
59        return null;
60      }
61      return new java.util.Date(sqlTimestamp.getTime());
62    }
63  
64    @Override
65    public Object valueOf(String s) {
66      return SimpleDateFormatter.format(DATE_FORMAT, s);
67    }
68  
69  }