1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
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
61
62 public class TimestampPoemType extends AtomPoemType<Timestamp> {
63
64
65 public static final DateFormat format =
66 new SimpleDateFormat("dd/MM/yyyy HH:mm:ss");
67
68
69
70
71
72 public TimestampPoemType(boolean nullable) {
73 super(Types.TIMESTAMP, "TIMESTAMP", nullable);
74 }
75
76
77
78
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
126
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 }