public List<Customer> findAssociatiedAll(Integer decidedzone_id) {
// TODO Auto-generated method stub
String sql = "select * from t_customer where decidedzone_id = ?";
List<Customer> list = jdbcTemplate.query(sql, new RowMapper<Customer>(){
@Override
public Customer mapRow(ResultSet rs, int arg1) throws SQLException {
//这里的rs就是执行sql后返回结果,就是把customer封装到rs中,然后从rs中取出来封装到customer即可
// TODO Auto-generated method stub
int id = rs.getInt("id");
String name = rs.getString("name");
String station = rs.getString("station");
String telephone = rs.getString("telephone");
String address = rs.getString("address");
String decidedzone_id = rs.getString("decidedzone_id");
return new Customer(id, name, station, telephone, address, decidedzone_id);
}
},decidedzone_id);//第二个参数就是占位符对象的位置,这里是一个Object[]数组,可以有多个参数
return list;
}