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