downpic.java

从SQL server数据库中读取并显示图片

 
  import   java.sql.*;   
  import   java.io.*;   
  import   javax.swing.*;   
  import   java.awt.event.*;   
  import   java.awt.*;   
  class   DownPic   extends   JFrame   implements   ActionListener{   
  JButton   buttonNext=new   JButton("Next");   
  JButton   buttonPrevious=new   JButton("Previous");     
  JLabel   labelImage=new   JLabel();     
  JLabel   labelFileName=new   JLabel();   
  Connection   conn=null;   
  ResultSet   rst=null;   
  byte   []buffer=null;   
          static   {           
          try   {               
                  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");   
          }           
          catch   (Exception   e)   {               
                  e.printStackTrace();           
          }               
    }       
    DownPic()   
    {   
      Container   con=this.getContentPane();   
      JPanel   panelSouth=new   JPanel();   
      panelSouth.setLayout(new   GridLayout(1,2));   
      panelSouth.add(buttonNext);   
      panelSouth.add(buttonPrevious);   
        
      buttonNext.addActionListener(this);   
      buttonPrevious.addActionListener(this);   
        
        
      con.add(panelSouth,BorderLayout.SOUTH);   
      con.add(labelImage,BorderLayout.CENTER);   
      con.add(labelFileName,BorderLayout.NORTH);   
        
      String   stringSQL="select   *   from   imageTable";   
        try   {   
                  conn   =   DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ogsadaitest","sa","zfy");   
                            
                          Statement   stm=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);   
                          rst=stm.executeQuery(stringSQL);   
                            
                          rst.next();   
                            
                          labelFileName.setText(rst.getString(1));   
                          buffer=rst.getBytes(2);   
                          labelImage.setIcon(new   ImageIcon(buffer));   
                          
    }   
    catch   (SQLException   e)   {   
          e.printStackTrace();   
    }   
    this.setSize(600,400);   
    this.show();       
  }   
  public   static   void   main(String[]   args)   
  {           
          new   DownPic();   
  }   
  public   void   actionPerformed(ActionEvent   ae)   
  {   
  try{   
  if(ae.getSource()==buttonNext)   
  {   
  if(!rst.isLast())   
          rst.next();   
          }   
  if(ae.getSource()==buttonPrevious)   
  {   
  if(!rst.isFirst())   
          rst.previous();   
          }   
  buffer=rst.getBytes(2);   
          labelImage.setIcon(new   ImageIcon(buffer));   
          labelFileName.setText(rst.getString(1));   
          }   
          catch(Exception   e)   
          {   
          e.printStackTrace();   
          }   
  }   
  }