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;
}