|
68
|
1 /*
|
|
|
2 Copyright (c) 2008 Franklin Schmidt <fschmidt@gmail.com>
|
|
|
3
|
|
|
4 Permission is hereby granted, free of charge, to any person obtaining a copy
|
|
|
5 of this software and associated documentation files (the "Software"), to deal
|
|
|
6 in the Software without restriction, including without limitation the rights
|
|
|
7 to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
|
|
|
8 copies of the Software, and to permit persons to whom the Software is
|
|
|
9 furnished to do so, subject to the following conditions:
|
|
|
10
|
|
|
11 The above copyright notice and this permission notice shall be included in
|
|
|
12 all copies or substantial portions of the Software.
|
|
|
13
|
|
|
14 THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
|
|
|
15 IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
|
|
|
16 FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
|
|
|
17 AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
|
|
|
18 LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
|
|
|
19 OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
|
|
|
20 THE SOFTWARE.
|
|
|
21 */
|
|
|
22
|
|
|
23 package fschmidt.db;
|
|
|
24
|
|
|
25 import java.util.Date;
|
|
|
26 import java.sql.PreparedStatement;
|
|
|
27 import java.sql.SQLException;
|
|
|
28 import java.sql.Types;
|
|
|
29
|
|
|
30
|
|
|
31 public final class DbNull implements DbStorable {
|
|
|
32 public final int sqlType;
|
|
|
33
|
|
|
34 public DbNull(int sqlType) {
|
|
|
35 this.sqlType = sqlType;
|
|
|
36 }
|
|
|
37
|
|
|
38 public void setField(PreparedStatement stmt,int idx) throws SQLException {
|
|
|
39 stmt.setNull(idx,sqlType);
|
|
|
40 }
|
|
|
41
|
|
|
42 public static final DbNull BOOLEAN = new DbNull(Types.BOOLEAN);
|
|
|
43 public static final DbNull STRING = new DbNull(Types.VARCHAR);
|
|
|
44 public static final DbNull TIMESTAMP = new DbNull(Types.TIMESTAMP);
|
|
|
45 public static final DbNull INTEGER = new DbNull(Types.INTEGER);
|
|
|
46 public static final DbNull FLOAT = new DbNull(Types.FLOAT);
|
|
|
47
|
|
|
48 public static Object fix(boolean b) {
|
|
|
49 return b ? Boolean.TRUE : BOOLEAN;
|
|
|
50 }
|
|
|
51 public static Object fix(Boolean b) {
|
|
|
52 return b!=null ? b : BOOLEAN;
|
|
|
53 }
|
|
|
54 public static Object fix(String s) {
|
|
|
55 return s!=null ? s : STRING;
|
|
|
56 }
|
|
|
57 public static Object fix(Date date) {
|
|
|
58 return date!=null ? date : TIMESTAMP;
|
|
|
59 }
|
|
|
60 public static Object fix(int i) {
|
|
|
61 return i!=0 ? Integer.valueOf(i) : INTEGER;
|
|
|
62 }
|
|
|
63 }
|
