<% // @Author: Dhunva Saisom ( Dun ) // @Project Name: Sisatchanalai // Number of Files: many // Files Name: ancient_cnt_town.jsp // // // Code provided by Author Dhunva Saisom ( Dun ) // as is,with warranties as to performance, fitness, merchantability,and any other warranty // ( whether expressed or implied ).Terms of Agreement: By using this source code, you agree // to the following terms... // 1) You may use this source code in personal or business projects by buying license. // 2) You MAY NOT redistribute this source code (for example to a web site) without // written permission from the original author.Failure to do so is a violation of copyright // laws. // If you find any bug in this source codes please e-mail : thedun_dec@hotmail.com %> <%@ page contentType="text/html;charset=TIS-620" %> <%@ page import="java.sql.*,java.util.*" %> <% ResultSet rs; String menu = "place"; String placeid = request.getParameter ( "placeid" ); String place_name = null; String place_age = null; String settle_place = null; String latitude = null; String longitude = null; String grid = null; String military = null; String scale = null; String education = null; //String edu_date = null; //String responser = null; String document = null; String declaration = null; String main_topic = null; //String environment = null; String see = null; String route = null; String map = null; String plan = null; String place_type = null; rs = dbcon.executeQueryAll ( "Select * from places where placeid=" + placeid ); while ( rs.next ( ) ) { place_name = rs.getString ( "place_name" ); place_age = rs.getString ( "place_age" ); settle_place = rs.getString ( "settle_place" ); latitude = rs.getString ( "latitude" ); longitude = rs.getString ( "longitude" ); grid = rs.getString ( "grid" ); military = rs.getString ( "military" ); scale = rs.getString ( "scale" ); education = rs.getString ( "education" ); //edu_date = rs.getString ( "edu_date" ); //responser = rs.getString ( "responser" ); document = rs.getString ( "document" ); declaration = rs.getString ( "declaration" ); main_topic = rs.getString ( "main_topic" ); //environment = rs.getString ( "environment" ); see = rs.getString ( "see" ); route = rs.getString ( "route" ); map = rs.getString ( "map" ); plan = rs.getString ( "plan" ); place_type = rs.getString ( "place_type" ); // @@@ START LINUX // place_name = new String ( place_name.getBytes ( "ISO8859_1" ), "MS874" ); // place_age = new String ( place_age.getBytes ( "ISO8859_1" ), "MS874" ); // settle_place = new String ( settle_place.getBytes ( "ISO8859_1" ), "MS874" ); // latitude = new String ( latitude.getBytes ( "ISO8859_1" ), "MS874" ); // longitude = new String ( longitude.getBytes ( "ISO8859_1" ), "MS874" ); // grid = new String ( grid.getBytes ( "ISO8859_1" ), "MS874" ); // military = new String ( military.getBytes ( "ISO8859_1" ), "MS874" ); // scale = new String ( scale.getBytes ( "ISO8859_1" ), "MS874" ); // education = new String ( education.getBytes ( "ISO8859_1" ), "MS874" ); //edu_date = new String ( edu_date.getBytes ( "ISO8859_1" ), "MS874" ); //responser = new String ( responser.getBytes ( "ISO8859_1" ), "MS874" ); // document = new String ( document.getBytes ( "ISO8859_1" ), "MS874" ); // declaration = new String ( declaration.getBytes ( "ISO8859_1" ), "MS874" ); // main_topic = new String ( main_topic.getBytes ( "ISO8859_1" ), "MS874" ); //environment = new String ( environment.getBytes ( "ISO8859_1" ), "MS874" ); // see = new String ( see.getBytes ( "ISO8859_1" ), "MS874" ); // // route = new String ( route.getBytes ( "ISO8859_1" ), "MS874" ); // map = new String ( map.getBytes ( "ISO8859_1" ), "MS874" ); // plan = new String ( plan.getBytes ( "ISO8859_1" ), "MS874" ); // place_type = new String ( place_type.getBytes ( "ISO8859_1" ), "MS874" ); // @@@ END LINUX } rs.close ( ); if ( place_type == null ) { place_type = "I"; } if ( map != null ) { map = map.trim ( ); if ( map.equals ( "" ) ) { map = null; } if ( map != null ) { if ( map.equals ( "null" ) ) { map = null; } } } if ( plan != null ) { plan = plan.trim ( ); if ( plan.equals ( "" ) ) { plan = null; } if ( plan != null ) { if ( plan.equals ( "null" ) ) { plan = null; } } } if ( place_name != null ) { place_name = place_name.trim ( ); se.setShowEnter ( place_name ); place_name = se.getData ( ); } if ( place_age != null ) { place_age = place_age.trim ( ); se.setShowEnter ( place_age ); place_age = se.getData ( ); } if ( settle_place != null ) { settle_place = settle_place.trim ( ); se.setShowEnter ( settle_place ); settle_place = se.getData ( ); } if ( latitude != null ) { latitude = latitude.trim ( ); se.setShowEnter ( latitude ); latitude = se.getData ( ); } if ( longitude != null ) { longitude = longitude.trim ( ); se.setShowEnter ( longitude ); longitude = se.getData ( ); } if ( grid != null ) { grid = grid.trim ( ); se.setShowEnter ( grid ); grid = se.getData ( ); } if ( military != null ) { military = military.trim ( ); se.setShowEnter ( military ); military = se.getData ( ); } if ( scale != null ) { scale = scale.trim ( ); se.setShowEnter ( scale ); scale = se.getData ( ); } if ( education != null ) { education = education.trim ( ); se.setShowEnter ( education ); education = se.getData ( ); } /*if ( edu_date != null ) { edu_date = edu_date.trim ( ); se.setShowEnter ( edu_date ); edu_date = se.getData ( ); } if ( responser != null ) { responser = responser.trim ( ); se.setShowEnter ( responser ); responser = se.getData ( ); } if ( environment != null ) { environment = environment.trim ( ); se.setShowEnter ( environment ); environment = se.getData ( ); } */ if ( document != null ) { document = document.trim ( ); se.setShowEnter ( document ); document = se.getData ( ); } if ( declaration != null ) { declaration = declaration.trim ( ); se.setShowEnter ( declaration ); declaration = se.getData ( ); } if ( main_topic != null ) { main_topic = main_topic.trim ( ); se.setShowEnter ( main_topic ); main_topic = se.getData ( ); } if ( see != null ) { see = see.trim ( ); se.setShowEnter ( see ); see = se.getData ( ); } if ( route != null ) { route = route.trim ( ); se.setShowEnter ( route ); route = se.getData ( ); } %> Important_content <% String intown = null; String outtown = null; String inmouse = null; String outmouse = null; String inover = null; String outover = null; if ( place_type.equals ( "I" ) ) { //out.print ( "in" ); intown = "imcnt_town_19.gif"; inmouse = "imcnt_town_19.gif"; inover = "imcnt_town_19-over.gif"; outtown = "imcnt_town_20.gif"; outmouse = "imcnt_town_20.gif"; outover = "imcnt_town_20-over.gif"; } else { //out.print ( "out" ); intown = "imcnt_out_14.gif"; inmouse = "imcnt_out_14.gif"; inover = "imcnt_out_14-over.gif"; outtown = "imcnt_out_15.gif"; outmouse = "imcnt_out_15.gif"; outover = "imcnt_out_15.gif"; } %>
 

<% if ( place_name != null ) { out.print ( place_name ); } %>

 
ยุคสมัย : <% if ( place_age != null ) { out.print ( place_age ); } %>
รุ้ง : <% if ( latitude != null ) { out.print ( latitude ); } %>
แวง : <% if ( longitude != null ) { out.print ( longitude ); } %>
พิกัดกริด : <% if ( grid != null ) { out.print ( grid ); } %>
แผนที่ทหาร : <% if ( military != null ) { out.print ( military ); } %>
มาตราส่วนแผนที่ : <% if ( scale != null ) { out.print ( scale ); } %>
ประวัติการศึกษา : <% if ( education != null ) { out.print ( education ); } %>
เอกสารอ้างอิง : <% if ( document != null ) { out.print ( document ); } %>
การประกาศขึ้นทะเบียน : <% if ( declaration != null ) { out.print ( declaration ); } %>
สาระสำคัญ :
<% if ( main_topic != null ) { out.print ( main_topic ); } %>
หลักฐานที่ค้นพบ :
<% if ( see != null ) { out.print ( see ); } %>
เส้นทางสู่แหล่ง :
<% if ( route != null ) { out.print ( route ); } %>
 
แผนที่ :
onmouseover="style.cursor='hand'" onclick="mapWindow ( )"<% } %> style="BORDER-RIGHT: #cccccc 1px solid; BORDER-TOP: #cccccc 1px solid; FILTER: progid:DXImageTransform.Microsoft.Shadow(color='#666666', Direction=135, Strength=4); BORDER-LEFT: #cccccc 1px solid; BORDER-BOTTOM: #cccccc 1px solid" src="<% if ( map != null ) { out.print ( map ); } else { out.print ( "up_image/no_image.gif" ); } %>" border="0" width="350" height="253">
แผนผัง :
onmouseover="style.cursor='hand'" onclick="planWindow ( )"<% } %> style="BORDER-RIGHT: #cccccc 1px solid; BORDER-TOP: #cccccc 1px solid; FILTER: progid:DXImageTransform.Microsoft.Shadow(color='#666666', Direction=135, Strength=4); BORDER-LEFT: #cccccc 1px solid; BORDER-BOTTOM: #cccccc 1px solid" src="<% if ( plan != null ) { out.print ( plan ); } else { out.print ( "up_image/no_image.gif" ); } %>" border="0" width="350" height="253">
ภาพถ่าย :
<% int rowCount = 0; int imageid = 0; String url_image = null; Vector imgFunction = new Vector ( ); rs = dbcon.executeQueryAll ( "Select * from up_images where placeid=" + placeid ); while ( rs.next ( ) ) { imageid = rs.getInt ( "imageid" ); url_image = rs.getString ( "url_image" ); imgFunction.addElement ( "" + imageid ); if ( rowCount == 0 ) { out.print ( "" ); } %> <% rowCount++; if ( rowCount >= 2 ) { out.print ( "" ); rowCount = 0; } } rs.close ( ); if ( rowCount == 1 ) { out.print ( "" ); rowCount = 1; } %>
<% if ( rowCount == 2 ) { out.print ( "  " ); } %>
<%@ include file = "footer.jsp" %>