Oracle Functionµ÷ÓÃjava´úÂë
ÔÎÄ´«ËÍÃÅ£ºhttp://www.blogjava.net/improviser/archive/2008/12/07/244911.html
ÔÚǰһƪÎÄÕÂÖмòµ¥½éÉÜÁËJAVA³ÌÐòÈçºÎµ÷ÓÃOracle´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨³ÌÐò½á¹¹£¬ ±¾ÎĽ«½éÉÜJAVA¸úOracleµÄÁíÒ»ÖÖ¹ØÏµ£¬¼´Í¨¹ýJAVA±àдOracle´æ´¢¹ý³Ì¡£ ͨ³£Çé¿öÏ£¬ÎÒÃǶ¼ÊÇʹÓÃOracleÊý¾Ý¿âϵͳÖеÄps/sqlÓï¾äÀ´Îªoracle±àд¸÷ÖÖ´æ´¢¹ý³Ì£¬²»¹ý£¬ÔÚOracleµÄµÚ°Ë¸ö°æ±¾8Ö®ºó£¬ÎªÎÒÃÇÌṩÁ˱àд´æ´¢¹ý³ÌµÄÁíÒ»ÖÖеÄÑ¡Ôñ£¬ÄǾÍÊÇʹÓÃJAVAÀ´±àдOracle´æ´¢¹ý³Ì¡£´ÓOracle8.0°æ±¾¿ªÊ¼£¬ÔÚOracleÊý¾Ý¿âϵͳÖÐ×Ô´øÁËjavaÐéÄâ»újvm£¬Òò´ËʹµÃOracleÄÚÖÃÁ˶ÔJAVAµÄÈ«ÃæÖ§³Ö£¬ÎÒÃÇÔÚʹÓÃJAVA¿ÉÒÔʵÏÖµÄÈκι¦ÄÜÏÖÔÚ¶¼¿ÉÒԷŵ½OracleÖÐÀ´ÊµÏÖ£¬µ±È»ÎÒÃÇÒ²¿ÉÒÔÔÚoracleÖÐÀ´²Ù×÷ÆäËûÊý¾Ý¿â¡£JAVAµÄ¼ÓÈëÈÃOracleÕ¹ÄÜÁ¦µÃµ½ÁËÉý»ª£¬ÎÒÃÇ¿ÉÒÔ¶¨ÒåÒ»¸ö´¥·¢Æ÷À´ÔÚ½øÐÐÈκÎÊý¾Ý¿â²Ù×÷µÄʱºò¶ÔÍâ½ç½øÐÐÆäËû²Ù×÷µÄ¹¦ÄÜ¡£
ÏÂÃæ×¼±¸¾Ù¸öÀý×ÓÀ´ËµÃ÷ÏÂÈçºÎͨ¹ýJAVAÀ´´´½¨Oracle´æ´¢¹ý³Ì£¬Àý×Ó²»ÔÚÓÚÓжà¸ß¼¶£¬¹¦Äܲ»ÔÚÓÚ¶àÍêÉÆ£¬ÎÒÏ룬Èç¹ûÄÜ´ÓÒ»¸ö¼òµ¥Àý×Ó£¬ÒýÉê³öÈ¥£¬È¥·±Ñܸü¶àµÄ·½·¨£¬È¥ÊµÏÖ¸ü¶àÄã×Ô¼ºÐèÒªµÄ¹¦ÄÜ£¬Õâ²ÅÊǼòµ¥Àý×ÓµÄ×÷Óá£ËùÒÔ£¬ÈÏΪÎÒдµÄ¼òµ¥£¬Ð´µÄ·ôdzµÄÈËÄã¿ÉÒÔ²»Óÿ´£¬µ«ÊÇÎÒд³öÀ´¾ÍÊÇΪÁËÈÃÈκÎÓÐJAVA»ù´¡µÄÈ˶¼ÄÜÈÝÒ×¶®µÃ£¬¶ø´Ó¼òµ¥µÄÀý×ÓÈ¥¹¹Ôì³öÆäËûµÄÓ¦Ó᣸öÈËÈÏΪ£¬ÖйúÈí¼þ½ç¸üÐèÒªÓеijÌÐòÔ±ËØÖÊ£¬¾ÍÊÇÄܸü¶à°ïÖúÄÇЩ³õѧÕߣ¬ÈÃËûÃÇÉÙ×ßÍä·£¬²ÅÄÜÈÃÎÒ¹úµÄITÐÐÒµÓиüºÃµÄ·¢Õ¹£¬¶ÔÄÇЩ½«³õѧÕßµÄÎÊÌâ¾Ü֮ǧÀïÖ®ÍâµÄ³ÌÐòÔ±µÄ×ö·¨£¬Ôڴ˱íʾÒź¶....
µ±È»£¬ÒÔÉÏÊÇÌâÍâ»°£¬µ«ÊÇÏ£ÍûÄÜÒýÆð´ó¼ÒµÄ˼¿¼£¬£¬£¬£¬ÄÜÒýÆðÔÚÎÒ²©¿Í»°ÎÒ·¢µÄÄÚÈݼòµ¥µÄÈ˵ķ´Ë¼¡£¡£¡£
¶þ¡¢Ê¹ÓÃJAVA´´½¨Oracle´æ´¢¹ý³Ì
ÏÈ¿´ÏÂÈçºÎʹÓÃJAVAÀ´±àдOracle´æ´¢¹ý³Ì£¬ÎÒÃÇÔÚOracleµÄsql plusÖбàдÓï¾ä¡£
¢ñ¡¢Æô¶¯SQL PLUS
¢ò¡¢±àдJAVAÀ࣬¶¨ÒåJAVAÀà±ðÃû£¬±¾´æ´¢¹ý³ÌΪ¼òµ¥µØÊä³ö´«Èë²ÎÊýµÄƽ·½Öµ¡£
create or replace and compile java source named "PF" as
/**
*ͨ¹ýJAVAÀàÀ´ ´´½¨Oracle´æ´¢¹ý³Ì
*
**/
package org.oraclejava.pro;
public class javaCreatePro
{
public static String test( int num)
Ïà¹ØÎĵµ£º
ÎÄ˼ÐÅÏ¢¼¼ÊõÓÐÏÞ¹«Ë¾www.vanceinfo.com£¨Å¦½»ËùÉÏÊдúÂ룺VIT£©³ÉÁ¢ÓÚ1995Ä꣬ÊÇÒ»¼ÒÐÅÏ¢¼¼Êõ·þÎñÌṩÉ̼°ÔÚÖйú¾ÓÁìÏȵØÎ»µÄÀë°¶Èí¼þ¿ª·¢¹«Ë¾Ö®Ò»¡£ÎÄ˼ÊǵÚÒ»¼ÒÔÚŦԼ¹ÉƱ½»Ò×ËùÉÏÊеÄÖйúÈí¼þ·þÎñÍâ°üÆóÒµ¡£¾Ý¹ú¼ÊÊý¾Ý¹«Ë¾(IDC)µÄͳ¼Æ, ÒÔ2007ÄêÏúÊÛ¶îºâÁ¿, ÎÄ˼ÐÅÏ¢¼¼ÊõÔÚΪŷÃÀÊг¡ÌṩÀë°¶Èí¼þ¿ª·¢ÐÐÒµÖÐλ¾ÓÖйúµÚÒ ......
java Óë c# 3des ¼Ó½âÃÜ
Ö÷Òª²îÒìÈçÏ£º
1¡¢ ¶ÔÓÚ´ý¼ÓÃܽâÃܵÄÊý¾Ý£¬¸÷×ÔµÄÌî³äģʽ²»Ò»Ñù
C#µÄģʽÓУºANSIX923¡¢ISO10126¡¢None¡¢PKCS7¡¢Zero£¬¶øJavaÓУºNoPadding¡¢PKCS5Padding¡¢SSL3Padding
2¡¢ ¸÷×ÔĬÈϵÄ3DESʵÏÖ£¬Ä£Ê½ºÍÌî³ä·½Ê½²»Ò»Ñù
C#µÄĬÈÏģʽΪCBC,ĬÈÏÌî³ä·½Ê½ÎªPKCS7; javaµÄĬÈÏģʽ ......
ÎÒÏÖÔÚÊÇÈí¼þѧԺ´ó¶þµÄѧÉú£¬ÎÒÃÇѧµÄ½Ì²ÄÊÇ¡¶JavaÓïÑÔ³ÌÐòÉè¼Æ¡·£¬ÏÖÔÚѧµÄÊǽø½×ƪ£¬¿ÉÊÇÎҸоõºÃÏñ»¹ÊÇʲô¶¼²»»á°¡£¡Èç¹ûÕæ¸øÎÒÒ»¸öÌâÄ¿ÈÃÎÒ×Ô¼ºÈ¥×ö£¬ÎÒÏëÎÒ»á×ö²»³öÀ´¡£²»¹ýÈç¹û¿´×ÅÊéȥʵÏÖÒ»¸ö¹¦ÄÜÎÒ»¹ÒªÏëºÜ¾Ã²Å»á×ö³öÀ´£¬Ò²ÐíÊÇÎÒѧϰ»¹²»¹ýÈÏÕæ£¬×Ô¼º¶¯ÊÖµÄÄÜÁ¦»¹Ã»ÓÐÑø³É£¬Ò²ÐíÊÇÎÒ´ ......
½á¹¹Ä£Ê½£¨££©
Adapter(ÊÊÅäÆ÷)
½«Ò»¸öÀàµÄ½Ó¿Úת»»³É¿Í»§Ï£ÍûµÄÁíÍâÒ»¸ö½Ó¿Ú¡£AdapterģʽʹµÃÔ±¾ÓÉÓÚ½Ó¿Ú²»¼æÈݶø²»ÄÜÒ»Æð¹¤×÷µÄÄÇЩÀà¿ÉÒÔÒ»Æð¹¤×÷¡£
Adapter·ÖΪ2ÖÖ:
ÀàÊÊÅäÆ÷ºÍ¶ÔÏóÊÊÅäÆ÷¡£AdapterºÍAdapteeÖ®¼äÊÇis-a¹ØÏµµÄʱºò£¬ÊôÓÚÀàÊÊÅäÆ÷£¬AdapterºÍAdapteeÖ®¼äÊÇhas-a¹ØÏµµÄʱºò£¬ÊôÓÚ¶ÔÏóÊÊÅäÆ÷¡£ ......