java调用oracle存储过程

JAVA中调用Oracle存储过程

下面是测试代码和数据表存储过程

import java.sql.*;

/**
数据库表
CREATE TABLE TB_MONITOR (
   ID                   NUMBER(20)                      NOT NULL,
   MONITOR_OBJECT_CODE CHAR(10),
   MONITOR_OBJECT_NAME VARCHAR2(180),
   BRANCH_CODE          CHAR(10),
   SYSTEM_CODE          CHAR(10),
   DIREC_NAME           VARCHAR2(180),
   FILE_NUM             NUMBER,
   STATUS               CHAR(10),
   BEGIN_TIME           TIMESTAMP,
   END_TIME             TIMESTAMP,
   DATA_TIME            TIMESTAMP,
   MONITOR_TIME         TIMESTAMP,
   REMARK               VARCHAR2(180),
   CONSTRAINT PK_TB_MONITOR PRIMARY KEY (ID)
);
*/
public class OracleProcedureCall {

private static String driver = "oracle.jdbc.driver.OracleDriver";
private static String strUrl = "jdbc:oracle:thin:@192.168.1.90:1521:odsdb";
private static String userName = "odsdb";

private static String password = "ods";

private static Connection conn = null;

//获得数据库连接
public static Connection getConnection(){
   try{
    if(conn == null){
     Class.forName(driver);
     conn = DriverManager.getConnection(strUrl, userName, password);
    }
   }catch(ClassNotFoundException e){
    e.printStackTrace();
   }catch(SQLException e){
    e.printStackTrace();
   }

     return conn;
}

/*无返回值的存储过程
CREATE OR REPLACE PROCEDURE AddMonInfo
(
n_id tb_monitor.id%TYPE,
n_oc tb_monitor.monitor_object_code%TYPE,
n_on tb_monitor.monitor_object_name%TYPE,
n_bc tb_monitor.branch_code%TYPE,
n_sc tb_monitor.system_code%TYPE,
n_fn tb_monitor.file_num%TYPE,
n_st tb_monitor.status%TYPE,