/* 插入BLOB对象 */
public static String reqInfo(String qry,String cxfaid,String fwfid,String pf,String xtestflag){
Connection con=null;
Statement stat=null;
String send="qry="+qry+"&cxfaid="+cxfaid+"&fwfid="+fwfid+"&pf="+pf+"&xtestflag="+xtestflag;
System.out.println("zwreq ReqDao.class send= "+send);
String id=getGuid();
String sql="insert into mutual(id,Send,Receive) values ('"+id+"',EMPTY_BLOB(),EMPTY_BLOB())";
System.out.println("sql= "+sql);
String result="false";
try {
con=ConnManager.getConnection();
stat=con.createStatement();
int count = stat.executeUpdate(sql);
if (count > 0) {
blobModify(con, stat, send,
"send", "mutual", id,
"id");
}
} catch (Exception e) {
// TODO Auto-generated catch block
result="ReqDao.reqInfo 错误:"+e.getMessage();
e.printStackTrace();
} finally {
try {
if (stat != null) {
stat.close();
}
if (con != null) {
con.close();
con = null;
}
} catch (Exception e) {
}
}
return result;
}
/* 修改BLOB对象(是在原CLOB对象基础上进行覆盖式的修改) */
public static void blobModify(Connection con, Statement stmt,
String infile, String blobColumnName, String tabName, String id,
String idColumName) throws SQLException {
byte[] b=infile.getBytes();
/* 设定不自动提交 */
boolean defaultCommit = con.getAutoCommit();
con.setAutoCommit(false);
try {
/* 查询CLOB对象并锁定 */
String sql = "SELECT " + blobColumnName + " FROM " + tabName
+ " WHERE " + idColumName + "='" + id + "' FOR UPDATE";
// System.out.println("clobModify String sql= "+sql);
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
/* 获取此CLOB对象 */
oracle.sql.BLOB blob = (oracle.sql.BLOB) rs
.getBlob(blobColumnName);
// System.out.println(clob);
// System.out.println("infile= "+infile);
OutputStream blobWriter = blob.getBinaryOutputStream();
blobWriter.write(b,0,b.length);
blobWriter.flush();
blobWriter.close();
}
/* 正式提交 */
con.commit();
} catch (Exception ex) {
/* 出错回滚 */
con.rollback();
ex.printStackTrace();
}
/* 恢复原提交状态 */
con.setAutoCommit(defaultCommit);
}
public static String reqInfo(String qry,String cxfaid,String fwfid,String pf,String xtestflag){
Connection con=null;
Statement stat=null;
String send="qry="+qry+"&cxfaid="+cxfaid+"&fwfid="+fwfid+"&pf="+pf+"&xtestflag="+xtestflag;
System.out.println("zwreq ReqDao.class send= "+send);
String id=getGuid();
String sql="insert into mutual(id,Send,Receive) values ('"+id+"',EMPTY_BLOB(),EMPTY_BLOB())";
System.out.println("sql= "+sql);
String result="false";
try {
con=ConnManager.getConnection();
stat=con.createStatement();
int count = stat.executeUpdate(sql);
if (count > 0) {
blobModify(con, stat, send,
"send", "mutual", id,
"id");
}
} catch (Exception e) {
// TODO Auto-generated catch block
result="ReqDao.reqInfo 错误:"+e.getMessage();
e.printStackTrace();
} finally {
try {
if (stat != null) {
stat.close();
}
if (con != null) {
con.close();
con = null;
}
} catch (Exception e) {
}
}
return result;
}
/* 修改BLOB对象(是在原CLOB对象基础上进行覆盖式的修改) */
public static void blobModify(Connection con, Statement stmt,
String infile, String blobColumnName, String tabName, String id,
String idColumName) throws SQLException {
byte[] b=infile.getBytes();
/* 设定不自动提交 */
boolean defaultCommit = con.getAutoCommit();
con.setAutoCommit(false);
try {
/* 查询CLOB对象并锁定 */
String sql = "SELECT " + blobColumnName + " FROM " + tabName
+ " WHERE " + idColumName + "='" + id + "' FOR UPDATE";
// System.out.println("clobModify String sql= "+sql);
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
/* 获取此CLOB对象 */
oracle.sql.BLOB blob = (oracle.sql.BLOB) rs
.getBlob(blobColumnName);
// System.out.println(clob);
// System.out.println("infile= "+infile);
OutputStream blobWriter = blob.getBinaryOutputStream();
blobWriter.write(b,0,b.length);
blobWriter.flush();
blobWriter.close();
}
/* 正式提交 */
con.commit();
} catch (Exception ex) {
/* 出错回滚 */
con.rollback();
ex.printStackTrace();
}
/* 恢复原提交状态 */
con.setAutoCommit(defaultCommit);
}