<%@ page language="java" import="java.sql.*" import="java.lang.*" errorPage="" %> <%@ include file="Connections/ConnAgjensi.jsp" %> <% String lang = request.getParameter("lang"); if (lang == null) { lang = "EN"; } Driver DriverInfo = (Driver)Class.forName(MM_ConnAgjensi_DRIVER).newInstance(); Connection ConnInfo = DriverManager.getConnection(MM_ConnAgjensi_STRING,MM_ConnAgjensi_USERNAME,MM_ConnAgjensi_PASSWORD); PreparedStatement StatementInfo = ConnInfo.prepareStatement("select time, text, link from last_news where status = '1' and lang = '" + lang + "' order by priority"); PreparedStatement StatementSubInfo; PreparedStatement StatementPromNews; ResultSet Info = StatementInfo.executeQuery(); ResultSet SubInfo; ResultSet PromNews; boolean Info_hasData = Info.next(); boolean SubInfo_hasData; boolean PromNews_hasData; Object Info_data; %> Welcome to ACLASS TOURISM <% StatementInfo = ConnInfo.prepareStatement("select html_code from html_code where code_html_type = 1 and status = 'Y' and lang = '" + lang + "'"); Info = StatementInfo.executeQuery(); Info_hasData = Info.next(); String header_txt = Info.getString("html_code"); Info.close(); StatementInfo.close(); %>
<%=header_txt%>


<% String exec_sql = ""; exec_sql = "select count(tag) nr from menu_main where lang = '" + lang + "' and m_status = 'Y' and m_menu = 'L' "; StatementInfo = ConnInfo.prepareStatement(exec_sql); Info = StatementInfo.executeQuery(); Info_hasData = Info.next(); String nr_row = Info.getString("nr"); Info.close(); StatementInfo.close(); exec_sql = "select tag, img, link from menu_main where lang = '" + lang + "' and m_status = 'Y' and m_menu = 'L' order by m_order"; StatementInfo = ConnInfo.prepareStatement(exec_sql); Info = StatementInfo.executeQuery(); Info_hasData = Info.next(); i = 1; while ( Info_hasData ) { if ( i == 1 ) { %> <% } else { %> <% } %> <% if ( i == 1 ) { %> <% } else { %> <% } i = i + 1; Info_hasData = Info.next(); } Info.close(); StatementInfo.close(); %>
" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('<%=Info.getString("img")%>_img','','Images/<%=Info.getString("img")%>_ovr.gif',1)">_act.gif" name="<%=Info.getString("img")%>_img" width="136" height="26" border="0">
<% StatementPromNews = ConnInfo.prepareStatement("select dailytour.*, dailytour_type.tag dtt_disp, travel_type.tag tt_disp from dailytour, dailytour_type, travel_type where dailytour.dtt_id = dailytour_type.dtt_id and dailytour.tt_id = travel_type.tt_id and dailytour.lang = '" + lang + "' and dailytour.dailytour_id = " + request.getParameter("mi") + " "); PromNews = StatementPromNews.executeQuery(); PromNews_hasData = PromNews.next(); while ( PromNews_hasData ) { %> <% PromNews_hasData = PromNews.next(); } PromNews.close(); StatementPromNews.close(); %>
....................... Loading .......................
<%=(((Info_data = PromNews.getObject("title"))==null || PromNews.wasNull())?"":Info_data)%>
    No. of Days:<%=(((Info_data = PromNews.getObject("day_no"))==null || PromNews.wasNull())?"":Info_data)%>
No. of Nights:<%=(((Info_data = PromNews.getObject("night_no"))==null || PromNews.wasNull())?"":Info_data)%>

<%=(((Info_data = PromNews.getObject("dtt_disp"))==null || PromNews.wasNull())?"":Info_data)%>

Price: <%=(((Info_data = PromNews.getObject("price"))==null || PromNews.wasNull())?"":Info_data)%> €
 " border="0">

Included in price: <%=(((Info_data = PromNews.getObject("included"))==null || PromNews.wasNull())?"":Info_data)%>

Not Included in price: <%=(((Info_data = PromNews.getObject("nonincluded"))==null || PromNews.wasNull())?"":Info_data)%>

<%=(((Info_data = PromNews.getObject("more_info"))==null || PromNews.wasNull())?"":Info_data)%>


<% ConnInfo.close(); %>