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; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.util.HashMap; import java.util.Map; import org.json.JSONObject; import at.alladin.rmbt.db.fields.Field; public abstract class Table { protected long uid; protected Connection conn = null; protected String errorLabel = ""; protected boolean error = false; protected final Field[] fields; private final Map<String, Field> keyMap = new HashMap<>(); public Table(final Field[] fields, final Connection conn) { this.fields = fields; this.conn = conn; reset(); generateKeyMap(); } public Table(final Field[] fields, final Connection conn, final ResultSet rs) throws SQLException { this(fields, conn); setValuesFromResult(rs); } protected void generateKeyMap() { keyMap.clear(); for (final Field field : fields) keyMap.put(field.getDbKey(), field); } public void reset() { for (final Field field : fields) field.clear(); uid = 0; resetError(); } protected void resetError() { error = false; errorLabel = ""; } protected void setError(final String errorLabel) { error = true; this.errorLabel = errorLabel; } protected void setValuesFromResult(final ResultSet rs) throws SQLException { uid = rs.getLong("uid"); for (final Field field : fields) field.setField(rs); } public boolean hasError() { return error; } public String getError() { return errorLabel; } public long getUid() { return uid; } /*********** * * SETTERS * ***********/ public void setFields(final JSONObject object) { for (final Field field : fields) field.setField(object); } public Field getField(final String key) { return keyMap.get(key); } }