首先通過pl/sql建立一個(gè)存儲(chǔ)過程Xiao_Note
create or replace procedure Xiao_Note
(
name in varchar2,
email in varchar2,
dept in varchar2
)
is
begin
insert into email (id,name,email,dept) values(Autoaddid.Nextval,name,email,dept);
commit;
end Xiao_Note;
其中
Autoaddid.Nextval是建的一個(gè)oracle的自增長(zhǎng)序列，用于做主鍵用的
編譯成功后。測(cè)試
。。。
public static void main(String[] args) throws SQLException {
CommonDAO dao=new CommonDAO();
Connection conn=dao.getConnection();
String procedure = "{call XIAO_NOTE(?,?,?)}";
CallableStatement cstmt = conn.prepareCall(procedure);
cstmt.setString(1,"liuyong1111");
cstmt.setString(2,"liuyongcic@163.com");
cstmt.setString(3,"xx");
cstmt.executeUpdate();
System.out.println("ok");
}
。。。