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; }
List<Data> result = new ArrayList<Data>(); while (rs.next()) { Data data = new Data(); data.setId(rs.getString(0)); // .. }
private static List<Data> listData(ResultSet resultSet) throws SQLException { List<Data> list = new ArrayList<Data>(); while (resultSet.next()){ Data data = new Data(); data.setId(resultSet.getLong("id")); data.setCode(resultSet.getLong("code")); data.setType(resultSet.getString("type")); list.add(data); } return list; }
public List<Data> getAllLabels(){ List<Data> lstData = new ArrayList<Data>(); // Select All Query String selectQuery = "SELECT * FROM " + Facibilities; SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor = db.rawQuery(selectQuery, null); // looping through all rows and adding to list if (cursor.moveToFirst()) { Data data = new Data(); do { data .setId(add(cursor.getString(1))) data .setLabel(add(cursor.getString(2))); lstData.add(data); } while (cursor.moveToNext()); } // closing connection cursor.close(); db.close(); // returning data object with id and labels return lstData;}
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; }
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; }
public ArrayList<Data> retrieveData(){ ArrayList<Data> al = new ArrayList<>(); SQLiteDatabase db = getWritableDatabase(); String query = "SELECT * FROM "+TABLE_NAME+";"; Cursor c = db.rawQuery(query,null); c.moveToFirst(); while(!c.isAfterLast()){ if(c.getString(c.getColumnIndex("id"))!=null){ Data dt = new Data(); dt.setId(c.getString(c.getColumnIndex("id"))); dt.setName(c.getString(c.getColumnIndex("name"))); dt.setEmail(c.getString(c.getColumnIndex("email"))); dt.setPhno(c.getString(c.getColumnIndex("phno"))); al.add(dt); } c.moveToNext(); } db.close(); return al; }
for (int index = 0; index < 10; index++) { Data data = new Data(); data.setId(index); data.setValue(index < 6 ? Data.DEFAULT_VALUE : index); datas.add(data);
JSONObject jobj = jArray.getJSONObject(i); Data data = new Data(); data.setId(jobj.getInt("id")); data.setHeading(jobj.getString("heading")); data.setBrief(jobj.getString("brief"));
while (resultSet.next()) { Data data = new Data(); data.setId(resultSet.getLong("id")); data.setName(resultSet.getString("name")); data.setValue(resultSet.getInt("value"));
data.setId(Integer.parseInt(reading));
JSONObject jobj = jArray.getJSONObject(i); Data data = new Data(); data.setId(jobj.getInt("id")); data.setHeading(jobj.getString("heading")); data.setBrief(jobj.getString("brief"));