java調用存儲過程示例版 – JAVA編程語言程序開發技術文章

java代碼：
package procedure;
 
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class TestProcedureOne {
    public TestProcedureOne() {
    }
 
    public static void main(String[] args) {
        String driver = "oracle.jdbc.driver.OracleDriver";
        // oracle.jdbc.driver.OracleDriver
        String strUrl = // "jdbc.oracle:thin:@127.0.0.1:1521:ORCL";
        "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
        ResultSet rs = null;
        Connection con = null;
        try {
            Class.forName(driver);
            con = DriverManager.getConnection(strUrl, "用戶名", "密碼");
            CallableStatement proc = null;
            proc = con.prepareCall("{call TESTA(?,?)}");
            proc.setString(1, "firstName");
            proc.setString(2, "77.77");
            proc.execute();
        } catch (SQLException ex2) {
            ex2.printStackTrace();
        } catch (Exception ex2) {
            ex2.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                    if (con != null) {
                        con.close();
                    }
                }
            } catch (SQLException ex1) {
            }
        }
    }
}
存儲過程：
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2)  AS
BEGIN
INSERT INTO BOOK(Bookname,BOOKPRICE)VALUES(PARA1,PARA2);
END TESTA;