Java执行 oracle存储过程

最新推荐文章于 2021-04-14 16:26:52 发布

胡子哥502

最新推荐文章于 2021-04-14 16:26:52 发布

阅读量639

点赞数

分类专栏： java 数据库文章标签：存储过程 oracle存储过程 javaoracle存储过程执

本文链接：https://blog.csdn.net/huweijun_2012/article/details/42433487

版权

java 同时被 2 个专栏收录

42 篇文章 0 订阅

订阅专栏

数据库

17 篇文章 0 订阅

订阅专栏

一:先在数据库里执行以下sql脚本.
           --建表:
           create table user(
                id NUMBER(19),
                name VARCHAR2(9),
                primary key (id)
            );

            --建立存储过程:
            CREATE OR REPLACE PROCEDURE addUser(PARA1 IN NUMBER,PARA2 IN VARCHAR2)
            AS
            BEGIN
               INSERT INTO user (id,name) VALUES (PARA1, PARA2);
            END addUser;

二,执行以下Java代码.
     package com.demo.util;

      import java.sql.CallableStatement;
      import java.sql.DriverManager;
      import java.sql.ResultSet;
      import java.sql.Statement;

public class ConnectionUtil {

    public static void main(String[] args) {
        //要导入oracle驱动包.
        String driver = "oracle.jdbc.driver.OracleDriver";
        String strUrl = "jdbc:oracle:thin:@192.168.1.100:1521:test";
        String dbName = "root";
        String password = "123456";

        Statement statement = null;
        ResultSet result = null;
        java.sql.Connection connection = null;
        CallableStatement cStatement = null;
        try {
            Class.forName(driver);
            connection = DriverManager.getConnection(strUrl,dbName,password);
           if(connection != null){
                cStatement = connection.prepareCall("{call "+dbName+".addUser(?,?)}");
                cStatement.setInt(1, 1001);
                cStatement.setString(2, "Jack");

                cStatement.execute();
            }else {
                System.out.println("获取connection失败.");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally{
            try {
                if(result != null){
                    result.close();
                }
                if(statement != null){
                    statement.close();
                }
                if (connection != null) {
                    connection.close();
                }
            } catch (Exception e2) {
                e2.printStackTrace();
            }
        }

    }
}

三,去数据库查询添加用户是否成功.

select * from user where id = 1001;

注:
查询所有存储过程:
select * from user_objects where object_type='PROCEDURE';
删除存储过程:

drop procedure procedureName;