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)
Ïà¹ØÎĵµ£º
Javaѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
Óöµ½¹ýÕâÑùÒ»¸öÇé¿ö£¬ÐèÒªÓÃjava¶ÁÈ¡Ò»¸ö200MµÄÎı¾¸ñʽÎļþ£¬¶øÇÒ»¹ÐèÒª¶ÔÎļþµÄÄÚÈÝ×ö½âÎö£¬½øÐзִʡ£Èç¹ûÓÃJVMµÄĬ
ÈÏÉèÖã¬ÀûÓÃScannerÀàÖ»ÄܶÁ³ö4M´óСÄÚÈÝ£¬ÓÚÊÇÎÒ¾ÍÔÚÍøÉÏËÑË÷£¬µ«ÊÇÍøÉÏûÓÐÕÒµ½Ò»ÆªÎÄÕÂÊÇÎÒËùÐèÒªµÄÄÚÈÝ¡£ÓÚÊÇÎÒÖ»ºÃ·thinking
in
java£¬·¢ÏÖÁËÒ»¸öjavaµÄnioÀïÓиöMappedByteBufferÀ࣬ËûµÄ×÷Ó ......
java Óë c# 3des ¼Ó½âÃÜ
Ö÷Òª²îÒìÈçÏ£º
1¡¢ ¶ÔÓÚ´ý¼ÓÃܽâÃܵÄÊý¾Ý£¬¸÷×ÔµÄÌî³äģʽ²»Ò»Ñù
C#µÄģʽÓУºANSIX923¡¢ISO10126¡¢None¡¢PKCS7¡¢Zero£¬¶øJavaÓУºNoPadding¡¢PKCS5Padding¡¢SSL3Padding
2¡¢ ¸÷×ÔĬÈϵÄ3DESʵÏÖ£¬Ä£Ê½ºÍÌî³ä·½Ê½²»Ò»Ñù
C#µÄĬÈÏģʽΪCBC,ĬÈÏÌî³ä·½Ê½ÎªPKCS7; javaµÄĬÈÏģʽ ......
java½Ó¿ÚʵÏÖ
¶Ô³õѧÕßÀ´Ëµ£¬½Ó¿Ú²»ÊǺܺÃÀí½â¡£ÏÖ½«Ä³¸ßÊÖµÄһƪÎÄÕÂÌù³öÀ´£¬¹²´ó¼Ò·ÖÏí£¡
ÎÒÃÇÀ´¿´Ò»¸öÀà
class A {
private int a;
public int getA() {
return a;
}
}
Õâ¸öÀàµÄÊôÐÔÊÇ˽Óеģ¬Íâ½ç²»ÄÜ·ÃÎÊ£¬¶øÍâ½ç¿ÉÒÔͨ¹ý¹«Óз½·¨À´·ÃÎÊÕâ¸öÀà¡£ÎÒÃÇ˵һ¸öÀàµÄ¹«Óз½
·¨¾ÍÊÇÕâ¸öÀàµÄ¶ÔÍâ½Ó¿Ú¡£Í¨³£
......
Êý¾ÝÀàÐÍ£º
(4Àà8ÖÖ)
Âß¼ÐÍ£boolean
×Ö·ûÐÍ£ char
ÊýÖµÐÍ£º
ÕûÊýÐÍ£ byte, short, int, long
¸¡µãÊýÐÍ£ float, double
·Java ÓïÑÔÖл¹ÔÊÐíʹÓÃתÒå×Ö·û ‘\’ À´½«ÆäºóµÄ×Ö·ûת±äΪÆäËüµÄº¬Òå.‘\n’´ú±í»»Ðзû
·JavaÕûÐͳ£Á¿Ä¬ÈÏΪintÐÍ£¬ÉùÃ÷lon ......