java 执行存储过程例子

private String addcwform(String recordsumid) {

CallableStatement proc = null;
Connection conn = null;
try {
conn = DBUtil.getConn();
proc = conn.prepareCall("{ ? = call cwnew_pack.addCwform(?) }");
proc.registerOutParameter(1, Types.CHAR);
proc.setString(2, recordsumid);

proc.execute();
String str = proc.getString(1);
return str;

}
catch (SQLException e) {
Log.fetal("失败:" + e + "cwnew_pack.addCwform" + ",recordsumid=" +
recordsumid);
}
finally {

freeclose(proc, conn);
}
return "";
}

private void freeclose(CallableStatement proc, Connection conn) {
try {
proc.close();
}
catch (Exception ex) {
Log.fetal("关闭:proc,失败," + ex.toString());
}
this.closeConn(conn);

}

/**
* 关闭所有的连接
*/
public void closeConn(Connection conn) {

try {
conn.close();
}
catch (Exception e) {
Log.fetal("数据库连接，关闭错误:" + e);
}

}