<%@ 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; ResultSet Info = StatementInfo.executeQuery(); ResultSet SubInfo; boolean Info_hasData = Info.next(); boolean SubInfo_hasData; Object Info_data; %> 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 = "select (count(tag) + 1) 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(); StatementInfo = ConnInfo.prepareStatement("select tag, img, link from menu_main where lang = '" + lang + "' and m_status = 'Y' and m_menu = 'L' order by m_order"); Info = StatementInfo.executeQuery(); Info_hasData = Info.next(); i = 1; while ( Info_hasData ) { if ( i == 1 ) { %> <% } else { %> <% } %> <% if ( i == 1 ) { %> <% } else { %> <% } // sub menu if ( i == 2 ) { %> <% } 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"> 
<% StatementSubInfo = ConnInfo.prepareStatement("select tag, link from menu_det where lang = '" + lang + "' and code_main_menu = '2' and s_status = 'Y' and s_order <> 0 order by s_order"); SubInfo = StatementSubInfo.executeQuery(); SubInfo_hasData = SubInfo.next(); while ( SubInfo_hasData ) { %> <% SubInfo_hasData = SubInfo.next(); } SubInfo.close(); StatementSubInfo.close(); %>
" target="_self" class="link6"><%=SubInfo.getString("tag") %>
....................... Loading .......................
<% String v_sql = ""; if ((request.getParameter("p_1")!=null) && (!request.getParameter("p_1").equals(""))) { v_sql = "select html_code from menu_info where code_det_menu = '"+ request.getParameter("p_1") +"' and code_main_menu = '2' and i_status = 'Y'"; } else { v_sql = "select html_code from menu_info where code_det_menu = '4' and code_main_menu = '2' and i_status = 'Y'"; } StatementInfo = ConnInfo.prepareStatement(v_sql); Info = StatementInfo.executeQuery(); Info_hasData = Info.next(); %> <%=Info.getString("html_code") %>
<% 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(); %>