JAVA执行存储过程（通用方法）
? ? ? /**
* 执行存储过程
* @param 存储过程名称
* @param 所需参数
* @return 存储过程发返回的错误信息
* @author wuhao
* @throws Exception
*/
public static void executeProc(String call,Object[] params) throws Exception{
String result = "";
Connection conn = null;
CallableStatement proc = null;
try {
conn = dao.getSessionFactory().openSession().connection();
conn.setAutoCommit(false);
proc = conn.prepareCall(call);
int index = 0;
if(params != null && params.length > 0){
for (int i = 1; i <= params.length; i++) {
proc.setObject(i, params[i-1]);
index +=1;
}
}
index = index+1;
proc.registerOutParameter(index,Types.VARCHAR);?
proc.execute();?
result = proc.getString(index);
if( null != result && !result.equals("") ){
conn.rollback();
} else {
? ?conn.commit();
}
} catch (Exception e) {
conn.rollback();
throw e;
} finally {
if(null != proc)
proc.close();
if(null != conn)
conn.close();
}
}
