读取sql server中二进制图片

macshe

public void showPhoto(HttpServletResponse response,String fphotoId){
    Connection conn = null;
    try{
    try {
    InitialContext ic = new InitialContext();
    Statement stmt = null;
    conn = DBConnection.getConnection();
    BufferedInputStream inputimage = null;
    stmt = conn.createStatement();
    boolean defaultCommit = conn.getAutoCommit();
    conn.setAutoCommit(false);
    ResultSet rs = stmt.executeQuery("SELECT * FROM t_photo WHERE fid='"+ fphotoId + "'");
    if (rs.next()) {
    Blob blob = (Blob) rs.getBlob("fimage");
    long size = blob.length();
    byte[] bs = blob.getBytes(1, (int) size);
    response.setContentType("image/jpeg;charset=GB2312");
    response.setHeader("Content-Transfer-Encoding", "base64");
    String filepath = "";
    String dir = this.getServlet().getServletContext().getRealPath("UPLOAD");
    File dirFile = new File(dir);
    if (!(dirFile.exists()) && !(dirFile.isDirectory())) {
    dirFile.mkdir();
    }
    String filename = getRndFileName("jpg");
    filepath = fphotoId+ filename.substring(filename.lastIndexOf("."),filename.length());
    OutputStream out1 = new FileOutputStream(dir + "\\" + filepath);
    out1.write(bs, 0, bs.length);
    out1.close();
    rs.close();
    } else {
    rs.close();
    }
    } catch (Exception e) {
    conn.rollback();
    e.printStackTrace();
    } finally {
    conn.close();
    }
    }catch(Exception e){
    e.printStackTrace();
    }
    }

/**
* @param path
* @return 返回随机获得的文件名 获取随机文件名.如 aa.gif bb.jpg 等.
*/
public String getRndFileName(String path) {
String rndFileName = String.valueOf(System.currentTimeMillis())
+ String.valueOf(new Random().nextInt(100));
String extFileName = getExName(path);
if (!extFileName.equals("")) {
rndFileName = rndFileName + "." + extFileName;
}
return rndFileName;
}

// 获取文件扩展名.如: gif jpg (不包括".")等.
public String getExName(String path) {
int strint = path.lastIndexOf(".");
return path.substring(strint + 1);// 这样是不包括点
// return path.substring(strint);//这样是有包括点
}

将读取的图片上传到服务器中。。。。
if(productList.size() != 0){
    for (Product product : productList) {
    if(product.getPhoto() != null){
    String fphotoid = product.getPhoto().getFid();
    String filepath = "";
    String dir = this.getServlet().getServletContext().getRealPath("UPLOAD");
    filepath = dir + "\\"+fphotoid+".jpg";
    File file = new File(filepath);
    if(!file.exists()){
    showPhoto(response,fphotoid);
    }
    }
}
    request.setAttribute("productList",productList);
    }