Connection cnn=null;
try{
Class.forName(JDBC_DRIVER);
cnn=DriverManager.getConnection(JDBC_URL,DB_USER,DB_PWD);
CallableStatement cstmt=cnn.prepareCall("{call "+p_strProcName+"}");
if(p_oParm!=null){
for(int i=0;i<p_oParm.length;i++){
cstmt.setObject(i+1,p_oParm);
}
}
cstmt.execute();
//cstmt.close(); //一定不能在这里就cstmt.close(),否则提交不完全!!!
cnn.commit();
cstmt.close();
}finally{
try{
cnn.close();
}catch(Exception ee){}
}