1 | public class NumericBooleanType extends BooleanType {↵ | | 1 | public class NumericTrueFalseType extends BooleanType {↵
|
|
2 | /**↵ | | |
|
3 | * {@inheritDoc}↵ | | |
|
4 | * <p/>↵ | | |
|
5 | * This type's name is <tt>numeric_boolean</tt>↵ | | |
|
6 | */↵ | | |
|
7 | public String getName() {↵ | | |
|
8 | return "numeric_boolean";↵ | | |
|
9 | }↵ | | |
|
|
10 | /**↵ | | |
|
11 | * {@inheritDoc}↵ | | |
|
12 | */↵ | | |
|
| | | 2 |
↵
|
13 | public Object get(ResultSet rs, String name) throws SQLException {↵ | | 3 | public Object get(ResultSet rs, String name) throws SQLException {
↵
|
14 | int value = rs.getInt( name );↵ | | 4 | int value = rs.getInt( name );
↵
|
15 | if ( rs.wasNull() ) {↵ | | 5 | if ( rs.wasNull() ) {
↵
|
16 | return getDefaultValue();↵ | | 6 | return getDefaultValue();
↵
|
17 | }↵ | | 7 | }
↵
|
18 | else if ( value == 0 ) {↵ | | 8 | else if ( value == 0 ) {
↵
|
19 | return Boolean.FALSE;↵ | | 9 | return Boolean.FALSE;
↵
|
20 | }↵ | | 10 | }
↵
|
21 | else {↵ | | 11 | else {
↵
|
22 | return Boolean.TRUE;↵ | | 12 | return Boolean.TRUE;
↵
|
23 | }↵ | | 13 | }
↵
|
24 | }↵ | | 14 | }↵
|
|
25 | /**↵ | | |
|
26 | * {@inheritDoc}↵ | | |
|
27 | */↵ | | |
|
| | | 15 |
↵
|
28 | public void set(PreparedStatement st, Object value, int index) throws SQLException {↵ | | 16 | public void set(PreparedStatement st, Object value, int index) throws SQLException {
↵
|
29 | if ( value == null ) {↵ | | 17 | if ( value == null ) {
↵
|
30 | st.setNull( index, Types.INTEGER );↵ | | 18 | st.setNull( index, Types.INTEGER );
↵
|
31 | }↵ | | 19 | }
↵
|
32 | else {↵ | | 20 | else {
↵
|
33 | boolean bool = ( ( Boolean ) value ).booleanValue();↵ | | 21 | boolean bool = ( ( Boolean ) value ).booleanValue();
↵
|
34 | st.setInt( index, bool ? 1 : 0 );↵ | | 22 | st.setInt( index, bool ? 1 : 0 );
↵
|
35 | }↵ | | 23 | }
↵
|
36 | }↵ | | 24 | }↵
|
|
37 | /**↵ | | |
|
38 | * {@inheritDoc}↵ | | |
|
39 | */↵ | | |
|
| | | 25 |
↵
|
40 | public String objectToSQLString(Object value, Dialect dialect) throws Exception {↵ | | 26 | public String objectToSQLString(Object value, Dialect dialect) throws Exception {
↵
|
41 | return ( ( Boolean ) value ).booleanValue() ? "1" : "0";↵ | | 27 | return ( ( Boolean ) value ).booleanValue() ? "1" : "0";↵
|
42 | }↵ | | |
|
|
43 | /**↵ | | |
|
44 | * {@inheritDoc}↵ | | |
|
45 | */↵ | | |
|
| | | 28 | }↵
|
| | | 29 |
↵
|
46 | public int sqlType() {↵ | | 30 | public int sqlType() {
↵
|
47 | return Types.INTEGER;↵ | | 31 | return Types.INTEGER;↵
|
| | | 32 | }↵
|
|
| | | 33 | public String getName() {↵
|
| | | 34 | return "numeric_boolean";
↵
|
48 | | | 35 |
|