ÎÒ·¢ÏÖÓÐЩOracleÖÐÓÐЩsqlÓï¾äÔÚ±íÃûǰÓÐǰ׺£¬ÀýÈçselect * from "BI"."testView";
Õâ¸öÇ°×ºÊ²Ã´ÄØ£¬Íû´óÏÀÖ¸µã£¡
schema£¬Ò²¿ÉÒÔ˵ÊÇÓû§Ãû¡£
Èç¹ûÕâ¸ö±íÊôÓÚµ±Ç°µÄschema£¬Ò²¾ÍÊÇÔÚµ±Ç°Õâ¸öÓû§Ï£¬ÊDz»ÓüÓǰ׺µÄ£»Èç¹ûÊÇÆäËûÀ´Óû§·ÃÎÊÊÇÐèÒª¼ÓÉÏÕâ¸ö±íËùÊôµÄÓû§ÃûµÄ¡£
SQL code: ......
ÈçºÎ»ñµÃoracleÖÐij¸öÊý¾Ý±íµÄschemaÄØ£¿
±ÈÈçsqlÓï¾ä»òÕ߯äËûʲô°ì·¨£¬Íû´óÏÀÖ¸µã
conn / as sysdba;
select owner,table_name from all_tables where table_name = upper('***');
select OWNER from dba_tables
where table_name='U101'
......
¹Ø¼ü´úÂ룺
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
&nbs ......
ÎÒÏÖÔÚÓиöÃÅ»§ÍøÕ¾£¬ÓÃStruts1.2×öµÄ£¬Ö®Ç°Ã»ÓÃajax,ÏÖÔÚÏë½áºÏajax ¿ò¼Ü ÕûºÏÉý¼¶¡£
Struts1.2 ºÍÄǸöajax ¿ò¼ÜÕûºÏµÄ±È½ÏºÃ¡£ÕûºÏÖ®ºóÌý˵ajax Õ¼ÄÚ´æÊ²Ã´¶¼²»Ð¡£¬°üÒ²²»Ð¡£¬´ó¼ÒÌÖÂÛһϰ¡¡£
ajax Êǿͻ§¶ËµÄ¶«¶«£¬¿ÉÒÔʹÓÃproperty.js£¨½¨Ò飩,jquery.js,ext£¬dwrµÈ
Èç¹ûºÍStruts1.2 ÕûºÏ£¬ÆðÂë¿ÉÒÔ¼õÉÙn¸öactionfo ......
ÎÒÔÚ×ö¹ÜÀíÔ±Êý¾Ý¸üеÄÒ³Ãæ£¬ÏëҪʵÏÖÊý¾Ý¿âÖеÄÊý¾ÝÒÔ±í¸ñµÄ·½Ê½Õ¹ÏÖÔÚÒ³ÃæÖУ¬Ã¿Ò»ÐÐÊÇÒ»ÌõÊý¾Ý£¬Ã¿Ò»ÐеÄ×îºóÓÐÐ޸ĺÍɾ³ýÁ½¸ö°´Å¥£¬ÓÃdojoʵÏÖ¡£¾ßÌåʵÏÖ´úÂëÈçÏÂ
HTML code:
<table>
<s:iterator value="datalist">
<tr>
<th>±àºÅ<th>Ãû³Æ<th>¼ò½é<th>µ ......
ÎÒÔÚaÒ³ÃæÊ¹ÓÃajaxÍùbÒ³Ãæ´«ËÍÊý¾Ý²¢ÓÚbÒ³Ãæ½«Êý¾Ý·ÅÈëÊý¾Ý¿â£¬µ«ÊDzåÈëºó·²ÊÇÖÐÎĵÄÊý¾Ý¶¼³öÏÖÂÒÂë»òÕßÊǿհס£
ÎÒÔÚbÒ³Ãæ½«sqlÓï¾äecho³öÀ´ÔÚaÒ³ÃæÓýű¾alert³öÀ´Ò²ÊǺúõ쬵«ÊÇÒ»ÈëÊý¾Ý¿â¾Í²»ÐУ¬ÎÒÄǸöname×Ö¶ÎÔÚmysqlµÄ±àÂëÊÇgb2312_chinese_ciµÄ
aÒ³ÎҵıàÂëÊÇgb2312,bÒ³ÎÒÒѾÉùÃ÷ÁË
header(&qu ......