存储过程:
create or replace procedure insert_emp
(empid in number,
empname in varchar2,
empsal in number)
as
begin
insert into emp(empno,ename,sal) values(empid,empname,empsal);
end insert_emp;
java代码:
-
Java code
-
public class TestOracle { public static void main(String[] args) { Connection conn = null ; CallableStatement cs = null ; String url = " jdbc:oracle:thin:@127.0.0.1:1521:XE " ; String name = " system " ; String password = " 123456 " ; try { Class.forName( " oracle.jdbc.driver.OracleDriver " ); conn = DriverManager.getConnection(url,name,password); cs = conn.prepareCall( " {call insert_emp(?,?,?)} " ); cs.setInt( 1 , 30 ); cs.setString( 2 , " Lucy " ); cs.setInt( 3 , 4000 ); cs.execute(); System.out.println( " insert ok " ); } catch (Exception e) { e.printStackTrace(); } finally { try { cs.close(); } catch (SQLException e) { e.printStackTrace(); } try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } }