javabean中调用存储过程!
egfly 2004-08-24 05:55:27 oracle中作了一简单的存储过程:
create or replace procedure samp(i_name in char,i_ages in number) as
begin
delete from abcd;
insert into abcd values(i_name,i_ages);
commit;
end;
javabean中:
package tryexp.pro.bean;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.sql.*;
import javax.naming.*;
public class insertPro implements java.io.Serializable{
public insertPro(){
}
public static void setDeathAge() throws SQLException{
Connection con = null;
CallableStatement proc = null;
try {
javax.sql.DataSource myDataSource = null;
Context ctx = null;
try {
ctx = new InitialContext();
myDataSource = (javax.sql.DataSource)ctx.lookup("wldatesource");
con = myDataSource.getConnection();
proc = con.prepareCall("{ call samp(?, ?) }");
proc.setString(1, "A01001");
proc.setInt(2, 28);
proc.executeUpdate();
}
finally {
try {
proc.close();
}
catch (SQLException e) {}
con.close();
}
}
catch (Exception e){
System.out.print("Connection Failed" + e.getMessage());
}
}
}
javac insertPro.java后为什么表中未增加纪录!