Java 調用Oracle中的預存程序

標籤：style   blog   http   color   io   os   ar   java   for   

--建表SQL> create table TBook(bookId number(8),bookName varchar2(50),publishHouse varchar2(50));--編寫過程--in:輸入參數；out:輸出參數SQL> create or replace procedure sp_pro7(spBookId in number,spName in Varchar2,spPublishHost in varchar2) isbegin  insert into TBook values(spBookId,spName,spPublishHost);end;
--在Java中調用（工程中要載入odbcDriver）

 1 package oracle; 2  3 import java.sql.CallableStatement; 4 import java.sql.Connection; 5 import java.sql.DriverManager; 6 import java.sql.SQLException; 7  8  9 10 //調用一個無傳回值的過程11 public class Test01 {12 13     public static void main(String[] args) {14         // TODO Auto-generated method stub15         Connection conn = null;16         CallableStatement cs = null;17         try {18             //1.載入驅動19             Class.forName("oracle.jdbc.driver.OracleDriver");20             21             //2.串連22             String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORACLE12C";23             String userName = "sys as SYSDBA";24             String password = "fairy6280";25             conn = DriverManager.getConnection(url,userName,password);26             //3.建立CallableStatement27             String sql = "{call sp_pro7(?,?,?)}";28             cs = conn.prepareCall(sql);29             //給‘?‘賦值30             cs.setInt(1, 1001);31             cs.setString(2, "The History of the Three Kingdoms");32             cs.setString(3, "People‘s Publishing House");33             //執行34             cs.execute();35             36         } catch (Exception e) {37             // TODO Auto-generated catch block38             e.printStackTrace();39         }40         finally{41             //關閉42             try {43                 cs.close();44                 conn.close();45             } catch (SQLException e) {46                 // TODO Auto-generated catch block47                 e.printStackTrace();48             }49         }50     }51 52 }

Java 調用Oracle中的預存程序