Java tutorial
/******************************************************************************* * Copyright 2013-2014 alladin-IT GmbH * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. ******************************************************************************/ package at.alladin.rmbt.db.fields; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Types; import org.json.JSONException; import org.json.JSONObject; public class BooleanField extends FieldAdapter<Boolean> { private static final long serialVersionUID = 1L; public BooleanField(final String dbKey, final String jsonKey) { super(dbKey, jsonKey, false); } public BooleanField(final String dbKey, final String jsonKey, final boolean readOnly) { super(dbKey, jsonKey, readOnly); } @Override public void setField(final ResultSet rs) throws SQLException { value = rs.getBoolean(dbKey); if (rs.wasNull()) value = null; } @Override public void getField(final PreparedStatement ps, final int idx) throws SQLException { if (value == null) ps.setNull(idx, Types.BOOLEAN); else ps.setBoolean(idx, value); } @Override public void setField(final JSONObject obj) { if (jsonKey != null && obj.has(jsonKey)) try { value = obj.getBoolean(jsonKey); } catch (final JSONException e) { value = null; } } @Override public void setString(final String string) { value = Boolean.parseBoolean(string); } }