oracle读写图片(C#,Java)

 

//C#篇
            //写入
            string connStr = "Data Source=123;user id=123;password=123";
            OracleConnection conn = new OracleConnection(connStr);
            try
            {
                conn.Open();
                string fileName = @"D:\121.jpg";
                
                FileStream fs = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Read);
                byte[] image = new byte[fs.Length];
                fs.Read(image, 0, System.Convert.ToInt32(fs.Length));
                fs.Close();
                OracleCommand cmd = new OracleCommand("INSERT INTO table (pic_name,pic_content) VALUES ('123',empty_blob()) ", conn);
                cmd.ExecuteNonQuery();
                OracleDataAdapter da = new OracleDataAdapter("select * from r_pic_glss where glass_id='AKA0703TUB' and pic_url='123' for update ", conn);
                OracleCommandBuilder ocb = new OracleCommandBuilder(da);
                DataSet ds = new DataSet();
                da.Fill(ds);
                da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
                ds.Tables[0].Rows[0]["pic_content"] = image;
                da.Update(ds.Tables[0]);
            }
            catch (Exception ex)
            {
                //
            }
            finally
            {
                conn.Close();
            }

            //读取图片并放到listview
            imageList1 = loadPicbyName(picList);
            imageList1.ImageSize = new Size(128, 128);
            listView1.LargeImageList = imageList1;
            public  ImageList loadPicbyName(List<string> picNameList)
            {
                ImageList il = new ImageList();

                foreach (string pic in picNameList)
                {
                    Image image = queryImageDataByName(pic);
                    if (image != null)
                    {
                        il.Images.Add(image);
                    }
                }
                return il;
            }

            public Image queryImageDataByName(string pic_name)
            {
                string sql = string.Format(" select t.* from table t where t.pic_name = '{0}' ", pic_name);
                SqlBean sqlBean = new SqlBean();
                DataTable dt = sqlBean.doQuery(sql);
                if (dt != null && dt.Rows.Count > 0)
                {
                    System.Byte[] pic_content = (byte[])dt.Rows[0]["pic_content"];
                    MemoryStream buf = new MemoryStream(pic_content);
                    Image image = Image.FromStream(buf, true);
                    return image;
                }
                else
                {
                    return null;
                }
            }

 

//java

private FTPClient ftp;
	public byte[] downloadFileIntoByte(String remoteFilePath)throws Exception {
		byte[] byteRtn = new byte[0];
		try {
			long time1 = System.currentTimeMillis();
			if (!ftp.isConnected()) {
				connect();
			}
			ftp.enterLocalPassiveMode();
			ftp.setFileType(FTP.BINARY_FILE_TYPE);
			InputStream in = ftp.retrieveFileStream(remoteFilePath);			
			int c;
			byte[] bytes = new byte[1024];
			while ((c = in.read(bytes)) != -1) {
				int preByteRtnLen = byteRtn.length;
				byte[] byteRtnTemp = byteRtn;
				byteRtn = new byte[preByteRtnLen + c];
				System.arraycopy(byteRtnTemp, 0, byteRtn, 0, byteRtnTemp.length);
				if (c < 1024) {
					System.arraycopy(bytes, 0, byteRtn, preByteRtnLen, c);
				} else {
					System.arraycopy(bytes, 0, byteRtn, preByteRtnLen,
							1024);
				}				
			}			
			in.close();
			ftp.completePendingCommand();
		} catch (Exception e) {
			_log.error("downloadFileIntoByte [" + remoteFilePath + "] Fail", e);
			throw e;
		}
		return byteRtn;
	}
	private void insertIamgeIntoDB(RPicGlss rpg) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("    INSERT INTO table ");
		sql.append("    (pic_name, pic_content) ");
		sql.append("    VALUES ");
		sql.append("    (?, empty_blob) ");
		SqlBean sqlBean = new SqlBean(sql.toString);
		sqlBean.addParameter("123");
		int updateCount = sqlBean.executeUpdate();
		if (updateCount == 1) {
			sql.setLength(0);
			sqlBean = null;
			StringBuffer sql = new StringBuffer();
			sql.append("SELECT pic_content ");
			sql.append("FROM table ");
			sql.append("WHERE pic_name = ? ");
			sql.append("    FOR UPDATE ");
			sqlBean = new SqlBean(sql.toString());
			sqlBean.addParameter("123");
			List<Map> rtnLm = sqlBean.executeQuery();
			Blob blob = (Blob) rtnLm.get(0).get("pic_content");
			OutputStream os = blob.setBinaryStream(0);
			os.write(downloadFileIntoByte("D:\121.jpg"));
			os.flush();
			os.close();
		} else {
			throw new Exception("[Insert Record Fail] " + rpg.getPicUrl());
		}
	}