1 /**
 2      * 存储图片方法测试
 3      */
 4     public static void pictureStoreSqlserver(){
 5         try {
 6             
 7             FileInputStream fis = null;
 8             File file = new File("C:/Users/v-guoxiao/Desktop/ReferencePicture/image1.jpeg");
 9             System.out.println(file);
10             fis = new FileInputStream(file);
11             
12             PreparedStatement preparedStatement = connection.prepareStatement("Insert into referencepicture (id,bytepic) values (?,?)");
13             preparedStatement.setString(1, "1");
14             preparedStatement.setBinaryStream(2, fis, file.length());
15             preparedStatement.executeUpdate();
16             preparedStatement.close();
17             fis.close();
18         } catch (SQLException e) {
19             // TODO Auto-generated catch block
20             e.printStackTrace();
21         } catch (FileNotFoundException e) {
22             // TODO Auto-generated catch block
23             e.printStackTrace();
24         } catch (IOException e) {
25             // TODO Auto-generated catch block
26             e.printStackTrace();
27         }
28     }

注意：将数据库中对应字段数据类型设置为 image 类型

 1 /**
 2      * 获取数据保存图片文件
 3      * ***************************直接按照路径保存，成功
 4      * @return
 5      * @throws Exception
 6      */
 7     @SuppressWarnings("unused")
 8     public static BufferedImage getImgFromDb() throws Exception {
 9         BufferedImage image = null;
10         try {
11 //            PreparedStatement stmt = connection.prepareStatement("select imagesample from reference_picture_test where registrationnumber='35721665'");
12             PreparedStatement stmt = connection.prepareStatement("select imagesample from reference_mark");
13             ResultSet rs = stmt.executeQuery();
14             while(rs.next()){
15                 image = ImageIO.read(rs.getBinaryStream(1));
16                 if(image != null){
17                     Image big = image.getScaledInstance(310, 270, Image.SCALE_DEFAULT);
18                     BufferedImage biginput = new BufferedImage(310, 270, BufferedImage.TYPE_INT_BGR);
19                     biginput.getGraphics().drawImage(image, 0, 0, 310, 270, null);
20                     ImageIO.write(biginput, "jpg", new File("C:/Users/v-guoxiao/Desktop/ReferencePicture/"+UUID.randomUUID()+".jpg"));
21                 }
22             }
23             rs.close();
24             stmt.close();
25             connection.close();
26         } catch (Exception e) {
27             e.printStackTrace();
28         }
29         return image;
30     }

 

基于base64存储图片，对应字段数据类型设置为 varchar(MAX)

 1 /**
 2 *  存储图片  
 3 *
 4 */
 5 static BASE64Encoder encoder = new sun.misc.BASE64Encoder();  
 6     static BASE64Decoder decoder = new sun.misc.BASE64Decoder();
 7     public static void storeBytePic(){
 8         File file = new File("C:/Users/v-guoxiao/Desktop/ReferencePicture/image1.png");
 9         try {
10             FileInputStream fis = new FileInputStream(file);
11             byte[] bs = new byte[fis.available()];
12             fis.read(bs);
13             fis.close();
14             BASE64Encoder encoders = new BASE64Encoder();
15             String endString = encoders.encode(bs);
16             
17             PreparedStatement preparedStatement = connection.prepareStatement("Insert into refpic (id,bytepic) values (?,?)");
18             preparedStatement.setString(1, "1");
19             preparedStatement.setString(2, endString);
20             preparedStatement.executeUpdate();
21             preparedStatement.close();
22         } catch (IOException e) {
23             // TODO Auto-generated catch block
24             e.printStackTrace();
25         } catch (SQLException e) {
26             // TODO Auto-generated catch block
27             e.printStackTrace();
28         }
29     }

 1 public static void getBase64Pic(){
 2         PreparedStatement stmt;
 3         try {
 4 //            stmt = connection.prepareStatement("select bytepic from refpic");
 5             stmt = connection.prepareStatement("sselect imagesample from reference_mark");
 6             ResultSet rs = stmt.executeQuery();
 7             while(rs.next()){
 8                 String base = rs.getString(1);
 9                 byte[] bs = decoder.decodeBuffer(base);
10                 
11                 for(int i = 0; i < bs.length; i++){
12                     if(bs[i] < 0){
13                         bs[i] += 256;
14                     }
15                 }
16                 FileOutputStream fos = new FileOutputStream("C:/Users/v-guoxiao/Desktop/ReferencePicture/"+UUID.randomUUID()+".jpg");
17                 fos.write(bs);
18                 fos.flush();
19                 fos.close();
20             }
21             
22         } catch (SQLException e) {
23             // TODO Auto-generated catch block
24             e.printStackTrace();
25         } catch (IOException e) {
26             // TODO Auto-generated catch block
27             e.printStackTrace();
28         }
29     }