1.hibernate dao层调用oracle存储过程
@Repositorypublic class PcdmPeriodChartDao extends BaseDao<PcdmPeriodChart> { // 传入存储过程 和参数 public void executeVoidProcedureSql(final String queryString, final Object[] params) throws Exception { Session session = getSession(); session.doWork(new Work() { public void execute(Connection conn) throws SQLException { ResultSet rs = null; CallableStatement call = conn.prepareCall("{" + queryString + "}"); if (null != params) { for (int i = 0; i < params.length; i++) { call.setObject(i + 1, params[i]); } } rs = call.executeQuery(); call.close(); rs.close(); } }); }}@Repositor 
