<%@ page import="java.sql.*,java.util.*,sun.net.smtp.SmtpClient, java.io.*,java.util.*" %> <%@ include file="Common.jsp" %> <%@ page errorPage="MyErrorPage.jsp" %> <% String chSQL="select * from link_categories"; String count="none"; String smessagesErr=""; String sSQL=""; java.sql.Connection conn = null; java.sql.Statement stat = null; String sErr = loadDriver(); conn = cn(); stat = conn.createStatement(); if ( ! sErr.equals("") ) { try { out.println(sErr); } catch (Exception e) { out.println(e.toString()); // response.sendRedirect("links.jsp?message=There had been some problem while processing the request, please contact System Admin"); } } int action_result=0; String link_cats=""; Vector v_cats = new Vector(); try { java.sql.ResultSet rs = null; rs = openrs( stat, chSQL); while (rs.next()) { count="yes"; link_cats=rs.getString(2); v_cats.add(link_cats); }//end while if ( rs != null ) rs.close(); if ( stat != null ) stat.close(); if ( conn != null ) conn.close(); }//end try catch(java.sql.SQLException e) { smessagesErr = e.toString(); out.println(smessagesErr); //response.sendRedirect("links.jsp?message=Links Could not be loaded successfully,please try again later"+smessagesErr); } %> BizAngels | Investitii | Oportunitati | Antreprenori | Afaceri
HOME | ANTREPRENORI | INVESTITORI | DESPRE NOI | DOCUMENTE | CONTACT
:: Pentru a participa la oferta noastra de link exchange, te rugam sa dai click aici ::
 

<% String web_url="",web_title="",web_description=""; String db_cats; int i ; if (v_cats.isEmpty()) out.println("v_cats.isEmpty()"+v_cats+"
"); out.println("
"); out.println("
"); out.println(" "); out.println("
"); out.println("CATEGORII ::.

"); out.println("
"); for (int j = 0; j < v_cats.size(); j++) {db_cats = (String)v_cats.elementAt(j); if (db_cats!=null) {out.println(""+db_cats+", ");}//end if }//end for out.println("
 

"); /////////////////////////////////////////////////////// // within this block we will make several database // // connections to retreive the values according // // to the matching values named as db_cats // /////////////////////////////////////////////////////// conn = cn(); stat = conn.createStatement(); out.println("
"); if (v_cats.isEmpty()) out.println("v_cats.isEmpty()"+v_cats+"
"); for (int j = 0; j < v_cats.size(); j++) {db_cats = (String)v_cats.elementAt(j); if (db_cats!=null) { chSQL="select * from bizz_links where link_category ='"+db_cats+"'"; //out.println(j+"  "+db_cats+"
"); //out.println(chSQL+"
"); out.println(""+db_cats+" ::.

"); try { java.sql.ResultSet rs_2 = null; rs_2 = openrs( stat, chSQL); while (rs_2.next()) { count="yes"; link_cats=rs_2.getString(2); web_title=rs_2.getString(3); web_url=rs_2.getString(4); web_description=rs_2.getString(5); out.println(""+web_title+"
"); out.println(web_description+"

"); }//end while if ( rs_2 != null ) rs_2.close(); }//end try catch(java.sql.SQLException e) { smessagesErr = e.toString(); out.println(smessagesErr); //response.sendRedirect("links.jsp?message=Links Could not be loaded successfully,please try again later"+smessagesErr); } out.println("

 • TOP ↑↑
 


"); }//end if }//end for try{ if ( stat != null ) {stat.close();} if ( conn != null ) {conn.close();} } catch(Exception e) { smessagesErr = e.toString(); out.println(smessagesErr); //response.sendRedirect("links.jsp?message=Links Could not be loaded successfully,please try again later"+smessagesErr); } //////////////////////////////////////////////////////// %>