String sql = "SELECT optdate,pwdcreatetime FROM tb_user WHERE userid = '"+logininfo.getUserID()+"'";
ParameterizedRowMapper<User> map = new ParameterizedRowMapper<User>() {
@Override
public User mapRow(ResultSet rs, int rowNum)
throws SQLException {
User e = new User();
e.setOptdate(rs.getString(1));
e.setPwdcreatetime(rs.getString(2));
return e;
}
};
list = getSimpleJdbcTemplate().query(sql, map);
这是从数据库中查出来的值,我在后面该怎么得到这两个值呢??有没有什么好的方法啊
ParameterizedRowMapper<User> map = new ParameterizedRowMapper<User>() {
@Override
public User mapRow(ResultSet rs, int rowNum)
throws SQLException {
User e = new User();
e.setOptdate(rs.getString(1));
e.setPwdcreatetime(rs.getString(2));
return e;
}
};
list = getSimpleJdbcTemplate().query(sql, map);
这是从数据库中查出来的值,我在后面该怎么得到这两个值呢??有没有什么好的方法啊
String pt = "";
if (list != null && !list .isEmpty()) {
for (int i = 0; i < list .size(); i++) {
Map m = (Map) list .get(0);
op = m.get("optdate")
pt = m.get("pwdcreatetime ")
break;
}
} 关注Java
for (int i = 0; i <list.size(); i++) {
HashMap pp=(HashMap)list.get(i);
Iterator itr = pp.entrySet().iterator();
while(itr.hasNext()){
Map.Entry entry=(Entry) itr.next();
System.out.println(entry.getKey()+"--"+entry.getValue());
}
}