public List<Data> list() throws SQLException { List<Data> list = new ArrayList<Data>(); try ( Connection connection = database.getConnection(); Statement statement = connection.createStatement("SELECT id, name, value FROM data"); ResultSet resultSet = statement.executeQuery(); ) { while (resultSet.next()) { list.add(map(resultSet)); } } return list; } private Data map(ResultSet resultSet) throws SQLException { Data data = new Data(); data.setId(resultSet.getLong("id")); data.setName(resultSet.getString("name")); data.setValue(resultSet.getInteger("value")); return data; }
public List<Data> list() throws SQLException { Connection connection = null; PreparedStatement statement = null; ResultSet resultSet = null; List<Data> list = new ArrayList<Data>(); try { connection = database.getConnection(); statement = connection.prepareStatement("SELECT id, name, value FROM data"); resultSet = statement.executeQuery(); while (resultSet.next()) { Data data = new Data(); data.setId(resultSet.getLong("id")); data.setName(resultSet.getString("name")); data.setValue(resultSet.getInt("value")); list.add(data); } } finally { if (resultSet != null) try { resultSet.close(); } catch (SQLException logOrIgnore) {} if (statement != null) try { statement.close(); } catch (SQLException logOrIgnore) {} if (connection != null) try { connection.close(); } catch (SQLException logOrIgnore) {} } return list; }
Data data = new Data(); data.setId(index); data.setValue(index < 6 ? Data.DEFAULT_VALUE : index); datas.add(data);
final Data data = new Data(); for (int i = 0; i < numberOfThreads; i++) { final Thread thread = new Thread(new Runnable() { @Override public void run() { synchronized (data){ final int value = data.getValue(); } synchronized (data){ data.setValue(value + 1); } } }); thread.start(); }
public Data loadDatas(String url) { final Data data = new Data(); client.post(url, new JsonHttpResponseHandler() { @Override public void onSuccess(int statusCode, Header[] headers, JSONObject response) { super.onSuccess(statusCode, headers, response); try { int st = response.getInt("st"); int timest = response.getInt("t"); Date dateTime = new Date(timest); String dateString = (String) DateFormat.format("dd:MM:yyyy \t\t hh:mm:ss", dateTime); double val = response.getDouble("v"); data.setDate(dateString); data.setValue(val); data.setState(st); } catch (JSONException e) { e.printStackTrace(); } } }); return data; }
data.setId(resultSet.getLong("id")); data.setName(resultSet.getString("name")); data.setValue(resultSet.getInt("value")); list.add(data);