Java上传bytea类型图片到数据库并读取示例

try {
     //上传图片
File filedata=new File("C:\\Users\\Administrator\\Desktop\\东莞市经济贸易学校图书馆新生读者导入原始资料\\2018\\1802班","陈星娴180205.JPG");
String path="C:\\Users\\Administrator\\Desktop";
String filename="180102.JPG";
         String strSQL = ""; 
         Connection dbConn = null; 
         PreparedStatement dbStat = null; 
         //ResultSet dbRs = null; 
             dbConn = JDBCUtil.getConnectionELIB(); 
             
     strSQL="UPDATE lt_dzheinfo SET zpian=? WHERE dzzhao='BY03C000046';";
     dbStat = dbConn.prepareStatement(strSQL);
     // 设置图片文件
     FileInputStream inputStream = new FileInputStream(filedata);
        dbStat.setBinaryStream(1, inputStream, (int) filedata.length());
     
     // 执行SQL
        dbStat.execute();
        dbStat.close();
             
        //下载图片
             strSQL="SELECT zpian FROM lt_dzheinfo where dzzhao='038'";
             dbStat = dbConn.prepareStatement(strSQL);
ResultSet rs = dbStat.executeQuery();
 
while (rs.next()) {
InputStream input = rs.getBinaryStream(1);
FileOutputStream outputStream = new FileOutputStream(new File(
path + "\\_" + filename));