<%@ page import = "java.io.*" %> <%@ page import = "java.lang.*" %> <%@ page import = "java.sql.*" %> <%@ page import = "java.util.*" %> <%@ page import = "javax.naming.*" %> <%@ page import = "javax.sql.*" %> <%@ page import = "yppo.util.*" %> <%@ page contentType="text/html;charset=ISO-8859-7" %> <% //Πληροφορίες οντότητας //1. Μουσείο //2. Μνημείο //3. Αρχαιολογικός Χώρος String ont_id = "2"; %> <% //ορίζουμε σε ποιά γλώσσα θα εμφανιστεί η πληροφορία String lang = request.getParameter("lang")==null?"gr":request.getParameter("lang"); lang="en"; if (!lang.equals("gr") && !lang.equals("en")) { lang = "gr"; } String langSuffix = ""; if (lang.equals("en")) { langSuffix = "_EN"; } String langPrefix = ""; if (lang.equals("en")) { langPrefix = "e"; } if (lang.equals("gr")) { langPrefix = "g"; } //declare database-related and other important objects here Statement stmt = null; ResultSet rset = null; Statement glstmt = null; ResultSet glrset = null; String gl_count = ""; Connection conn = null; DataSource ds = null; InitialContext ic = null; yppo.util myUtil = new yppo.util(); String strSQL = ""; StringBuffer theSQL = new StringBuffer(10000); String leftTableString = ""; String lhmmaid = ""; String lhmma = ""; String editor1 = ""; String editor2 = ""; String editor3 = ""; String titlos = ""; String address = ""; String eidosid = ""; String eidos = ""; String tel = ""; String fax = ""; String oraria = ""; String olokliro = ""; String meiomeno = ""; String ticketgroupid = ""; String uniticketgroupid = ""; String tickets = ""; String unitickets = ""; String ticketcomments = ""; String uniticketcomments = ""; String fotoid = ""; String fotolezanta = ""; String fotocopyright = ""; String fotosize = ""; int mege8os = 0; String other_ant_id = ""; String other_ant_titlos = ""; int other_ant_mege8os = 0; String other_ant_href = ""; String other_ont_id = ""; String outer_url = ""; String outer_titlos = ""; String uniti_id = ""; String uniti_titlos = ""; String uniti_ontid = ""; String uniti_href = ""; String glossaryid = ""; String glossaryname = ""; String allglossary = ""; //για το banner πάνω-πάνω String fotobannersrc = ""; String eidos_title = "Είδος"; String address_title = "Διεύθυνση"; String tel_title = "Τηλέφωνο"; String fax_title = "Φαξ"; String oraria_title = "Ωράρια"; String oraria_w_title = "Χειμερινό: "; String oraria_s_title = "Θερινό: "; String tickets_title = "Εισιτήρια"; String unitickets_title = "Ενιαία Εισιτήρια"; String editors_title = "Author"; String html_title = ""; String titlos_bn = ""; String euroSign = "€"; String onoma = ""; String onoma_id = ""; String obj_on_site = ""; String era1 = ""; String parent_era = ""; String depth_era = ""; String thisEra = request.getParameter("era")==null?"1":request.getParameter("era"); String thisGroup = request.getParameter("group")==null?"1":request.getParameter("group"); int unesco = 0; //gia to banner me ton titlo prin to paste toy periexomenoy ston pinaka ths selidas String unesco_cnt = ""; String parent_museum_id = ""; String parent_arch_xwros_id = ""; String ontothta_id = ""; String obj_id = request.getParameter("obj_id"); if (myUtil.isInvalidAnt(obj_id,ont_id,"testing")) { %> <% } try { //retrieve-connection ic = new InitialContext(); ds = (DataSource) ic.lookup("jdbc/OracleDS"); conn = ds.getConnection(); stmt = conn.createStatement(); glstmt = conn.createStatement(); %> <% yppo.content myContent = new yppo.content(conn); //εδώ τραβάμε στο array leftArrays[][] τα links που πρέπει να εμφανιστούν στο αριστερό μέρος //Το array αυτό θα δοθεί ως παράμετρος στη συνάρτηση content.buildLeftTable() String[][] leftArrays = new String[50][3]; for (int i=0;i<50;i++) { leftArrays[i][0] = null; //title leftArrays[i][1] = "0"; //isLeaf leftArrays[i][2] = ""; //theURL } leftArrays = myContent.populateOntothtaLeftArrays(conn,ont_id,obj_id,lang); html_title = myContent.fetchPageTitle(conn,"h251.jsp",lang); leftTableString = myFrame.buildLeftTable(leftArrays,0,"h251.jsp"); %> <%//edw koitame an anikei se mnimeio-xwro unesco theSQL = new StringBuffer(); theSQL.append ("select unesco from ant where ant_id in (select ARCH_XWROS_ID from ant where ant_id="+obj_id+")"); strSQL = theSQL.toString(); rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getInt(1)!=0) { unesco = rset.getInt(1); } else { unesco = 0; } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <% //εδώ τραβάμε τα γενικά στοιχεία theSQL = new StringBuffer(); theSQL.append("SELECT A.NAME1"+langSuffix+", A.MEGE8OS, A.ADDRESS"+langSuffix+", A.TEL, A.FAX, "); theSQL.append(" A.SCHEDULES_ALL"+langSuffix+", A.SCHEDULES_WINTER"+langSuffix+", A.SCHEDULES_SUMMER"+langSuffix+", "); theSQL.append(" A.TICKET_GROUP_ID, A.UNIFORM_TICKET_GROUP_ID, A.TICKET_COMMENTS"+langSuffix+", A.UNIFORM_TICKET_COMMENTS"+langSuffix+", A.UNESCO, A.ONTOTHTA_ID, A.ON_SITE "); theSQL.append(" FROM ANT A WHERE A.ANT_ID=" + obj_id); strSQL = theSQL.toString(); rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) { titlos = rset.getString(1); } if (rset.getString(2)!=null) { mege8os = rset.getInt(2); } if (rset.getString(3)!=null) { address = rset.getString(3); } if (rset.getString(4)!=null) { tel = rset.getString(4); } if (rset.getString(5)!=null) { fax = rset.getString(5); } if (rset.getString(6)!=null) { oraria = rset.getString(6); } if (oraria.equals("")) { if (rset.getString(7)!=null) { oraria = oraria_w_title + myUtil.nToBr(rset.getString(7),true,0,1); } if (rset.getString(8)!=null) { oraria = oraria + "
" + oraria_s_title + myUtil.nToBr(rset.getString(8),true,0,1); } } if (rset.getString(9)!=null) { ticketgroupid = rset.getString(9); } if (rset.getString(10)!=null) { uniticketgroupid = rset.getString(10); } if (rset.getString(11)!=null) { ticketcomments = rset.getString(11); } if (rset.getString(12)!=null) { uniticketcomments = rset.getString(12); } if (rset.getString(14)!=null) { ontothta_id = rset.getString(14); } if (rset.getString(15)!=null) { obj_on_site = rset.getString(15); } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <% if (ontothta_id.equals("")) { %> <%}%> <% if (!obj_on_site.equals("1")) { %> <%}%> <% if (ontothta_id.equals("3")) { %> <%}%> <% if (ontothta_id.equals("1")) { %> <%}%> <% //εδώ τραβάμε τα κανονικά εισιτήρια olokliro=""; meiomeno=""; if (!ticketgroupid.equals("")) { theSQL = new StringBuffer(); theSQL.append("SELECT TP1.TICKET_PRICE, TP2.TICKET_PRICE FROM TICKET_GROUP TG, TICKET_PRICE TP1, TICKET_PRICE TP2 "); theSQL.append("WHERE TG.REDUCED_TICKET_PRICE_ID=TP1.TICKET_PRICE_ID "); theSQL.append("AND TG.FREE_TICKET_PRICE_ID=TP2.TICKET_PRICE_ID "); theSQL.append("AND TG.TICKET_GROUP_ID="+ticketgroupid); strSQL = theSQL.toString(); rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) { olokliro = rset.getString(1); } if (rset.getString(2)!=null) { meiomeno = rset.getString(2); } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} tickets = ""; if ((!olokliro.equals("")) && (!olokliro.equals("0"))) { tickets = tickets + "Ολόκληρο: " + euroSign + olokliro + ", "; } if ((!meiomeno.equals("")) && (!meiomeno.equals("0"))) { tickets = tickets + "Μειωμένο: " + euroSign + meiomeno + ", "; } if (tickets.length()>0) { tickets = tickets.substring(0,tickets.length()-2); } if (!ticketcomments.equals("")) { if (!tickets.equals("")) { tickets = tickets + "
"; } tickets = tickets + ticketcomments; } //if (tickets.length()>0) { tickets = tickets.substring(0,tickets.length()-4); } } %> <% //εδώ τραβάμε τα ενιαία εισιτήρια olokliro=""; meiomeno=""; if (!uniticketgroupid.equals("")) { theSQL = new StringBuffer(); theSQL.append("SELECT TP1.TICKET_PRICE, TP2.TICKET_PRICE FROM TICKET_GROUP TG, TICKET_PRICE TP1, TICKET_PRICE TP2 "); theSQL.append("WHERE TG.REDUCED_TICKET_PRICE_ID=TP1.TICKET_PRICE_ID "); theSQL.append("AND TG.FREE_TICKET_PRICE_ID=TP2.TICKET_PRICE_ID "); theSQL.append("AND TG.TICKET_GROUP_ID="+uniticketgroupid); strSQL = theSQL.toString(); rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) { olokliro = rset.getString(1); } if (rset.getString(2)!=null) { meiomeno = rset.getString(2); } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} unitickets = ""; if (!olokliro.equals("")) { unitickets = unitickets + "Ολόκληρο: " + olokliro; } if (!meiomeno.equals("")) { unitickets = unitickets + ", Μειωμένο: " + meiomeno; } if (!uniticketcomments.equals("")) { unitickets = unitickets + "
"+ uniticketcomments; } } %> <% //εδώ τραβάμε το είδος strSQL = "SELECT CV.CVALUE_ID, CV.TITLE"+langSuffix+" FROM CVALUE CV, ANT_VALUE AV WHERE CV.CVALUE_ID=AV.CVALUE_ID AND CV.CATEG_ID=5 AND AV.ANT_ID="+obj_id+" ORDER BY AV.HAS_ORDER"; rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) { eidosid = rset.getString(1); } if (rset.getString(2)!=null) { eidos = rset.getString(2); } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <% //εδώ τραβάμε τη περιγραφή theSQL = new StringBuffer(10000); theSQL.append("SELECT LB.LHMMA_BODY,L.EDITOR1"+langSuffix+",L.EDITOR2"+langSuffix+",L.EDITOR3"+langSuffix+",L.LHMMA_ID "); theSQL.append(" FROM LHMMA L, ANT_LHMMA AL, LHMMA_BODY LB "); theSQL.append(" WHERE AL.LHMMA_ID=L.LHMMA_ID "); theSQL.append(" AND L.EIDOS_LHMMATOS_ID=3 "); theSQL.append(" AND L.ON_SITE=1 "); theSQL.append(" AND L.LHMMA_BODY"+langSuffix+"_ID=LB.LHMMA_BODY_ID "); theSQL.append(" AND AL.ANT_ID=" + obj_id); strSQL = theSQL.toString(); rset = stmt.executeQuery(strSQL); if (rset.next()) { lhmma = rset.getString(1); if (lhmma==null) { lhmma=""; } if (rset.getString(2)!=null) { editor1 = rset.getString(2); } if (rset.getString(3)!=null) { editor2 = rset.getString(3); } if (rset.getString(4)!=null) { editor3 = rset.getString(4); } if (rset.getString(5)!=null) { lhmmaid = rset.getString(5); } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <%//εδώ ανακτούμε το θέμα του αντικειμένου strSQL = "select e.era_id from era e, ant_era ae, ant a where ae.era_id=e.era_id and ae.ant_id=a.ant_id and a.ant_id="+obj_id; rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) {era1=rset.getString(1); } } else { era1="1001"; } if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} strSQL = "select e.parent_id, e.depth from era e, ant_era ae, ant a where ae.era_id=e.era_id and ae.ant_id=a.ant_id and a.ant_id="+obj_id+" and e.era_id="+era1; rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) {parent_era=rset.getString(1); } if (rset.getString(2)!=null) {depth_era=rset.getString(2); } } else { era1="1002"; } if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} if (depth_era.equals("0")) { thisEra = era1; } if (depth_era.equals("1")) { thisEra = parent_era;} if (depth_era.equals("2")) { strSQL = "select parent_id from era where era_id="+parent_era; rset = stmt.executeQuery(strSQL); if (rset.next()) { era1=""; if (rset.getString(1)!=null) { era1=rset.getString(1); } thisEra=era1; } if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} } strSQL = "select mt.group_id from monuments_themes mt where mt.cvalue_id="+eidosid+" and era_id="+thisEra; rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) {thisGroup=rset.getString(1); } } else { thisGroup="2"; } if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} if (thisEra.equals("1001")) {thisEra="1";} if (thisEra.equals("1002")) {thisEra="2";} if (thisEra.equals("1003")) {thisEra="3";} if (thisEra.equals("1004")) {thisEra="4";} %> <% //εδώ τραβάμε τη φωτογραφία για το banner fotobannersrc = "/Thematikos Katalogos Banners/cat2s"+thisEra+thisGroup+".swf?titlos="+titlos; %> <% //εδώ τραβάμε τη φωτογραφία strSQL = "SELECT M.MULTIMEDIA_ID, M.LEZANTA"+langSuffix+", M.COPYRIGHT"+langSuffix+", M.COPYRIGHT_CREATOR"+langSuffix+" FROM MULTIMEDIA M WHERE M.M2_BLOB IS NOT NULL AND M.ON_SITE=1 AND M.ANT_ID="+obj_id+" ORDER BY M.MULTIMEDIA_ORDER ASC"; rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) { fotoid = rset.getString(1); } if (rset.getString(2)!=null) { fotolezanta = rset.getString(2); } if (rset.getString(3)!=null) { fotocopyright = "© " + rset.getString(3); } if (rset.getString(4)!=null) { fotocopyright = "© " + rset.getString(3) + ", " + "© " + rset.getString(4); } fotosize = "m2"; } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <% int obj_id_int = Integer.parseInt(obj_id) ; int erra = Integer.parseInt(thisEra) ; int group = Integer.parseInt(thisGroup) ; String unesco_str = ""; strSQL = " { call odysseas.banners_package.monument_banners(?,?,?,?,?) }"; CallableStatement c2_stmt = conn.prepareCall(strSQL); c2_stmt.setInt(1,obj_id_int); c2_stmt.setInt(2,erra); c2_stmt.setInt(3,group); c2_stmt.registerOutParameter(4,Types.VARCHAR); c2_stmt.registerOutParameter(5,Types.VARCHAR); c2_stmt.execute(); fotobannersrc = (String)c2_stmt.getString(4); unesco_str = (String)c2_stmt.getString(5); %> Ministry of Culture and Sports | <%=titlos%> <%=leftTableString%> <% // ---------------------------------------------------------------------- %> <% // ------------------ εδώ αρχίζει το table με την πληροφορία ------------ %> <% //----------------------------- αρχή του paste εδώ ---------------------- %> <% // ---------------------------------------------------------------------- %>
<% //εδώ τραβάμε τα persons (ιστορικά πρόσωπα) strSQL = "SELECT DISTINCT P.ANT_ID, P.NAME1"+langSuffix+", P.NAME2"+langSuffix+" FROM ANT P, ANT_PERSON AP WHERE P.ONTOTHTA_ID=6 AND P.ON_SITE=1 AND P.ANT_ID=AP.PERSON_ID AND AP.ANT_ID="+obj_id+" ORDER BY P.NAME1"+langSuffix; rset = stmt.executeQuery(strSQL); if (rset.next()) { %> <% } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <% //εδώ τραβάμε τα δευτερεύοντα persons (δημιουργοί) strSQL = "SELECT DISTINCT P.ANT_ID, P.NAME1"+langSuffix+", P.NAME2"+langSuffix+" FROM ANT P, ANT_PERSON_SEC AP WHERE P.ONTOTHTA_ID=6 AND P.ON_SITE=1 AND P.ANT_ID=AP.PERSON_ID AND AP.ANT_ID="+obj_id; rset = stmt.executeQuery(strSQL); if (rset.next()) { %> <% } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <% //εδώ τραβάμε το γλωσσάρι if (!lhmmaid.equals("")) { strSQL = "SELECT G.ANT_ID, G.NAME1"+langSuffix+" "; strSQL = strSQL + " FROM LHMMA_GLOSSARY LG, ANT G "; strSQL = strSQL + " WHERE LG.GLOSSARY_ID=G.ANT_ID "; strSQL = strSQL + " AND LG.LHMMA_ID="+lhmmaid; strSQL = strSQL + " ORDER BY LG.HAS_ORDER ASC"; rset = stmt.executeQuery(strSQL); if (rset.next()) { %> <% }//end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} } %> <% //See Also %> <% //εδώ τραβάμε όλες τα σχετικά αντικείμενα του ίδιου κόμβου strSQL = "SELECT A2.ANT_ID, A2.NAME1"+langSuffix+", A2.MEGE8OS, A2.ONTOTHTA_ID "; strSQL = strSQL + " FROM ANT A2, ANT_ANT AA "; strSQL = strSQL + " WHERE A2.ANT_ID=AA.ANT2_ID "; strSQL = strSQL + " AND AA.ANT_ID="+obj_id; strSQL = strSQL + " ORDER BY NLSSORT(A2.NAME1"+langSuffix+",'NLS_SORT=GREEK') ASC "; rset = stmt.executeQuery(strSQL); if (rset.next()) { %> <% } //end-if %> <% //τέλος See Also %> <% //Εξωτερικά URLS strSQL = "SELECT AU.TITLE"+langSuffix+", U.URL "; strSQL = strSQL + " FROM ANT_URL AU, URL U "; strSQL = strSQL + " WHERE AU.URL_ID=U.URL_ID "; strSQL = strSQL + " AND AU.ANT_ID="+obj_id; rset = stmt.executeQuery(strSQL); if (rset.next()) { %> <% } //end-if %> <% //τέλος Εξωτερικά URLS %>
  <% if (!lhmma.equals("")) { %> <% if (!editor1.equals("")) { %> <% } %> <% if (!editor2.equals("")) { %> <% } %> <% if (!editor3.equals("")) { %> <% } %> <% } %>
<% if (!fotoid.equals("")) { %>
<%=myUtil.rQuotes(fotocopyright,false,true)%>
<%=fotolezanta%>
<% } %> <% if (!lhmma.equals("")) {%>
<%=myUtil.nToBr(lhmma,true,0,2)%>
<% } else { %> The description is not available <% } %>
<%=editors_title%>
<%=editor1%>
<%=editor2%>
<%=editor3%>
 
 
 
Mythological / Historic Persons
<% do { onoma_id = ""; onoma = ""; if (rset.getString(1)!=null) { onoma_id = rset.getString(1); } if (rset.getString(2)!=null) { onoma = rset.getString(2); } // if (rset.getString(3)!=null) { onoma = onoma + " " + rset.getString(3); } onoma = onoma.trim(); if (!onoma.equals("")) { gl_count = "0"; strSQL = ""; strSQL = "select lb.lhmma_body_id"; strSQL = strSQL + " from ant a, ant_lhmma al, lhmma l, lhmma_body lb"; strSQL = strSQL + " where a.ontothta_id=6 and a.on_site=1"; strSQL = strSQL + " and a.ant_id=al.ant_id"; strSQL = strSQL + " and al.lhmma_id=l.lhmma_id"; strSQL = strSQL + " and l.lhmma_body_en_id=lb.lhmma_body_id and a.ant_id="+onoma_id; glrset = glstmt.executeQuery(strSQL); if (glrset.next()) { if (glrset.getString(1)!=null) { gl_count = "1"; } } if (!gl_count.equals("0")) { %> <%} else { %> <%} } //end-if } while (rset.next()); //end-while %>
<%=onoma%>
<%=onoma%>
 
 
Creators
<% do { onoma_id = ""; onoma = ""; if (rset.getString(1)!=null) { onoma_id = rset.getString(1); } if (rset.getString(2)!=null) { onoma = rset.getString(2); } // if (rset.getString(3)!=null) { onoma = onoma + " " + rset.getString(3); } onoma = onoma.trim(); if (!onoma.equals("")) { gl_count = "0"; strSQL = ""; strSQL = "select lb.lhmma_body_id"; strSQL = strSQL + " from ant a, ant_lhmma al, lhmma l, lhmma_body lb"; strSQL = strSQL + " where a.ontothta_id=6 and a.on_site=1"; strSQL = strSQL + " and a.ant_id=al.ant_id"; strSQL = strSQL + " and al.lhmma_id=l.lhmma_id"; strSQL = strSQL + " and l.lhmma_body_id=lb.lhmma_body_id and a.ant_id="+onoma_id; glrset = glstmt.executeQuery(strSQL); if (glrset.next()) { if (glrset.getString(1)!=null) { gl_count = "1"; } } if (!gl_count.equals("0")) { %> <%} else { %> <%} } //end-if } while (rset.next()); //end-while %>
<%=onoma%>
<%=onoma%>
 
 
Glossary
<% do { glossaryid = ""; glossaryname = ""; if (rset.getString(1)!=null) { glossaryid = rset.getString(1); } if (rset.getString(2)!=null) { glossaryname = rset.getString(2); } if (!allglossary.equals("")) { gl_count = "0"; strSQL = ""; strSQL = "select lb.lhmma_body_id"; strSQL = strSQL + " from ant a, ant_lhmma al, lhmma l, lhmma_body lb"; strSQL = strSQL + " where a.ontothta_id=6 and a.on_site=1"; strSQL = strSQL + " and a.ant_id=al.ant_id"; strSQL = strSQL + " and al.lhmma_id=l.lhmma_id"; strSQL = strSQL + " and l.lhmma_body_id=lb.lhmma_body_id and a.ant_id="+glossaryid; glrset = glstmt.executeQuery(strSQL); if (glrset.next()) { if (glrset.getString(1)!=null) { gl_count = "1"; } } if (!gl_count.equals("0")) { %> <%} else { %> <%} } } while (rset.next()); //end-while %>
<%=glossaryname%><%=glossaryname%>
 
 
 
<% do { if (rset.getString(1)!=null) { other_ant_id = rset.getString(1); } if (rset.getString(2)!=null) { other_ant_titlos = rset.getString(2); } if (rset.getString(3)!=null) { other_ant_mege8os = rset.getInt(3); } if (rset.getString(4)!=null) { other_ont_id = rset.getString(4); } if (other_ont_id.equals("1") || other_ont_id.equals("2") || other_ont_id.equals("3")) { other_ant_href = "/h/"+other_ont_id+"/"+langPrefix+"h"+other_ont_id+"51.jsp"; } if (other_ont_id.equals("4")) { other_ant_href = "/h/4/"+langPrefix+"h41.jsp"; } if (other_ont_id.equals("5")) { other_ant_href = "/h/4/"+langPrefix+"h430.jsp"; } if (other_ant_mege8os==2) { other_ant_href = other_ant_href + "?obj_id="+other_ant_id; } else { other_ant_href = other_ant_href + "?obj_id="+other_ant_id; } %> <% } while (rset.next()); %>
  See Also
 
<%=other_ant_titlos%>
 
 
 
<% do { if (rset.getString(1)!=null) { outer_titlos = rset.getString(1); } if (rset.getString(2)!=null) { outer_url = rset.getString(2); } %> <% } while (rset.next()); %>
  Εξωτερικοί Σύνδεσμοι
 
<%=outer_titlos%>
 
 
<% // ---------------------------------------------------------------------- %> <% // -------------- εδώ τελειώνει το table με την πληροφορία -------------- %> <% // -------------------------- τέλος paste εδώ --------------------------- %> <% // ---------------------------------------------------------------------- %> <% } catch (Exception e) { System.out.println(e); } finally { if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} if (stmt!=null) try {stmt.close(); stmt = null; } catch (Exception e) {} conn.close(); conn = null; ds = null; } %>