PreparedStatement ps = connection.prepare("SOME SQL"); for (Data data : dataList) { ps.setInt(1, data.getId()); ps.setString(2, data.getValue(); ps.executeUpdate(); } ps.close();
class DataJsonSerializer extends JsonSerializer<Data> { @Override public void serialize(Data value, JsonGenerator jgen, SerializerProvider provider) throws IOException, JsonProcessingException { jgen.writeStartObject(); jgen.writeFieldName("id"); jgen.writeNumber(value.getId()); if (value.getValue() != Data.DEFAULT_VALUE) { jgen.writeFieldName("value"); jgen.writeNumber(value.getValue()); } jgen.writeEndObject(); } }
private static Map<Long, Data> mapData(ResultSet resultSet) throws SQLException { Map<Long, Data> map = new HashMap<Long, Data>(); while (resultSet.next()){ Data data = new Data(); data.setId(resultSet.getLong("id")); data.setCode(resultSet.getLong("code")); data.setType(resultSet.getString("type")); map.put(data.getId(), data); } return map; }
class ControllerIntentBuilder { public static Intent create(Content context, int requestCode, int resultCode, Intent resultIntent) { String contents = resultIntent.getStringExtra("SCAN_RESULT"); Data data = new Data(contents); String formatName = intent.getStringExtra("SCAN_RESULT_FORMAT"); if (data.Matrix(contents, formatName)) { Intent activityIntent = new Intent(context, ReportActivity.class); activityIntent.putExtra("IdValue", data.getId()); activityIntent.putExtra("PerfValue", data.getPerf()); activityIntent.putExtra("MpIdValue", data.getMpId()); return activityIntent; } // and so on for other conditions } }