@Override public void delete(Domain<String> domain) { Country country = (Country) domain; MySqlUtil.getInstance() .delete( "DELETE FROM " + TABLE_NAME + " WHERE code=?", new Param[] {new Param(country.getId(), Types.VARCHAR)}); }
@Override public void insert(Domain<String> domain) { Country country = (Country) domain; String query = "INSERT INTO " + TABLE_NAME + "(code, text) VALUES(?, ?)"; Param[] params = new Param[] { new Param(country.getId(), Types.VARCHAR), new Param(country.getText(), Types.VARCHAR) }; MySqlUtil.getInstance().insert(query, params); }
@Override public Country select(String id) { Country country = new Country(); String query = "SELECT * FROM " + TABLE_NAME + " WHERE code=?"; Param[] params = new Param[] {new Param(id, Types.VARCHAR)}; Map<String, Object> row = MySqlUtil.getInstance().selectRow(query, params); country.setId(id); country.setText((String) row.get("text")); return country; }
@Override public int count() { return MySqlUtil.getInstance().count(TABLE_NAME); }
@Override public boolean exists(String id) { return MySqlUtil.getInstance().exists(TABLE_NAME, "code", new Param(id, Types.VARCHAR)); }
@Override public boolean exists(Domain<String> domain) { Country country = (Country) domain; return MySqlUtil.getInstance() .exists(TABLE_NAME, "text", new Param(country.getText(), Types.VARCHAR)); }