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.JSONObject; public class StringField extends FieldAdapter<String> { private static final long serialVersionUID = 1L; public StringField(final String dbKey, final String jsonKey) { super(dbKey, jsonKey, false); } public StringField(final String dbKey, final String jsonKey, final boolean readOnly) { super(dbKey, jsonKey, readOnly); } @Override public void setString(final String string) { value = string; } @Override public void setField(final ResultSet rs) throws SQLException { value = rs.getString(dbKey); } @Override public void getField(final PreparedStatement ps, final int idx) throws SQLException { if (value == null) ps.setNull(idx, Types.VARCHAR); else ps.setString(idx, value); } @Override public void setField(final JSONObject obj) { if (jsonKey != null && obj.has(jsonKey)) value = obj.optString(jsonKey, null); } }