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);
}
}