@Override
public List<Module> getAllModule() {
// TODO Auto-generated method stub
String sqlStr =
"SELECT "
+ ID
+ ","
+ MODULE_NAME
+ ","
+ ENABLE
+ ","
+ PICTURE
+ ","
+ TARGET
+ " FROM "
+ TABLE_NAME;
List<Module> moduleList = new ArrayList<Module>();
SqlRowSet rs = jdbcTemplate.queryForRowSet(sqlStr);
while (rs.next()) {
Module module = new Module();
module.setEnable(rs.getInt(ENABLE));
module.setId(rs.getInt(ID));
module.setModuleName(rs.getString(MODULE_NAME));
module.setPicture(rs.getString(PICTURE));
module.setTarget(rs.getString(TARGET));
moduleList.add(module);
}
return moduleList;
}
