我正在尝试将此SQL命令与Ormlite一起使用:
select address from receive
使用此代码:
List<Receivers> receiver_address = receiverDao.queryBuilder().selectColumns("address").query();
但是返回的对象是:
1 = {Receivers@830028192208}
address = {String@830028192264} "my new address"
city = null
email = null
telephone = null
mobile = null
name_family = null
national_code = null
postal_code = null
receiver_name = null
id = 2
在此查询中,我只需要
address
字段,而无需iterator
,例如:List<String> list = new ArrayList<String>();
for( Receivers lst:receiver_address)
list.add(lst.getAddress());
该怎么做?
最佳答案
您可以在此处使用RawRowMapper:
List<String> addresses = receiverDao.queryRaw("select address from receive", new RawRowMapper<String>() {
@Override
public String mapRow(String[] columnNames, String[] resultColumns) throws SQLException {
return resultColumns[0];
}
}).getResults();