public void Runcountproc () {Object o = Db.execute (new Icallback () {@Override public Object call (Connection conn) throws SQLException {callablestatement proc = Conn.preparecall ("{Call Proc_normalcount (?,?,?,?,?)}"); Proc.registeroutparameter (1, Oracletypes.varchar); Proc.registeroutparameter (2, Oracletypes.varchar); Proc.registeroutparameter (3, Oracletypes.varchar); Proc.registeroutparameter (4, Oracletypes.varchar); Proc.registeroutparameter (5, Oracletypes.varchar); Proc.execute (); The code comes here to show that your stored procedure has been successfully called, and if there is an output parameter, the next step is to take the output parameter of a process record record = new record (); The IRS has a tax source without Record.set ("Gsysyw", Proc.getobject (1)); The IRS has no tax source record.set ("Gswsyy", Proc.getobject (2)); Identification number different name of the same record.set ("SBHBTMCT", Proc.getobject (3)); Identification number same name different Record.set ("SBHTMCBT", Proc.getobject (4)); Identification number names are the same record.set ("Sbhmcxt", Proc.getobject (5)); SetAttr ("Count", record); return proc; } }); }
Jfinal invoking an Oracle stored procedure