RCP编程技巧：如何显示Mysql数据库中存储的图片？

我在程序开发中，经常要将图片文件存入Mysql数据库的longblob字段中，存入数据库和以前在jsp中没什么区别，那么，如何将存入数据库的图片在SWT中显示呢？

首先，我写了一个方法，将inputstream取出，

public InputStream getImage(String id) {

  DataConfig config = new DataConfig();
  InputStream stream = null;

  try {

   config.openConnection();
   Connection conn = config.getConnection();
   PreparedStatement pStmt = conn
     .prepareStatement("select bugimage from bugs where id=?");
   pStmt.setString(1, id);
   ResultSet rs = pStmt.executeQuery();
   if (rs != null) {
    while (rs.next()) {
     stream = rs.getBinaryStream(1);
    }
    rs.close();
   }
   pStmt.close();
  } catch (SQLException e) {

   e.printStackTrace();
  }

  return stream;

 }

然后，在程序中使用SWT的Image类和Canvas类将图片显示出来，代码如下：

//其中Canvas显示滚动条的代码来自eclipse网站
  Composite composite = new Composite(parent, SWT.NONE);
  GridLayout gridLayout = new GridLayout(1, false);
  gridLayout.marginWidth = 10;
  gridLayout.marginHeight = 10;
  gridLayout.horizontalSpacing = 10;
  gridLayout.verticalSpacing = 10;
  composite.setLayout(gridLayout);
  GridData gridData = new GridData(GridData.FILL, GridData.CENTER, false,
    false);
  composite.setLayoutData(gridData);

  image = new Image(Display.getDefault(), getImage("1"));
  
  if (image == null) {
   int width = 150, height = 200;
   image = new Image(FireiceUtil.getDisplay(), width, height);
   GC gc = new GC(image);
   gc.fillRectangle(0, 0, width, height);
   gc.drawLine(0, 0, width, height);
   gc.drawLine(0, height, width, 0);
   gc.drawText("No Image", 10, 10);
   gc.dispose();
  }

  canvas = new Canvas(composite, SWT.NO_BACKGROUND | SWT.NO_REDRAW_RESIZE | SWT.V_SCROLL | SWT.H_SCROLL);
  GridData canvasGridData = new GridData();
  canvasGridData.heightHint = 400;
  canvasGridData.widthHint = 500;
  canvas.setLayoutData(canvasGridData);

  final Point origin = new Point(0, 0);
  final ScrollBar hBar = canvas.getHorizontalBar();
  hBar.addListener(SWT.Selection, new Listener() {
   public void handleEvent(Event e) {
    int hSelection = hBar.getSelection();
    int destX = -hSelection - origin.x;
    Rectangle rect = image.getBounds();
    canvas.scroll(destX, 0, 0, 0, rect.width, rect.height, false);
    origin.x = -hSelection;
   }
  });
  final ScrollBar vBar = canvas.getVerticalBar();
  vBar.addListener(SWT.Selection, new Listener() {
   public void handleEvent(Event e) {
    int vSelection = vBar.getSelection();
    int destY = -vSelection - origin.y;
    Rectangle rect = image.getBounds();
    canvas.scroll(0, destY, 0, 0, rect.width, rect.height, false);
    origin.y = -vSelection;
   }
  });
  canvas.addListener(SWT.Resize, new Listener() {
   public void handleEvent(Event e) {
    Rectangle rect = image.getBounds();
    Rectangle client = canvas.getClientArea();
    hBar.setMaximum(rect.width);
    vBar.setMaximum(rect.height);
    hBar.setThumb(Math.min(rect.width, client.width));
    vBar.setThumb(Math.min(rect.height, client.height));
    int hPage = rect.width - client.width;
    int vPage = rect.height - client.height;
    int hSelection = hBar.getSelection();
    int vSelection = vBar.getSelection();
    if (hSelection >= hPage) {
     if (hPage <= 0)
      hSelection = 0;
     origin.x = -hSelection;
    }
    if (vSelection >= vPage) {
     if (vPage <= 0)
      vSelection = 0;
     origin.y = -vSelection;
    }
    canvas.redraw();
   }
  });
  canvas.addListener(SWT.Paint, new Listener() {
   public void handleEvent(Event e) {
    GC gc = e.gc;
    gc.drawImage(image, origin.x, origin.y);
    Rectangle rect = image.getBounds();
    Rectangle client = canvas.getClientArea();
    int marginWidth = client.width - rect.width;
    if (marginWidth > 0) {
     gc.fillRectangle(rect.width, 0, marginWidth, client.height);
    }
    int marginHeight = client.height - rect.height;
    if (marginHeight > 0) {
     gc
       .fillRectangle(0, rect.height, client.width,marginHeight);
    }
   }
  });