ÂíÊ¿±øoracleÎÊÌâ
ÓÐËѧϰ¹ýÂíÊ¿±øµÄOracle£¬ÀÏÂíµÄÊÓÆµÄÄЩ±í¶¼ÊÇÄÃÀ´Ö±½ÓÓõģ¬ÓÐËÓÐÔ´Â룿ÎÒÖ±½Óµ¼½øÊý¾Ý¿âÀ¸Ðл¡¢ÖÁ¼«
ÂíÊ¿±ø¡£¡£¡£¡£ ²»ÖªµÀ
ÓÑÇéup
»¹ÊÇ×Ô¼ºÒ»²½Ò»²½À´×ö°É£¬Ö±½Óµ¼È룬ѧϰЧ¹û²îºÜ¶à°¡£¡
×Ô¼º½¨±í°¡,½¨±í¶¼¾õµÃÀ§Äѵϰ,¾Í¸üÒªÊÖ¶¯½¨±íÀï......
»¹ÊÇ×Ô¼º¶®½¨¿â£¬½¨±í£¬½¨ÊÓͼ£¬½¨´¥·¢Æ÷µÈµÈ£¬Ò»²½Ò»²½À´ºÃµã£¬ÕâÑù»ù´¡ÔúʵÀιÌЩ!
·´Õý¶¼ÊÇѧϰ£¬ÒªÑ§¾ÍѧºÃЩ£¡
ºÇºÇ Ö»Ìý˵¹ýÂíÊ¿±øµÄJAVA ÎÒÃǰàÖ»ÒªÊǸöѧJAVAµÄÈ˶¼ÔÚ¿´ËûµÄÊÓÆµ
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÏÈ˵Ã÷Ò»ÏÂÇé¿ö£ºÓÐÒ»¸örec1.batµÃÅú´¦ÀíÎļþÀï±ß´úÂëÈçÏ£º
SET ORACLE_SID=TosmecDB
sqlPLUS /nolog "@c:\tosmec\sys\syscom\TosmecHotSub1.sql"
TosmecHotSub1.sqlµÄÎļþÄÚÈÝÈçÏ ......
±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......