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;
oracle 10.0.1.0驱动:见附件
转载于:https://blog.51cto.com/kitten/622718