hibernate：
private String getNewSeq(String eService) {
String no = "";
Session session = getSessionFactory().openSession();
Transaction tx = null;
try {
tx = session.beginTransaction();
CallableStatement call = session.connection().prepareCall("{call PF_genRefNo(?,?)}");
call.setString(1, eService);
call.registerOutParameter(2, Types.VARCHAR);
call.execute();
no = call.getString(2);
tx.commit();
} catch (SQLException e) {
log.error(e.getMessage(),e);
}finally{
if (session != null)
{
try
{
session.close();
}
catch (HibernateException e)
{
log.error(e.getMessage(),e);
}
}
}
return no;
}
mybatits：
public List getLocationOfVesselStatusNS(final Map paraMap){ final List retList = new ArrayList(); final String sql=" {call marinedb_ncs_p2_uat.dbo.p_PTMS_enqVslCurStatusPTMS(?)}"; Map searchMap=(Map)paraMap.get("searchMap"); final int vslId=(Integer)searchMap.get("vslId"); Object object = jdbcTemplate.execute(new CallableStatementCreator() { public CallableStatement createCallableStatement(Connection arg0) throws SQLException { CallableStatement cs = arg0.prepareCall(sql); return cs; } }, new CallableStatementCallback() { public Object doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException { cs.setInt(1, vslId); cs.execute(); List columns = new ArrayList(); columns.add("vsl_x"); columns.add("vslprev_x"); columns.add("vsllstp_x"); columns.add("vslnxp_x"); columns.add("vslcallsign_x"); columns.add("licno_x"); columns.add("vslty_x"); columns.add("vslflag_x"); columns.add("vslgt_x"); columns.add("vsllen_x"); columns.add("vsldeclrarr_x"); columns.add("vsldeclrdep_x"); columns.add("agent_x"); columns.add("mvstm_eta_x"); columns.add("mvetm_eta_x"); columns.add("mvstm_etd_x"); columns.add("mvetm_etd_x"); columns.add("currlocn_x"); columns.add("vslimo_x"); ResultSet rs = cs.getResultSet(); while (rs.next()) { Map map = new HashMap(); for (int i = 0; i < columns.size(); i++) { map.put(columns.get(i), rs.getString(i + 1)); } retList.add(map); } return retList; } }); return retList; }
原文：http://www.cnblogs.com/donnieluo/p/6672685.html