sqlserver数据库存储图片

/**
     * 存储图片方法测试
     */
    public static void pictureStoreSqlserver(){
        try {
            
            FileInputStream fis = null;
            File file = new File("C:/Users/v-guoxiao/Desktop/ReferencePicture/image1.jpeg");
            System.out.println(file);
            fis = new FileInputStream(file);
            
            PreparedStatement preparedStatement = connection.prepareStatement("Insert into referencepicture (id,bytepic) values (?,?)");
            preparedStatement.setString(1, "1");
            preparedStatement.setBinaryStream(2, fis, file.length());
            preparedStatement.executeUpdate();
            preparedStatement.close();
            fis.close();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (FileNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

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

/**
     * 获取数据保存图片文件
     * ***************************直接按照路径保存，成功
     * @return
     * @throws Exception
     */
    @SuppressWarnings("unused")
    public static BufferedImage getImgFromDb() throws Exception {
        BufferedImage image = null;
        try {
//            PreparedStatement stmt = connection.prepareStatement("select imagesample from reference_picture_test where registrationnumber='35721665'");
            PreparedStatement stmt = connection.prepareStatement("select imagesample from reference_mark");
            ResultSet rs = stmt.executeQuery();
            while(rs.next()){
                image = ImageIO.read(rs.getBinaryStream(1));
                if(image != null){
                    Image big = image.getScaledInstance(310, 270, Image.SCALE_DEFAULT);
                    BufferedImage biginput = new BufferedImage(310, 270, BufferedImage.TYPE_INT_BGR);
                    biginput.getGraphics().drawImage(image, 0, 0, 310, 270, null);
                    ImageIO.write(biginput, "jpg", new File("C:/Users/v-guoxiao/Desktop/ReferencePicture/"+UUID.randomUUID()+".jpg"));
                }
            }
            rs.close();
            stmt.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return image;
    }

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

/**
*  存储图片  
*
*/
static BASE64Encoder encoder = new sun.misc.BASE64Encoder();  
    static BASE64Decoder decoder = new sun.misc.BASE64Decoder();
    public static void storeBytePic(){
        File file = new File("C:/Users/v-guoxiao/Desktop/ReferencePicture/image1.png");
        try {
            FileInputStream fis = new FileInputStream(file);
            byte[] bs = new byte[fis.available()];
            fis.read(bs);
            fis.close();
            BASE64Encoder encoders = new BASE64Encoder();
            String endString = encoders.encode(bs);
            
            PreparedStatement preparedStatement = connection.prepareStatement("Insert into refpic (id,bytepic) values (?,?)");
            preparedStatement.setString(1, "1");
            preparedStatement.setString(2, endString);
            preparedStatement.executeUpdate();
            preparedStatement.close();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

public static void getBase64Pic(){
        PreparedStatement stmt;
        try {
//            stmt = connection.prepareStatement("select bytepic from refpic");
            stmt = connection.prepareStatement("sselect imagesample from reference_mark");
            ResultSet rs = stmt.executeQuery();
            while(rs.next()){
                String base = rs.getString(1);
                byte[] bs = decoder.decodeBuffer(base);
                
                for(int i = 0; i < bs.length; i++){
                    if(bs[i] < 0){
                        bs[i] += 256;
                    }
                }
                FileOutputStream fos = new FileOutputStream("C:/Users/v-guoxiao/Desktop/ReferencePicture/"+UUID.randomUUID()+".jpg");
                fos.write(bs);
                fos.flush();
                fos.close();
            }
            
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }