@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));
}
