Question

请教spring 2.5中的jdbctemplate.query传入参数的问题

Answer 1

参考下面的代码：<pre t="code" l="java">public Dept getById(String dept_id) {
String sql="select DEPT_ID as dept_id, DEPT_NAME as dept_name, DEPT_FATH_ID as dept_fath_id, DEPT_LEVEL as dept_level from M_DEPT where DEPT_ID=?";
Object[] obj=new Object[1];
Integer temp_id = Integer.parseInt(dept_id);
obj[0]=temp_id ;
List<Dept> deptList = this.getJdbcTemplate().query(sql,obj,new BeanPropertyRowMapper(Dept.class));
if(!deptList.isEmpty()) {
return deptList.iterator().next();
}else {
return null;
}
}