package com.service;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.ArrayList;
import oracle.sql.BLOB;
import com.litsoft.cctv.util.propertiesUtil;
/**
* 由于需要将两个不同库的的照片进行更新,表里面存照片的字段是blob类型的,
* 琢磨来一下,直接将结果select查询出来再update行不通,所以先将图片从库里
* 导到本地,然后在从本地拿数据进行更新操作
*
*/
public class UpdateImage{
/**
* 我把数据库的连接信息写到properties文件里
*/
private String toUrl = "repast.url";
private String toUserName= "repast.username";
private String toPassword = "repast.password";
private String fromUrl = "manage.url";
private String fromUserName = "manage.username";
private String fromPassword = "manage.password";
/**
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception {
CopyOfImportImg i = new CopyOfImportImg();
i.exportImage();
List<String> accounts = readfile("D:\\image");
i.updateImage(accounts);
}
/**
* 导出照片到本地
*/
public void exportImage(){
long start = System.currentTimeMillis();
Connection conn = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
更新用blob字段存储照片的Java代码
最新推荐文章于 2024-04-26 16:37:52 发布