写图片到数据库:
String sql = "INSERT INTO PicTable( PICID,PICContent)VALUES(?,?)";
insertPicStmt = conn.getPreparedStatement(sql);byte[] pic = getPicByte();//该方法取出图片文件转成byte数组
java.io.ByteArrayInputStream bais = new java.io.ByteArrayInputStream(pic);
insertPicStmt.setBinaryStream(1, 0);//0代表图片id
insertPicStmt.setBinaryStream(2, bais);
insertPicStmt.execute();
String sql = "INSERT INTO PicTable( PICID,PICContent)VALUES(?,?)";
insertPicStmt = conn.getPreparedStatement(sql);byte[] pic = getPicByte();//该方法取出图片文件转成byte数组
java.io.ByteArrayInputStream bais = new java.io.ByteArrayInputStream(pic);
insertPicStmt.setBinaryStream(1, 0);//0代表图片id
insertPicStmt.setBinaryStream(2, bais);
insertPicStmt.execute();
要在网页上显示的时候必须还原成jpg文件才能显示吗?
有没有不用输出文件就能直接在网页上显示的方法呢?
...
rst.stmt.executequery("select ... from ... where ID="+id);
rst.next();
byte[] image=rst.get..();
out.write(image);
读的页面中使用格式: <img src="readjpg.jsp?ID=11">