±íA:
name fenshu
a 80
b 44
c 60
d 78
°´ÕÕ·ÖÊý´óÓÚ80ÓÅÐã,60-80ºÏ¸ñ,60ÒÔϲî
Ôõôת»»³ÉÏÂÁÐÑù×Ó.Ò»¾äsql
±íB
name fenshu XX
a 80 ÓÅÐã
b 44 ²î
c 60 ºÏ¸ñ
d 78 ºÏ¸ñ
SQL code:
select name,fenshu,case w ......
ÎÒÏëѧϰoralceµÄ»ù´¡ÖªÊ¶£¬ÏëÎʸ÷λ´óÏÀ£¬ÏÂÔØoracleµÄÄĸö°æ±¾ºÏÊÊ,ÎÒ¸öÈËÏëÏÂÔØoracle 10 express°æ£¬ÔõôÑù£¿
±ê×¼°æºÍÆóÒµ°æ¶¼ÐÐ
expressÕâ¸öÊÇʲô°æ±¾£¬ÎÒÔÚoracleÍøÕ¾ÉÏ¿´¸öexpressҪСЩ£¬ËùÒÔÎÒÏëÏÂÔØÕâ¸ö°æ±¾£¬ÔõôÑù£¿
10.2µÄÆóÒµ°æ£¬¶ÔOracleÀ´Ëµ£¬ÓÀÔ¶²»ÒªÏÂÔØexpress°æ¡£
ÏÂÔÚOracle 10g °æ±¾µÄ ......
ÎÒÓõÄÊÇMyEclipse±àÒëÆ÷ ÓõÄÊÇwindows7ϵͳ ÒÔǰjavaºÍOracleÊý¾Ý¿âÁ¬½ÓûÓгöÏÖ¹ý´íÎó ½ñÌì²»Öª±¨ÔõôÁ˳öÏÖÁËÏÂÃæµÄ´íÎó£º
ÓÉÓÚϵͳ´íÎó 1114: ¶¯Ì¬Á´½Ó¿â(DLL)³õʼ»¯Àý³Ìʧ°Ü¡£ (Oracle in OraDb10g_home1, F:\programFile\oracle\product\10.2.0\db_1\BIN\SQORA32.DLL)£¬Ö¸¶¨Çý¶¯³ÌÐòÎÞ·¨¼ÓÔØ¡£
ËÄ ......
ÎÒµÄstruts2Óëǰ¶ËµÄjspµÄ±àÂë¶¼ÉèÖóÉgbkµÄÁË£¬²¢ÇÒÔÚweb.xmlÖÐÒ²ÉèÖÃÁËfilter¹ýÂË£¬ÎÒÒ²ÖªµÀajaxµÄÌá½»·½Ê½Ä¬ÈÏÊÇutf-8£¬ÓÐûÓкõİ취£¬±ÈÈçÅäÖÃfilterµÈ£¬ÈÃËü²»ÔÙ³öÏÖÂÒÂëÄØ£¿
ºǫ́JAVA´úÂë¼Ó¸öת»»·½·¨
ÄãµÄ¹ýÂËÆ÷ÉèÖñàÂëûÓÐÓõÄ.! Struts2µÄºËÐĹýÂËÆ÷¶¼¸øÄãÕû³Éutf-8ÁË(ĬÈϵÄ),¶ø²»ÊÇajaxµÄÌá½»·½Ê½Ä¬ÈÏÊÇu ......
RT!
ajax Ìá½»Êý¾Ýʱ£¬Êý¾ÝÁ¿ºÜ´ó ÓÚÊÇ ¾ÍÑ¡ÔñÁË POSTÌá½»¡£
JScript code:
xmlHttpRequest.send(message);
message¾ÍÊÇ ×éÖ¯ºÃµÄÊý¾Ý¡£
ÔÚ100ÌõµÄʱºò£¬java¶Ë¿ÉÒÔ ½ÓÊܵ½Êý¾Ý¡£
200Ìõ¾Í²»ÐÐÁË¡£
Çë´óϺÃÇ °ï°ïСµÜ£¡
ÆäËû´úÂëÄØ£¿
message
ÊÇ´ÓÒ»¸öÒ³ÃæTableÖеõ½µÄÊý¾Ý
¾ÍÏñÊÇ£ºid=001&nam ......
Ò»¶ÎÎı¾£¬¼ÓÁ˺ܶàHTMLµÄÑùʽ£¬Èç¹ûÖ»ÒªÄǶÎÎĵµ£¬Ôõô°ÑÄÇЩÑùʽȥµô
</SPAN</P style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; TEXT-INDENT: 24pt\"<SPAN style=\"FONT-SIZE: 12pt; FONT-FAMILY: ËÎÌå\"µÚ¾ÅÌõ</SPAN<SPAN style=\"FONT-SIZE: 12pt; FONT-FAMILY: ËÎÌå\"² ......