问题如题:
我的代码:
sql = "DELETE FROM JBINARY WHERE JB_HDSGID=" + Tools.Q(Hdr_SGID);
sql += " AND JB_DOC=" + Tools.Q(DocID);
sql += "AND JB_FIELD=" + Tools.Q(FldID);
db.execUpdate(sql);
//
//* -------------------------------------------------------------------------------- *
// *
// * Create a blank new record
// *
// * -------------------------------------------------------------------------------- *
//
sql = "INSERT INTO JBINARY (JB_SGID, JB_HDSGID, JB_DOC, JB_FIELD) VALUES (";
sql += Tools.Q(JB_Own_SGID) + ",";
sql += Tools.Q(Hdr_SGID) + "," + Tools.Q(DocID) + "," + Tools.Q(FldID)+")";
db.execUpdate(sql);
//
// * -------------------------------------------------------------------------------- *
// *
// * Update the IMAGE field into row
// *
// * -------------------------------------------------------------------------------- *
//
sql = "UPDATE JBINARY SET JB_FILEBIN=? WHERE JB_SGID=" + Tools.Q(JB_Own_SGID);
sql +=" AND JB_HDSGID=" + Tools.Q(Hdr_SGID);
sql +=" AND JB_DOC= "+Tools.Q(DocID);
sql +=" AND JB_FIELD="+Tools.Q(FldID);
bps = conn.prepareStatement(sql);
File file=new File(TargetDir);
l1=file.length();
l2=(int)l1;
is = new java.io.FileInputStream(file);
bps.setBinaryStream(1,is,l2);
bps.executeUpdate();
bps.getConnection().commit();
bps.close();
is.close();
is = null;
bps = null;当上传的文件比较小时,可以保存到数据库。但是文件稍微大一点,却不能保存到数据库
我的代码:
sql = "DELETE FROM JBINARY WHERE JB_HDSGID=" + Tools.Q(Hdr_SGID);
sql += " AND JB_DOC=" + Tools.Q(DocID);
sql += "AND JB_FIELD=" + Tools.Q(FldID);
db.execUpdate(sql);
//
//* -------------------------------------------------------------------------------- *
// *
// * Create a blank new record
// *
// * -------------------------------------------------------------------------------- *
//
sql = "INSERT INTO JBINARY (JB_SGID, JB_HDSGID, JB_DOC, JB_FIELD) VALUES (";
sql += Tools.Q(JB_Own_SGID) + ",";
sql += Tools.Q(Hdr_SGID) + "," + Tools.Q(DocID) + "," + Tools.Q(FldID)+")";
db.execUpdate(sql);
//
// * -------------------------------------------------------------------------------- *
// *
// * Update the IMAGE field into row
// *
// * -------------------------------------------------------------------------------- *
//
sql = "UPDATE JBINARY SET JB_FILEBIN=? WHERE JB_SGID=" + Tools.Q(JB_Own_SGID);
sql +=" AND JB_HDSGID=" + Tools.Q(Hdr_SGID);
sql +=" AND JB_DOC= "+Tools.Q(DocID);
sql +=" AND JB_FIELD="+Tools.Q(FldID);
bps = conn.prepareStatement(sql);
File file=new File(TargetDir);
l1=file.length();
l2=(int)l1;
is = new java.io.FileInputStream(file);
bps.setBinaryStream(1,is,l2);
bps.executeUpdate();
bps.getConnection().commit();
bps.close();
is.close();
is = null;
bps = null;当上传的文件比较小时,可以保存到数据库。但是文件稍微大一点,却不能保存到数据库
解决方案 »
- javascript-正则表达式求助
- AGE的python模板能这样写在javascript里面吗?
- select标签中加入图片和链接
- 请问用tomcat做web server,jsp+java的应用,可以通过jsp页面删除已上传到server的文件吗?
- 已经有sql文件,如何在mysql中生成数据库?
- Tomcat下xml配置文件的正确路径
- 在线等。jquery 验证码 同步验证局部刷新....附代码了................
- 请问JSP中如何调用未打成包的类?
- 有什么好好方法把HTML中的TABLE存入数据库中
- 高分求助,江湖告急!
- tomcat+jsp+sqlserver如何实现树结构
- 如何用java类生成xml文件?
insert into table(<blob_column>) values(empty_blob());select:
select <blob_column> from table where id = XXXXX for update;update:
// write bytes into BLOB Object named yourBlobcommit();
insert into table( <blob_column> ) values(empty_blob()); select:
select <blob_column> from table where id = XXXXX for update; update:
// write bytes into BLOB Object named yourBlob commit();
2 insert和update 需要启用事务
3 顺序和方法请参考 2/5 楼, 一般都是 select for update 的,因为要锁住这一行,免得出现同步问题