<%@ page contentType="text/html; charset=iso-8859-1" %> <%@page import="java.sql.ResultSet"%> <%@page import="java.text.*"%> <%@page import ="java.io.*"%> <%@page import="DataBase.*"%> <jsp:useBean id="p" scope="page" class="page.page"/> <%! opendb op; %> <%try{ op= new opendb(); ResultSet rs = null; //±£´æ²éѯ½á¹û int count=0; //»ñÈ¡¼Ç¼µÄÊýÁ¿
%> <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId" content="FrontPage.Editor.Document">
<title>IDB</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <!-- Fireworks MX Dreamweaver MX target. Created Sun Jun 01 14:18:09 GMT+0800 (?D1ú±ê×?ê±??) 2003--> <link href="../images/css1.css" rel="stylesheet" type="text/css"> </head> <body bgcolor="ffffff" topmargin="0"> <table width="716" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td colspan="3"><table width="756" border="0" cellspacing="0" cellpadding="0"> <tr> <td><img src="../images/index_r1_c1.jpg" width="751" height="26"></td> </tr> </table></td> </tr> <tr> <td colspan="3"><table width="751" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td colspan="2"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cabversion=6,0,29,0" width="751" height="96"> <param name="movie" value="../images/english.swf"> <param name="quality" value="high"> <embed src="../images/english.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="751" height="96"></embed> </object> </td> </tr> <tr> <td width="645"><img src="../images/index_r3_c1_1.jpg" width="525" height="92" border="0" usemap="Map" href="#"><img src="../images/index_r3_c12_1.jpg" width="120" height="92" border="0" usemap="Map2"></td> <td width="106" align="center" valign="bottom" background="../images/index_r3_c15_1.jpg"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cabversion=6,0,29,0" width="75" height="75"> <param name="movie" value="../images/index.swf"> <param name="quality" value="high"> <embed src="../images/index.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="75" height="75"></embed> </object> </td> </tr> </table> <map name="Map"> <area shape="rect" coords="458,49,522,88" href="../index/index_guest.jsp" target="_blank"> <area shape="rect" coords="381,46,442,86" href="mailto:ytidb@public.ytptt.sd.cn%20%3Cytidb@yt-public.sd.cninfo.net%3E"> </map> <map name="Map2"> <area shape="rect" coords="26,19,118,34" href="../website/index.jsp"> <area shape="rect" coords="28,42,115,60" href="../questionnaire/index.jsp" target="_blank"> <area shape="rect" coords="28,62,110,80" href="http://www.yantai.gov.cn"> </map></td> </tr> <tr> <td colspan="3"><img src="../images/index_r4_c1.jpg" alt="" name="index_r4_c1" width="751" height="36" border="0" usemap="index_r4_c1Map"> <map name="index_r4_c1Map"><area shape="rect" coords="104,10,172,27" href="../aboutus/index.jsp"> <area shape="rect" coords="380,11,486,28" href="../business/index.jsp"> <area shape="rect" coords="176,9,273,28" href="../mayor/index.jsp"> <area shape="rect" coords="279,9,371,27" href="../yantaitoday/index.jsp"> <area shape="rect" coords="494,9,625,27" href="../investment/index.jsp"> <area shape="rect" coords="630,9,737,28" href="../tour/index.jsp"> <area shape="rect" coords="11,8,97,27" href="../hompage/index.jsp"> </map></td> </tr> <tr> <td width="151" valign="top" background="../images/index_r10_c1_1.jpg"> <table width="94%" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3"><img name="index_r5_c1" src="../images/index_r5_c1.jpg" width="149" height="14" border="0" alt=""></td> </tr> <tr> <td width="8%" valign="top" background="../images/index_r6_c1.jpg"> </td> <td width="87%" valign="top"><div align="center"><img name="index_r6_c3" src="../images/index_r6_c3.jpg" width="129" height="44" border="0" alt=""><br> <select name="select2" size="1" class="smallist"> <option>Agriculture <option>Light Industry <option>Textile <option>Electronics <option>Pharmacy <option>Building Materials <option>Metal Industry <option>Chemical Industry <option>Machinery <option>Infrastructure <option>Tourism <option>Others </select> </div></td> <td width="5%" valign="top" background="../images/index_r6_c5.jpg"> </td> </tr> <tr> <td valign="top"><img name="index_r9_c1" src="../images/index_r9_c1.jpg" width="13" height="8" border="0" alt=""></td> <td valign="top"><img name="index_r9_c3" src="../images/index_r9_c3.jpg" width="129" height="8" border="0" alt=""></td> <td valign="top"><img name="index_r9_c5" src="../images/index_r9_c5.jpg" width="7" height="8" border="0" alt=""></td> </tr> <tr> <td colspan="3"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cabversion=6,0,29,0" width="147" height="90"> <param name="movie" value="../images/index_2.swf"> <param name="quality" value="high"> <embed src="../images/index_2.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="147" height="90"></embed></object></td> </tr> <tr> <td colspan="3"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cabversion=6,0,29,0" width="147" height="87"> <param name="movie" value="../images/index_4.swf"> <param name="quality" value="high"> <embed src="../images/index_4.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="147" height="87"></embed></object></td> </tr> <tr> <td colspan="3"><div align="center"><font size="2"> </font></div> <div align="center"><font size="2"> </font></div></td> </tr> <tr> <td height="50" colspan="3"> <div align="center"><img src="../images/index_r17_c2_2.jpg" width="121" height="37"></div></td> </tr> <tr> <td height="51" colspan="3"> <div align="center"><img src="../images/index_r17_c2_3.jpg" width="121" height="37"></div></td> </tr> <tr> <td height="51" colspan="3"> <div align="center"><img src="../images/index_r17_c2_4.jpg" width="121" height="37"></div></td> </tr> <tr> <td colspan="3"> </td> </tr> <tr> <td colspan="3"> </td> </tr> </table> </td> <td width="4" background="../images/index_r5_c6.jpg"> </td> <td width="561" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="13%"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cabversion=6,0,29,0" width="430" height="76"> <param name="movie" value="../images/index_18.swf"> <param name="quality" value="high"> <embed src="../images/index_18.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="430" height="76"></embed></object></td> <td width="87%" align="center"><div align="right"></div></td> </tr> <tr> <td colspan="2"><table width="100%" height="19" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="19"> </td> </tr> </table></td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="65%"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr class="ziti"> <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td> </td> </tr> <tr> <td><table width="100%" height="120" border="0" cellpadding="0" cellspacing="0" class="ti"> <% //¹ú¼Ò¼¶ÖصãÔ°Çø rs=op.getdb("select * from tb_flags where data_cata_code='TZENGJYQ' or data_cata_code='TZENSJYQ' OR data_cata_code='TZENQTYQ'",0); while(rs.next()){ String name=rs.getString("FLAGS_NAME").trim(); %> <img src="../images/index_r7_c7_1.jpg" width="14" height="12"> <% if(name.equals("Yantai Economic & Technological Development Area")){ %>
<a href="index_show.jsp?id=<%=rs.getString("FLAGS_ID")%>"><%=name%> </a><br><br> <%}else{ String id=rs.getString("FLAGS_ID"); String id1="9999"; ResultSet rss= op.getdb("select distinct tt.TEXT_ID,tt.TITLE,tt.PUBLICTIME from tb_text tt,tb_flags tf where tt.FLAG="+id+" and tf.data_cata_code='TZENGJYQ' AND tt.LANGUAGE_CODE='ENGLISH'"); if(rss.next()) id1=rs.getString("TEXT_ID"); rss.close(); %> <a href="index_show1.jsp?id=<%=id1%>"><%=name%> </a><br><br> <%}%> <% }rs.close(); %> </table> </td> </tr> </table> <p> </p> </td> </tr> <tr class="ziti"> <td colspan="2"><img src="../images/index_r19_c7.jpg" width="580" height="10"></td> </tr> <tr class="ziti"> <td colspan="2"><div align="center"><font color="#666666" size="2">Gopyright Reserved By Yantai Investment Development Board<br> Yantai Integrated Information Center Provides Technical Support</font></div></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="87" colspan="3"> </td> </tr> </table> </body> </html> <% }finally{ op.Conclose(); } %>
|