问题描述
我正在使用OrmSqlite数据库,想要在GenericRawResults rawResults中自动映射结果
String querString = "select * from ZADDRISKDETAILS where ZRISK_DEFINED_STATUS='" + status + "' AND ZPROJECTID ='" + projectID + "' AND ZRESPECTIVE_USERID ='" + userID + "' AND ZRISKDATETIME like '" + selectedYear + "%' ";
GenericRawResults<String[]> rawResults = mDBHelper.getRecommendationPinDetailsDao().queryRaw(querString);
List<String[]> results = rawResults.getResults();
for (int i = 0; i < results.size(); i++) {
ListModel model = new ListModel();
model.setDueDate(results.get(i)[2]);
model.setRiskCategory(results.get(i)[8]);
model.setRiskObservation(results.get(i)[14]);
model.setStatus(results.get(i)[11]);
model.setPriority(results.get(i)[19]);
model.setRiskRecommendation(results.get(i)[21]);
model.setIssuedDate(results.get(i)[10]);
}
我想将这些结果直接映射到映射模型类obj。 (例如ListModel.class),而不给出索引。 我认为RawRowMapper可以做到这一点,但不知道。
1楼
使用Dio映射模型类,
private Dao<News, Integer> newsDao = null;
public Dao<News, Integer> getNewsDao() {
if (null == this.newsDao) {
try {
this.newsDao = getDao(News.class);
} catch (java.sql.SQLException e) {
e.printStackTrace();
}
}
return this.newsDao;
}
public List<News> getAllNews() {
List<News> news = null;
try {
news = getHelper().getNewsDao().queryForAll();
} catch (SQLException e) {
e.printStackTrace();
}
return news;
}
它可以帮助您..