StringBuffer sb = new StringBuffer("select a.user_id userId,a.login_name,a.name name from cs_user a where a.login_name='").append(loginName).append("'");
CsUser csUser = jdbcTemplate.queryForObject(sb.toString(), new BeanPropertyRowMapper<CsUser>(CsUser.class));
return csUser;
獲取list
實體類實現(xiàn)RowMapper接口(也可不實現(xiàn))
示例如下龟再，只貼出增加代碼：
@Override
public CsOrgan mapRow(ResultSet resultSet, int i) throws SQLException {
CsOrgan csOrgan = new CsOrgan();
csOrgan.setId(resultSet.getString("id"));
csOrgan.setOrgId(resultSet.getString("orgId"));
csOrgan.setOrgCode(resultSet.getString("orgCode"));
csOrgan.setOrgType(resultSet.getString("orgType"));
csOrgan.setOrgLevel(resultSet.getInt("orgLevel"));
csOrgan.setOrgName(resultSet.getString("orgName"));
csOrgan.setProvince(resultSet.getString("province"));
csOrgan.setCity(resultSet.getString("city"));
csOrgan.setArea(resultSet.getString("area"));
return csOrgan;
}
使用query方法
如果實體類實現(xiàn)了RowMapper接口忙厌，可用以下方法:
List<CsOrgan> list = null;
StringBuffer sb = new StringBuffer("select w.*")
.append(" from cs_user_organnode a left join wdim_info w on a.ORGAN_NODE_ID = w.id ")
.append("where a.SECURITY_USER_ID='").append(userId).append("'");
list = jdbcTemplate.query(sb.toString(),new CsOrgan());
如果實體類沒有實現(xiàn)RowMapper接口豫喧，可用以下方法：
List<CsOrgan> list = null;
StringBuffer sb = new StringBuffer("select w.*")
.append(" from cs_user_organnode a left join wdim_info w on a.ORGAN_NODE_ID = w.id ")
.append("where a.SECURITY_USER_ID='").append(userId).append("'");
list = jdbcTemplate.query(sb.toString(),new BeanPropertyRowMapper<CsOrgan>(CsOrgan.class));
