oracle存储过程没有返回值,Java调用Oracle存储过程（无返回值）

无返回值：

1：创建存储过程

此存储过程向表中插入一条数据

create or replace procedure demo_procedure(id varchar2,name varchar2,age varchar2,sex varchar2,address varchar2)

as

begin

insert into system.demo values(id,name,age,sex,address);

end;

2：java代码

import java.sql.CallableStatement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class TestProcedure {

static Connection conn = null;

static CallableStatement cstmt = null;

PreparedStatement pstmt = null;

static String url ="jdbc:oracle:thin:@localhost:1521:myoracle";

static String driver = "oracle.jdbc.driver.OracleDriver";

String name="";

public static void main(String args[]){

System.out.println("hello kalsiion");

try{

Class.forName(driver);

conn = DriverManager.getConnection(url,"system","admin");

cstmt = conn.prepareCall("{call demo_procedure(?,?,?,?,?)}");

cstmt.setString(1, "12");

cstmt.setString(2, "kalision");

cstmt.setString(3, "23");

cstmt.setString(4, "男");

cstmt.setString(5, "塞浦路斯");

cstmt.executeUpdate();

System.out.println("存储过程已经成功执行...");

}catch(Exception e){

e.printStackTrace();

}finally{

try {

cstmt.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

}

OK!