读书人

jdbcTemplate查询及返回值步骤

发布时间: 2012-10-27 10:42:26 作者: rapoo

jdbcTemplate查询及返回值方法

private RowMapper amnyMapper = new RowMapper(){public Object mapRow(ResultSet r, int rowNum) throws java.sql.SQLException {AMNY   a = new  AMNY();a.setMny(r.getString("mny"));a.setMnyAffix(r.getString("mnyaffix"));a.setMnyName(r.getString("mnyname"));a.setMnyStyle(r.getInt("mnystyle"));return a;}};public  AMNY[]  getAmny(){String  sql = "select  a.mny,a.mnyname,a.mnyaffix,a.mnystyle  from  amny  a ";;List  list = jt.query(sql, amnyMapper);AMNY[]  a = new AMNY[list.size()];list.toArray(a);return a;}

?

读书人网 >其他数据库

热点推荐