Mercurial Hosting > nabble
diff src/fschmidt/db/DbNull.java @ 68:00520880ad02
add fschmidt source
author | Franklin Schmidt <fschmidt@gmail.com> |
---|---|
date | Sun, 05 Oct 2025 17:24:15 -0600 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/fschmidt/db/DbNull.java Sun Oct 05 17:24:15 2025 -0600 @@ -0,0 +1,63 @@ +/* +Copyright (c) 2008 Franklin Schmidt <fschmidt@gmail.com> + +Permission is hereby granted, free of charge, to any person obtaining a copy +of this software and associated documentation files (the "Software"), to deal +in the Software without restriction, including without limitation the rights +to use, copy, modify, merge, publish, distribute, sublicense, and/or sell +copies of the Software, and to permit persons to whom the Software is +furnished to do so, subject to the following conditions: + +The above copyright notice and this permission notice shall be included in +all copies or substantial portions of the Software. + +THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR +IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, +FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE +AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER +LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, +OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN +THE SOFTWARE. +*/ + +package fschmidt.db; + +import java.util.Date; +import java.sql.PreparedStatement; +import java.sql.SQLException; +import java.sql.Types; + + +public final class DbNull implements DbStorable { + public final int sqlType; + + public DbNull(int sqlType) { + this.sqlType = sqlType; + } + + public void setField(PreparedStatement stmt,int idx) throws SQLException { + stmt.setNull(idx,sqlType); + } + + public static final DbNull BOOLEAN = new DbNull(Types.BOOLEAN); + public static final DbNull STRING = new DbNull(Types.VARCHAR); + public static final DbNull TIMESTAMP = new DbNull(Types.TIMESTAMP); + public static final DbNull INTEGER = new DbNull(Types.INTEGER); + public static final DbNull FLOAT = new DbNull(Types.FLOAT); + + public static Object fix(boolean b) { + return b ? Boolean.TRUE : BOOLEAN; + } + public static Object fix(Boolean b) { + return b!=null ? b : BOOLEAN; + } + public static Object fix(String s) { + return s!=null ? s : STRING; + } + public static Object fix(Date date) { + return date!=null ? date : TIMESTAMP; + } + public static Object fix(int i) { + return i!=0 ? Integer.valueOf(i) : INTEGER; + } +}