<%@ 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 dt_priority = 'P' and dt_status = 'T' and dailytour.lang = '" + lang + "' order by title"); PromNews = StatementPromNews.executeQuery(); PromNews_hasData = PromNews.next(); while ( PromNews_hasData ) { %> <% PromNews_hasData = PromNews.next(); } PromNews.close(); StatementPromNews.close(); %>
....................... Loading .......................
<% StatementInfo = ConnInfo.prepareStatement("select html_code from menu_info where code_det_menu = '30' and code_main_menu = '7' and i_status = 'Y'"); Info = StatementInfo.executeQuery(); Info_hasData = Info.next(); %> <%=Info.getString("html_code") %> <% StatementInfo.close(); Info.close(); %>
<%=(((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">
">
<% StatementSubInfo = ConnInfo.prepareStatement("select * from reklama where r_status = 'T' and r_priority = 'P'"); SubInfo = StatementSubInfo.executeQuery(); SubInfo_hasData = SubInfo.next(); while ( SubInfo_hasData ) { %> <%=(((Info_data = SubInfo.getObject("info"))==null || SubInfo.wasNull())?"":Info_data)%> <% SubInfo_hasData = SubInfo.next(); } SubInfo.close(); StatementSubInfo.close(); %>

<% ConnInfo.close(); %>