<%@page pageEncoding="gb2312"%> <%@page contentType="text/html;charset=GB2312"%> <%request.setCharacterEncoding("gb2312");%> <%response.addHeader("Cache-Control", "no-cache");response.addHeader("Expires", "Thu, 01 Jan 1970 00:00:01 GMT");%> <%@ page import="java.sql.*" %> <%@ page import="javax.naming.*"%> <%@ page import="javax.sql.*"%> <%@ page import="mypack.DBManager" %> <% String rCITYNAME=request.getParameter("CITYNAME"); int rCITYID=0; if (rCITYNAME == null) { rCITYNAME="北京市"; rCITYID=100; } else { //rCITYNAME=new String(rCITYNAME.getBytes("ISO-8859-1"),"GB2312"); } rCITYNAME = rCITYNAME.replaceAll("<", ""); rCITYNAME = rCITYNAME.replaceAll(">", ""); rCITYNAME = rCITYNAME.replaceAll("'", ""); rCITYNAME = rCITYNAME.replaceAll("\"", ""); rCITYNAME = rCITYNAME.replaceAll("&", ""); rCITYNAME = rCITYNAME.replaceAll("script", "script"); if (rCITYNAME.toLowerCase().indexOf("script")>0 ) { rCITYNAME="";out.println(rCITYNAME);out.close(); } %> 搜狐
城市：
<% //获取地区列表 vSQL="SELECT * FROM TBL_PROD_DISTRICT_DEF WHERE CITY_ID=" + rCITYID; gRS= gStmt.executeQuery(vSQL); int iRegion=999999; String regionName="全部"; %>
图片说明 高级搜索

地图搜索 图片说明



最佳餐馆 | 口味 | 环境 | 服务
<% //获取最佳餐馆 vSQL="SELECT * FROM TBL_CHIHE_POI_ATTR WHERE CITY_ID=" + rCITYID + " ORDER BY SCORE_CONSUME DESC"; gRS= gStmt.executeQuery(vSQL); double iPrice=0; String DATAID=""; String CAPTION=""; iSer=1; String gConsumeDATAID=""; String gODATAID=""; while (gRS.next()) { if (iSer <11 ) { CAPTION = gRS.getString("CAPTION"); DATAID = gRS.getString("DATAID"); gODATAID=DATAID; DATAID="133_" + DATAID; iPrice= gRS.getDouble("SCORE_CONSUME"); if (iSer ==10) { if (CAPTION.length()>=2) { CAPTION=CAPTION.substring(0,2)+ "..."; } } else { if (CAPTION.length()>=3) { CAPTION=CAPTION.substring(0,3)+ "..."; } } out.print(""); gConsumeDATAID+=DATAID + ","; } else { break; } iSer++; } %>
商户名 人均
" + iSer + "." + CAPTION + "" + iPrice + "详细
<% //获取最佳餐馆 vSQL="SELECT * FROM TBL_CHIHE_POI_ATTR WHERE CITY_ID=" + rCITYID + " ORDER BY SCORE_TASTE DESC"; gRS= gStmt.executeQuery(vSQL); iSer=1; String gTASTEDATAID=""; while (gRS.next()) { if (iSer <11 ) { CAPTION = gRS.getString("CAPTION"); DATAID = gRS.getString("DATAID"); gODATAID=DATAID; DATAID="133_" + DATAID; iPrice= gRS.getDouble("SCORE_TASTE"); if (iSer ==10) { if (CAPTION.length()>=2) { CAPTION=CAPTION.substring(0,2)+ "..."; } } else { if (CAPTION.length()>=3) { CAPTION=CAPTION.substring(0,3)+ "..."; } } out.print(""); gTASTEDATAID+=DATAID + ","; } else { break; } iSer++; } %> <% //获取最佳餐馆 vSQL="SELECT * FROM TBL_CHIHE_POI_ATTR WHERE CITY_ID=" + rCITYID + " ORDER BY SCORE_ENV DESC"; gRS= gStmt.executeQuery(vSQL); iSer=1; String gENVDATAID=""; while (gRS.next()) { if (iSer <11 ) { CAPTION = gRS.getString("CAPTION"); DATAID = gRS.getString("DATAID"); gODATAID=DATAID; DATAID="133_" + DATAID; iPrice= gRS.getDouble("SCORE_ENV"); if (iSer ==10) { if (CAPTION.length()>=2) { CAPTION=CAPTION.substring(0,2)+ "..."; } } else { if (CAPTION.length()>=3) { CAPTION=CAPTION.substring(0,3)+ "..."; } } out.print(""); gENVDATAID+=DATAID + ","; } else { break; } iSer++; } %> <% //获取最佳餐馆 vSQL="SELECT * FROM TBL_CHIHE_POI_ATTR WHERE CITY_ID=" + rCITYID + " ORDER BY SCORE_SERVICE DESC"; gRS= gStmt.executeQuery(vSQL); iSer=1; String gSERVICEDATAID=""; while (gRS.next()) { if (iSer <11 ) { CAPTION = gRS.getString("CAPTION"); DATAID = gRS.getString("DATAID"); gODATAID=DATAID; DATAID="133_" + DATAID; iPrice= gRS.getDouble("SCORE_SERVICE"); if (iSer ==10) { if (CAPTION.length()>=2) { CAPTION=CAPTION.substring(0,2)+ "..."; } } else { if (CAPTION.length()>=3) { CAPTION=CAPTION.substring(0,3)+ "..."; } } out.print(""); gSERVICEDATAID+=DATAID + ","; } else { break; } iSer++; } %>
热门菜系
<% //获取热门菜系 vSQL="SELECT * FROM TBL_CHIHE_CITY_FOOD_SERIES WHERE CITY_ID=" + rCITYID + " ORDER BY ORDER_NO DESC"; gRS= gStmt.executeQuery(vSQL); int FOOD_ID; String FOODNAME=""; Statement tStmt = null; ResultSet tRS=null; tStmt = m_Connection.createStatement(); while (gRS.next()) { FOOD_ID= gRS.getInt("FOOD_ID"); vSQL="SELECT * FROM TBL_CHIHE_FOOD_SERIES WHERE FOOD_ID=" + FOOD_ID ; tRS= tStmt.executeQuery(vSQL); while (tRS.next()) { FOODNAME=tRS.getString("NAME"); out.print("" + FOODNAME + "   "); } } %>
热门商区
<% //获取热门商业 vSQL="SELECT * FROM TBL_CHIHE_HBD WHERE CITY_ID=" + rCITYID + " ORDER BY ORDER_NO DESC"; gRS= gStmt.executeQuery(vSQL); String HBDNAME=""; while (gRS.next()) { HBDNAME= gRS.getString("NAME"); out.print("" + HBDNAME + "   "); } %>
热门菜
<% //获取热门菜 vSQL="SELECT * FROM TBL_CHIHE_HOTFOOD WHERE CITY_ID=" + rCITYID + " ORDER BY ORDER_NO DESC"; gRS= gStmt.executeQuery(vSQL); String HOTFOODNAME=""; while (gRS.next()) { HOTFOODNAME= gRS.getString("NAME"); //out.print("" + HOTFOODNAME + "   "); out.print("" + HOTFOODNAME + "   "); } if (tRS != null) { tRS.close(); } if (tStmt != null) { tStmt.close(); } gRS.close(); gStmt.close(); m_Connection.close(); tRS=null; tStmt=null; gRS=null; gStmt=null; m_Connection=null; %>