oracleÖÐClob×Ö¶ÎÖеĻسµ»»ÐÐÔÚjspÖÐչʾµÄÎÊÌâ
ÔÚ¿ª·¢¹ý³Ì³öÏÖÕâôһ¸öÎÊÌ⣺
±ÈÈ磺һ¸ö×Ö¶Îcontent ÀàÐÍCLOB£¬ÕâÆäÖдæµÄÓпÉÄܸ´ÖÆÕ³Ìù¹ýÀ´µÄword excel htmlÖеÄÄÚÈÝ£¬ÓÃjava½«ÕâЩÄÚÈÝ´æÈ룬´æÈëºóÓÐÌØÊâµÄ·ûºÅ ±ÈÈç»Ø³µ»»Ðеȡ£ÄÇô²»ÄÜÕý³£Õ¹Ê¾µÄÊý¾Ý¡£
½â¾ö·½°¸£º
´æÈëÊý¾ÝµÄÊǽ«Õâ¸öÊý¾ÝcontentdataÔÚjsÖнøÐÐ
String(contentdata).replace(/&/g, "&").replace(/>/g, ">").replace(/</g, "<").replace(/"/g, """);
html±êÇ©±àÒë´¦Àí£¨´Ë´¦ÒýÓÃÔÚExt.util.Format.htmlEncode £¬Èç¹ûÊÇextÊý¾ÝÌá½»Ö±½ÓExt.util.Format.htmlEncode£¨contentdata£©£©
ÔÚºǫ́ÓÃÌá½»ÓÃ
Context initCtx = new InitialContext(); DataSource ds = (DataSource)JNDIUtil.lookup(initCtx) ;
Connection conn = ds.getConnection();
PreparedStatement ps=conn.prepareStatement("insert...values(?...)"),
ps.setObject(5,contentdata)
......
jspÖÐչʾ£ºsqlÓï¾äÖжԴË×ֶνøÐÐÕâÑùµÄ´¦Àí£ºselect REPLACE(REPLACE(content,chr(13),''),chr(10),'') content from table£»
Êä³ö£º
.....
<tr> <td><span> ÄÚ ÈÝ£º</span></td><td><span id="content" >
<% String content=rs.getClob(5)==null?"":rs.getClob(5).getSubString((long)1, (int)rs.getClob(5).length());//¶ÁÈ¡³öclobÊý¾Ý½øÐÐclobµ½×Ö·û´®µÄת»»%>
<script>
document.getElementById("content").innerHTML=String("<%=content%>").replace(/&/g, "&").replace(/>/g, ">").replace(/</g, "<").replace(/"/g, '"');//½«×ª»»ºóµÄ×Ö·û´®ÔÚ½øÐÐhtml±êÇ©µÄ·´±àÒ룬£¨´Ë´¦ÒýÓÃÔÚExt.util.Format.htmlDecode £¬Èç¹ûÊÇextÊý¾ÝÌá½»Ö±½ÓExt.util.Format.htmlDecode£¨content£©£©
</script>
&n
Ïà¹ØÎĵµ£º
[×ÊÁÏÀ´×ÔÓÚORACLEƵµÀ http://oracle.chinaitlab.com/induction/398193.html]
¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
¡¡¡¡ÀýÈç:
¡¡¡¡SELECT /*+ALL_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT';
¡¡¡ ......
Ò».ÅäÖñ¾µØNet·þÎñÃûÊǸÉʲôÓõģ¿
Èç¹ûҪͨ¹ýÍøÂç·ÃÎÊOracleÊý¾Ý¿â»òÆäËû·þÎñ£¬¾Í»áÓõ½Net·þÎñÃû¡£Oracle Net
Configuration AssistantÔÊÐíʹÓÃÓɱ¾µØÃüÃû½âÎöµÄÍøÂç·þÎñÃû¡£
¶þ.ÔõÑùÅäÖñ¾µØNet·þÎñÃû£¿
1.´ò¿ª->³ÌÐò/Oracle - OraClient10g_home1/ÅäÖúÍÒÆÖ²¹¤¾ß/Net
Configuration Assistant´ò¿ªNet Co ......
ÔÚÖ´ÐÐÒ»¸ö´æ´¢¹ý³Ì½¨±íʱ£¬³öÏÖÁËÕâ¸öORA-38301:ÎÞ·¨¶Ô»ØÊÕÕ¾ÖеĶÔÏóÖ´ÐÐDDL/DML´íÎó¡£·¢ÏÖÔÀ´ÕâÊÇ10GµÄÒ»¸öÐÂÌØÐÔ£¬»ØÊÕÕ¾¡£¶ÔÓÚdropµÄ±í²¢²»ÊÇÖ±½Óɾ³ýµôµÄ¡£¶øÊÇ·ÅÔÚ»ØÊÕÕ¾ÖÐÁË¡£RecycleBin¡£
¿ÉÊÇÔÚ»ØÊÕÕ¾ÖÐûÓв鵽Õâ¸ö±í¡£
select * from recyclebin;
ºÜÆæ¹Ö¡£
½øÐÐɾ³ý²Ù×÷¡£
½øÐÐɾ³ýºó£¬»¹ÊDz»ÄܶԸà ......
1.1.1 °²×°OracleÊý¾Ý¿â·þÎñ¶Ë
°´ÕÕ°²×°Ïòµ¼£¬ÕýÈ·°²×°Oracle 9i¡£
°´ÕÕĬÈÏÑ¡Ïµã»÷ÏÂÒ»²½£¬¼´¿É¡£
ͼ 2 2 Oracle °²×°Ïòµ¼ - »¶ÓʹÓÃ
ͼ 2 3 Oracle °²×°Ïòµ¼ - Îļþ¶¨Î»
ÕâÀÐè×¢ÒâOracleµÄ°²×°Îļþ·¾¶²»ÄÜ°üº¬¿Õ¸ñºÍÖÐÎÄÃû¡£Ä¬ÈÏ°²×°Â·¾¶ÊÇD:\oracle\ora92,ÕâÀィÒéʹÓÃÕâ¸ö°²×°Â·¾¶¡££¨°²×°£© ......
1¡¢°²×°
2¡¢´´½¨“±¾µØNet·þÎñÃû”
3¡¢PLSQL Developer Á¬½Ó²âÊÔ
4¡¢´´½¨±í¿Õ¼ä
1.´ò¿ªsqlplus¹¤¾ß£º
sqlplus /nolog
2. Á¬½ÓÊý¾Ý¿â£º
conn /as sysdba
3. ´´½¨±í¿Õ¼ä£º
create tablespace camds datafile 'D:\oracle\product\10.2.0\oradata\camds\camds.dbf' size  ......