savepic.java

向SQL server数据库中存入一张图片

 import   java.sql.*;   
  import   java.io.*;   
  class   SavePic   {       
    static   {           
          try   {               
                  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");   
          }           
          catch   (Exception   e)   {               
                  e.printStackTrace();           
          }               
    }       
    SavePic()   
    {   
        try   {   
                  Connection   conn   =   DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ogsadaitest","sa","zfy");   
                          File   []files=new   File("image").listFiles(new   FilenameFilter()   
                          {   
                          public   boolean   accept(File   dir,String   name)   
                          {   
                          if(name.endsWith(".jpg"))   
                          {   
                          return   true;   
                          }   
                          return   false;   
                          }   
                          });   
                  for(int   i=0;i<files.length;i++)   
                  {   
                  // System.out.println(files[i]);   
                  try{   
                  FileInputStream   fileImage=new   FileInputStream(files[i]);   
                  ByteArrayOutputStream   byteArray=new   ByteArrayOutputStream();   
                  byte   buffer[]=new   byte[1024];   
                  int   length=-1;   
                  while((length=fileImage.read(buffer))!=-1)   
                  {   
                  // byteArray.write(buffer,0,length);   
                  byteArray.write(buffer);   
                  }   
                  String   insertString="insert   into   imageTable(imageName,imageData,length)   values(?,?,?)";   
                  PreparedStatement   insertStm=conn.prepareStatement(insertString);   
                  insertStm.setString(1,files[i].getName());   
                  insertStm.setBytes(2,byteArray.toByteArray());   
                  insertStm.setInt(3,(int)files[i].length());   
                  insertStm.execute();   
                  fileImage.close();   
                  byteArray.close();   
                  conn.close();   
                  }   
                  catch(Exception   ee)   
                  {   
                  ee.printStackTrace();   
                  }   
                  }   
    
                  conn.close();   
    }   
    catch   (SQLException   e)   {   
          e.printStackTrace();   
    }       
  }   
  public   static   void   main(String[]   args)   
  {           
          new   SavePic();   
  }   
  }