Call the Oracle stored procedure in java, and the javaoracle Stored Procedure
Calling the Oracle stored procedure in java
This article describes how to call the stored procedure of Oracle through java.
1. Write the Stored Procedure
Create or replace procedure sp_pro3 (sp_name VARCHAR2, sp_sal NUMBER) ISBEGIN -- modify the salary UPDATE emp SET sal = sp_sal WHERE ename = sp_name; END based on the user name;
Package testOraclePro; import java. SQL. callableStatement; import java. SQL. connection; import java. SQL. driverManager; public class Test {public static void main (String [] args) {try {// 1. load the driver Class. forName ("oracle. jdbc. driver. oracleDriver "); // 2. get Connection ct = DriverManager. getConnection ("jdbc: oracle: thin: @ 127.0.0.1: 1521: XE", "sys as sysdba", "123456"); // 3. create CallableStatement cs = ct . PrepareCall ("{call sp_pro3 (?,?)} "); // 4. assign a value to cs. setString (1, "zxs"); cs. setFloat (2, 455f); // 5. run cs.exe cute (); // 6. disable resource cs. close (); ct. close ();} catch (Exception e) {e. printStackTrace ();}}}
Run the test class above to call the stored procedure and execute the corresponding program.