Ò»£¬JavaScriptÖеı£Áô¹Ø¼ü×Ö
abstract extends instanceof static undefined
boolean false int super with
break final interface switch ......
ÓÉÓÚºǫ́ģ°åϵͳµÄÇ¿´ó£¬ÈçrailsµÄerb£¬javascriptµÄÄ£°åϵͳһֱ´¦ÓÚ±»´òѹ״̬£¬µ«ÓÖÓÉÓÚºǫ́µÄ¼¼Êõ·¢Õ¹¹ý¿ì£¬ÈÕÐÂÔÂÒ죬ÒÔ¼°AjaxÓ¦ÓÃµÄÆÕ¼°£¬javascript»¹ÊÇÓÐÒ»½åÖ®µØµÄ¡£ÈçÎÒÃÇÒª´Óºǫ́·µ»ØÒ»¸öHTMLƬ¶Ï£¬µ«ÊÂʵÉÏÎÒÃÇÓÀÔ¶Ö»ÄÜ·µ»ØÎı¾£¨responseText£©»òresponseXML£¬Èç¹ûÄãµÃµ½ÊÇjson£¬Æäʵºǫ́ÒÑÉÔÉÔµ÷ÓÃjavascript°ÑËüeval³Éjson¡£
ºÃÁË£¬¼ÈÈ»ÎÒÃÇÖªµÀËüÓÐÓÃÎäÖ®´¦£¬ÄÇôÕâÄ£°åϵͳµÄ¹æÄ£Ó¦¶à´óÄØ£¿»òÕß˵£¬ËüÓ¦¸ÃÓÐʲô¹¦ÄÜÄØ£¿ÎÊÌâºÜ¼òµ¥£¬ÎÒÃÇ¿´Ò»ÏÂÄÇЩºǫ́ģ°åϵͳ¾ÍÖªÁË¡£ºǫ́ģ°å·¢Õ¹ÁËÕâô¶àÄ꣬·Ç³£³ÉÊìÁË¡£Òò´ËÎÒÃÇ×öµÄÎÊÌâ¾ÍÊÇÈ¡Éá¡£
<table>
<% foreach $topic in param.topic %>
<tr class="topic">
<td><%= $topic.renderLink() %></td>
<td><%= $topic.creator.renderLink() %></td>
<td>
<% $count = topic.comments.count() - 1 %>
<% if $count == 1 %>
1 Post
<% elseif $count > 1 %>
<%= $count %> Posts
<% else %>
<% end %>
......
ת×Ô£ºhttp://hi.baidu.com/magus163/blog/item/a4f783178e39ef00c93d6de6.html
¡¾ÕâÆªÎÄÕÂÀý×Ó½²½âµÄ±È½ÏÏêϸ£¬ÎÒ¾Íת¹ýÀ´ÁË¡¿
Oracle9iÒýÈëÁËMERGEÃüÁî,ÄãÄܹ»ÔÚÒ»¸öSQLÓï¾äÖжÔÒ»¸ö±íͬʱִÐÐinsertsºÍupdates²Ù×÷. MERGEÃüÁî´ÓÒ»¸ö»ò¶à¸öÊý¾ÝÔ´ÖÐÑ¡ÔñÐÐÀ´updating»òinsertingµ½Ò»¸ö»ò¶à¸ö±í.
Oracle 10gÖÐMERGEÓÐÈçÏÂһЩ¸Ä½ø£º
1¡¢UPDATE»òINSERT×Ó¾äÊÇ¿ÉÑ¡µÄ
2¡¢UPDATEºÍINSERT×Ó¾ä¿ÉÒÔ¼ÓWHERE×Ó¾ä
3¡¢ONÌõ¼þÖÐʹÓó£Á¿¹ýÂËν´ÊÀ´insertËùÓеÄÐе½Ä¿±ê±íÖÐ,²»ÐèÒªÁ¬½ÓÔ´±íºÍÄ¿±ê±í
4¡¢UPDATE×Ó¾äºóÃæ¿ÉÒÔ¸úDELETE×Ó¾äÀ´È¥³ýһЩ²»ÐèÒªµÄÐÐ
Ê×ÏÈ´´½¨Ê¾Àý±í£º
create table PRODUCTS
(
PRODUCT_ID INTEGER,
PRODUCT_NAME VARCHAR2(60),
CATEGORY VARCHAR2(60)
);
insert into PRODUCTS values (1501, 'VIVITAR 35MM', 'ELECTRNCS');
insert into PRODUCTS values (1502, 'OLYMPUS IS50', 'ELECTRNCS');
insert into PRODUCTS values (1600, 'PLAY GYM', 'TOYS');
......
¿ªÆô£º
net start oracledbconsoleorcl
net start oracleOraDb10g_home1iSQL*Plus
net start oracleOraDb10g_home1TNSListener
net start oracleServiceORCL
net start oraclejobschedulerorcl //¿ÉÒÔ½ûÓÃ
¹Ø±Õ£º
net stop oracledbconsoleorcl
net stop oracleOraDb10g_home1iSQL*Plus
net stop oracleOraDb10g_home1TNSListener
net stop oracleServiceORCL
net stop oraclejobschedulerorcl//¿ÉÒÔ½ûÓÃ
¶ÔÓ¦·þÎñÀïÃæµÄÃû³Æ services.msc ......
OracleΪRDBMSÌṩÁ˶àÖÖµÄÕï¶Ï¹¤¾ß£¬Õï¶Ïʼþ(Event)ÊÇÆäÖÐÒ»ÖÖ³£ÓᢺÃÓõķ½·¨£¬ËüʹDBA¿ÉÒÔ·½±ãµÄת´¢Êý¾Ý¿â¸÷Öֽṹ¼°¸ú×ÙÌØ¶¨Ê¼þµÄ·¢Éú.
Ò»¡¢EventµÄͨ³£¸ñʽ¼°·ÖÀà
1¡¢ ͨ³£¸ñʽÈçÏ£º
EVENT="<ʼþÃû³Æ><¶¯×÷><¸ú×ÙÏîÄ¿><·¶Î§ÏÞ¶¨>"
2¡¢ Event·ÖÀà
Õï¶Ïʼþ´óÌåÉÏ¿ÉÒÔ·ÖΪËÄÀࣺ
a£® ת´¢Ààʼþ£ºËüÃÇÖ÷ÒªÓÃÓÚת´¢OracleµÄһЩ½á¹¹£¬ÀýÈçת´¢Ò»Ï¿ØÖÆÎļþ¡¢Êý¾ÝÎļþÍ·µÈÄÚÈÝ¡£
b£® ²¶×½Ààʼþ£ºËüÃÇÓÃÓÚ²¶×½Ò»Ð©ErrorʼþµÄ·¢Éú£¬ÀýÈç²¶×½Ò»ÏÂORA-04031·¢ÉúʱһЩRdbmsÐÅÏ¢£¬ÒÔÅжÏÊÇBug»¹ÊÇÆäËüÔÒòÒýÆðµÄÕâ·½ÃæµÄÎÊÌâ¡£
c£® ¸Ä±äÖ´ÐÐ;¾¶Ààʼþ£ºËüÃÇÓÃÓÚ¸ÄÖ÷һЩOracleÄÚ²¿´úÂëµÄÖ´ÐÐ;¾¶£¬ÀýÈçÉèÖÃ10269½«»áʹSmon½ø³Ì²»È¥ºÏ²¢ÄÇЩFreeµÄ¿Õ¼ä¡£
d£® ¸ú×ÙÀàʼþ£ºÕâÃÇÓÃÓÚ»ñȡһЩ¸ú×ÙÐÅÏ¢ÒÔÓÃÓÚSqlµ÷Óŵȷ½Ã棬×îµäÐ͵ıãÊÇ10046ÁË£¬½«»á¶ÔSql½øÐиú×Ù¡£
3¡¢ ˵Ã÷:
a£® Èç¹ûimmediate·ÅÔÚµÚÒ»¸ö˵Ã÷ÊÇÎÞÌõ¼þʼþ£¬¼´ÃüÁî·¢³ö¼´×ª´¢µ½¸ú×ÙÎļþ¡£
b£® trace nameλÓÚµÚ¶þ¡¢ÈýÏ³ýËüÃÇÍâµÄÆäËüÏÞ¶¨´ÊÊǹ©OracleÄÚ²¿¿ª·¢×éÓõġ£
c£® levelͨ³£Î»ÓÚ1-10Ö®¼ä(10 ......
p580 ÎÄÆ½
³£¼ûÎÊÌâÒ»:°º¹óµÄÊý¾Ý¿âÁ¬½Ó¿ªÏú
ÔÚÓ¦Óÿª·¢ÖУ¬¿Í»§¶ËΪÁËijÖÖÊý¾Ý¿â²Ù×÷¶ø½øÐÐijÖÖÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ªµÄ²Ù×÷¡£ÕâÊÇ2000Äêǰºó¶¯Ì¬ÍøÒ³Ó¦ÓÃÀàÐͳ£¼ûµÄ´íÎó¡£ÔÚÕâÖÖÓ¦ÓÃÖУ¬Ã¿µ±Ò»¸öÓû§µ¥»÷Ò»¸öÍøÒ³£¬Èç¹ûÕâ¸öÍøÒ³Ç¶ÈëÁËÊý¾Ý¿â²Ù×÷£¬Ôò¸ÃÍøÒ³Òª½øÐÐÒ»´Î»òÈô¸É´ÎµÄÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ª¡£µ±Ç°Öмä¼þ¼¼ÊõÄ£ÐÍÒѾ³ÉÊ죬Öмä¼þϵͳ°üº¬×ŶÔÊý¾Ý¿âÁ¬½Ó³ØµÄÖ§³Ö¡£ÍøÒ³Á¬½ÓÔì³ÉµÄÊý¾Ý¿âÁ¬½ÓºÍ¶Ï¿ª²Ù×÷ÒѾºÜÉÙ¼ûÁË¡£
ÔÚ¿Í»§/·þÎñÆ÷½á¹¹µÄÓ¦ÓÃÖУ¬Ó¦Óô°¿Ú½çÃæÉÏÒ²²»½¨Òé·ÅÖÃÊý¾Ý¿âÁ¬½Ó½Å±¾£¬¶øÊÇÔÚÓ¦ÓÃÆô¶¯ÆÚ¼äÖ®¼äÁ¬½ÓÊý¾Ý¿â¼´¿É¡£
³£¼ûÎÊÌâ¶þ£ºSQL²»ÄÜÖØÓú͹²Ïí³ØµÍЧ
ÔÚSQL¿ª·¢Öв»×¢ÒâÓï·¨¼°²éѯ½á¹¹µÄÒ»Ö±£¬½«µ¼ÖÂSQLÔÚÖ´Ðйý³ÌÖб»²»¶ÏµØ½âÎö£¬ºÄ·Ñϵͳ×ÊÔ´¡£ÀýÈ磬²éѯÌõ¼þÖÐÖ±½ÓÒýÓÃÊýÖµ£¬¶ø·Ç°ó¶¨±äÁ¿¡£ÕâÔÚÔËÐл·¾³Ï½«Òâζ×Ų»Í¬µÄSQL¡£ËäÈ»Æäº¬ÒåÒ»Ö£¬µ«OracleÈÔÈ»»á½«Æä½âÎöΪ²»Í¬µÄSQL¡£Oracle½¨ÒéʹÓð󶨱äÁ¿µÄ·½·¨½øÐÐÓαêµÄÖØÓá£
³£¼ûÎÊÌâÈý£º²»Á¼SQLÓï¾ä
²»Á¼SQLÊÇÖ¸ÄÇЩºÄ·ÑÁË´óÁ¿Ê±¼ä¡¢´óÁ¿ÏµÍ³×ÊÔ´µÄSQLÓï¾ä¡£ÀýÈçÔËÐÐʱ¼ä³¬¹ý9СʱµÄ±¨±í»òÕßÊÇÒ»¸öºÄʱ3·ÖÖÓµÄÁª»ú²éѯ¡ ......