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' f