Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

JAVA¶ÁÈ¡OracleÖеÄblobͼƬ×ֶβ¢ÏÔʾ

½üÆÚ£¬ÔÚ¸ø¿Í»§×öÒ»¸öDemoÒ³ÃæÊ±£¬ÐèÒªÓÃJAVA¶ÁÈ¡OracleÖеÄblobͼƬ×ֶβ¢ÏÔʾ£¬Ôڴ˹ý³ÌÖУ¬Óöµ½Ò»Ð©ÎÊÌ⣬ÀýÈ磺Á¬½ÓOracleÊý¾Ý¿â¶ÁÈ¡blob×Ö¶ÎÊý¾Ý£¬¶ÔͼƬbyteÊý¾Ý½øÐÐËõ·ÅµÈ£»Ìش˼Ǽ£¬¸ø×Ô¼º±¸Íü£¬¸ø´ó¼Ò²Î¿¼¡£
Õû¸öÁ÷³Ì·ÖΪËIJ½£¬Á¬½ÓoracleÊý¾Ý¿â -> ¶ÁÈ¡blobͼƬ×Ö¶Î -> ¶ÔͼƬ½øÐÐËõ·Å ->°ÑͼƬչʾÔÚjspÒ³ÃæÉÏ¡£
ÏÂÃæ½øÐÐÏêϸÃèÊö£º
1. javaÁ¬½ÓOracle
×¢£ºÊý¾Ý¿âÊÇOracle10g°æ±¾Îª10.2.0, ÔÚÊý¾Ý¿âÖУ¬Í¼Æ¬×Ö¶ÎÀàÐÍΪBLOB¡£
javaÖÐͨ³£Ê¹ÓõÄÊÇͨ¹ýjdbcÇý¶¯À´Á¬½ÓÊý¾Ý¿â£¬oracleÒ²²»ÀýÍ⣬Òò´Ë±ØÐëÏÂÔØÒ»¸öOracleÇý¶¯µÄjdbcÐèÒªÈ¥ÍøÉϽøÐÐÏÂÔØ,Ãû³ÆÎª ojdbc14.jar¡£
ÏÂÔØµØÖ·Îª:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc101040.html
ÏÂÔØÁËÇý¶¯Ö®ºó£¬¿ÉÒÔʹÓÃÇý¶¯ÀïÌṩµÄ½Ó¿Ú½øÐÐÁ¬½Ó£¬¾ßÌå´úÂëÈçÏ£º
import java.sql.*;
import java.io.*;

import javax.imageio.ImageIO;
import java.awt.image.BufferedImage;
import java.awt.image.AffineTransformOp;
import java.awt.geom.AffineTransform;

public class OracleQueryBean {
private final String oracleDriverName = "oracle.jdbc.driver.OracleDriver";
private Connection myConnection = null;
/*ͼƬ±íÃû*/
private String strTabName;
/*ͼƬID×Ö¶ÎÃû*/
private String strIDName;
/*ͼƬ×Ö¶ÎÃû*/
private String strImgName;
/**
* ¼ÓÔØjavaÁ¬½ÓOracleµÄjdbcÇý¶¯
*/
public OracleQueryBean(){
try{
Class.forName(oracleDriverName);
}catch(ClassNotFoundException ex){
System.out.println("¼ÓÔØjdbcÇý¶¯Ê§°Ü,Ô­Òò:" + ex.getMessage());
}
}
/**
* »ñÈ¡OracleÁ¬½Ó¶ÔÏó
* @return Connection
*/
public Connection getConnection(){
try{
//Óû§Ãû+ÃÜÂë; ÒÔÏÂʹÓõÄTest¾ÍÊÇOracleÀïµÄ±í¿Õ¼ä
//´ÓÅäÖÃÎļþÖжÁÈ¡Êý¾Ý¿âÐÅÏ¢
GetPara oGetPara = new GetPara();
String strIP = oGetPara.getPara("serverip");
String strPort = oGetPara.getPara("port");
String strDBName = oGetPara.getPara("dbname");
String strUser = oGetPara.getPara("user");


Ïà¹ØÎĵµ£º

×î½üÔÚ×öOracleÁÙʱ±í¼ÓÔØ ×ªÔØÒ»¸öÒÔ±ã²éѯ

×ªÔØ
DML statements on temporary tables do not generate redo logs for the data changes. However, undo logs for the data 
and redo logs for the undo logs are generated. Data from the temporary table is automatically 
dropped in the case of session termination, either when the user logs o ......

C#»·¾³ÏÂÍùoracleÖеÄblob×ֶβåÈëÎļþ

Ìí¼ÓÒýÓà           
using System.Data.OracleClient;
Ö÷ÒªÓõ½ÁËÁ½¸öÀà
System.Data.OracleClient.OracleConnection ±íʾһ¸öµ½Êý¾Ý¿âµÄÁ¬½Ó¡£´ËÀàÎÞ·¨¼Ì³Ð¡£
System.Data.OracleClient.OracleCommand   ±íʾÕë¶ÔÊý¾Ý¿âÖ´ÐÐµÄ SQL Óï¾ä»ò´æ ......

oracleËø²éѯ³£Óýű¾

with
  lockinfo as (
   select distinct decode(sql_hash_value, 0, prev_hash_value, sql_hash_value) sql_hash_value, decode  (sql_hash_value, 0, prev_sql_addr, sql_address) sql_address, s.sid, l.id1 object_id, l.block
      from v$lock l, v$session s
&n ......

ORACLE EXP/IMP ²ÎÊýÏê½â

ORACLE EXP/IMP ²ÎÊýÏê½â2010-03-22 17:53OracleÊý¾Ý¿âʹÓÃIMP/EXP¹¤¾ß½øÐÐÊý¾Ýµ¼ÈëÓëµ¼³ö½éÉÜ£º
1.ʹÓÃÃüÁîÐУº
Êý¾Ýµ¼³ö£º
1.½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§ÃûsystemÃÜÂëmanagerµ¼³öµ½D:\Test_bak.dmpÖÐ
exp system/manager@ora10 file=d:\Test_bak.dmp full=y
ora10±íʾÊý¾Ý¿âÃû
2.½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ