67,550
社区成员




public Production getById( String id) throws Exception {
DefaultTransactionDefinition definition = new DefaultTransactionDefinition();
TransactionStatus status = transactionManager.getTransaction(definition);
Production prod = new Production();
String query = "select * from t_productions where prod_id=?";
try{
int prod_id = Integer.parseInt(id);
prod = (Production)jdbcTemplate.queryForObject(query,new Object[]{prod_id},
new int[]{java.sql.Types.INTEGER},new ProdRowMapper());
}catch(Exception ex){
transactionManager.rollback(status);
throw ex;
}
return prod;
}
//为Query方法准备的内部类
class ProdRowMapper implements org.springframework.jdbc.core.RowMapper{
public Object mapRow(ResultSet rst, int rowNum) throws SQLException {
Production prod = new Production();
while(rst.next()) {//次数rst.next()返回false!
prod.setProd_id(rst.getString("prod_id"));
prod.setProd_Materials(rst.getString("prod_Materials"));
prod.setProd_meas_status(rst.getString("prod_meas_status"));
prod.setProd_model(rst.getString("prod_model"));
prod.setProd_name(rst.getString("prod_name"));
prod.setProd_update_DT(rst.getString("prod_update_DT"));
prod.setProd_update_user(rst.getString("prod_update_user"));
prod.setS_id(rst.getString("s_id"));
}
return prod;
}
}