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; }
Data before = new Data(); before.setName("Joseph Wallflower"); before.setNameOperation(new UpperCaseStringOperation()); before.setEmail("Joseph.Wallflower@SomeCompany.com"); before.setEmailOperation(new LowerCaseStringOperation()); System.out.format("BEFORE: %s%n", before.toString()); Serializer serializer = new Persister(); File file = new File(System.getenv("USERPROFILE")+File.separator+"Documents"+File.separator+"simple.xml"); serializer.write(before, file);
Data data = new Data(); edittext = (EditText)findViewById(R.id.abc); data.setName(edittext.getText());
Data data = new Data(); data.setName("Tom"); Root root = new Root(); root.setData(data); ObjectMapper mapperWithMixIn = new ObjectMapper(); mapperWithMixIn.addMixInAnnotations(Root.class, RootMixIn.class); ObjectMapper mapperDefault = new ObjectMapper(); System.out.println("With MIX-IN"); System.out.println(mapperWithMixIn.writeValueAsString(root)); System.out.println("Default"); System.out.println(mapperDefault.writeValueAsString(root));
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; }
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 Data findProduct(String phone) { String query = "Select * FROM " + TABLE_FEEDBACK + " WHERE " + COLUMN_PHONENO + " = \"" + phone + "\""; System.out.println("this is the product >>>>>>>>>>>>>>>>>>>>>>>>>>>>>"); SQLiteDatabase db = this.getWritableDatabase(); Cursor cursor = db.rawQuery(query, null); Data data0 = new Data(); if (cursor.moveToFirst()) { cursor.moveToFirst(); data0.setPHONE(cursor.getString(0)); data0.setName(cursor.getString(1)); data0.setAddress(cursor.getString(6)); data0.setEmail(cursor.getString(7)); cursor.close(); } else { data0 = null; } System.out.println("data set value :>>>>>>>"); db.close(); return data0; }
data.setName(s);
Data data = new Data(); data.setId(resultSet.getLong("id")); data.setName(resultSet.getString("name")); data.setValue(resultSet.getInt("value")); list.add(data);
while (rs2.next()) { sports.setPlayerID(rs2.getInt("player_id")); sports.setName(rs2.getString("player_name")); sports.setSpeed(rs2.getDouble("sprint_speed"));
data.setName(reading);
data.setName(obj.getString("country")); data.setRank(obj.getString("rank")); data.setPopulation(obj.getString("population"));