java调用存储过程

存储过程：
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();
            }
        }
    }