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();
}
}
求求各位大神,告诉我为什么!