java 插入 blob_java操作oracle里面的blob对象,无法插入 | 学步园

public class ttt {

private String filename="F://123.jpg"; //文本域的id

InputStream inputStream =null;

OutputStream outputStream=null;

public void fileupload()  throws Exception

{

String dbUrl = "jdbc:oracle:thin:@192.168.2.150:1521:orcl";

String user = "fangyan";

String password = "fangyan";

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection c = DriverManager.getConnection(dbUrl, user, password);

Statement s = c.createStatement();

oracle.sql.BLOB blob=null;

try {//得到文件流

int rS=s.executeUpdate("insert into luyin (id,fileinfo) values('15',EMPTY_BLOB())");

ResultSet rs = s.executeQuery("SELECT fileinfo FROM luyin WHERE ID='15' FOR UPDATE");

while (rs.next()) {

/* 取出此BLOB对象 */

blob = (oracle.sql.BLOB)rs.getBlob("fileinfo");

}

/* 向BLOB对象中写入数据 */

outputStream = blob.getBinaryOutputStream();

inputStream=new FileInputStream("F://123.jpg");

System.out.println(filename+"***********\n"+filename.length());

byte[] buff=new byte[(int)filename.length()];

int index=0;

while ((index=inputStream.read(buff))!=-1) {

outputStream.write(buff);

}

//  ResultSet sa=s.executeQuery("update luyin set fileinfo='"+buff+"' where id=15");

System.out.println(buff);

inputStream.close();

outputStream.flush();

} catch (Exception e) {

System.out.println(e.getMessage()+"************");

}

}

public static void main(String[] args) throws Exception {

ttt t=new ttt();

t.fileupload();

}

}

求求各位大神,告诉我为什么!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值