<%@ page import="java.sql.*"%> <%@ page import="java.sql.Timestamp"%> <%@ page import="java.text.SimpleDateFormat"%> <%@ page import="java.text.DateFormat"%> <%@page import="javax.mail.*"%> <%@page import="javax.mail.internet.*" %> <%@page import="java.net.InetAddress " %> <%@page import="java.util.Properties " %> <%@page import="javax.servlet.http.*" %> <%@ include file="config.inc.jsp"%> <% try { Connection connection = null; Statement statement = null; Statement statement2 = null; ResultSet rs2 = null; ResultSet rs = null; PreparedStatement ps = null; Class.forName("com.mysql.jdbc.Driver").newInstance(); connection = DriverManager.getConnection(connectionURL, user, pass); statement = connection.createStatement(); statement2 = connection.createStatement(); java.util.Date today = new java.util.Date(); String tmp = ""; String[] splitedStr; int n =0,i=0; rs = statement.executeQuery("SELECT * FROM reseller WHERE rs_country='Malaysia' ORDER BY rsid"); while (rs.next()) { if (n % 2 == 0) out.println(""); out.println(""); if (n % 2 != 0) out.println(""); n++; } out.println(""); rs = statement.executeQuery("SELECT * FROM reseller WHERE rs_country!='Malaysia' ORDER BY rsid"); n=0; while (rs.next()) { if (n % 2 == 0) out.println(""); out.println(""); if (n % 2 != 0) out.println(""); n++; } } catch (SQLException ex) { // handle any errors System.out.println("SQLException: " + ex.getMessage()); System.out.println("SQLState: " + ex.getSQLState()); System.out.println("VendorError: " + ex.getErrorCode()); } %>

Malaysia

"); out.println(""); if (rs.getInt("rs_contactd") == 1) { out.println(""); } if (rs.getInt("rs_telephoned") == 1) { tmp=rs.getString("rs_telephone"); splitedStr=tmp.split(","); for(i=0;i < splitedStr.length;i++) out.println(""); } if (rs.getInt("rs_emaild") == 1) out.println(""); out.println(" "+rs.getString("rs_name")+" ("+rs.getString("rs_country")+") "+rs.getString("rs_address")+" "+rs.getString("rs_contact")+" ("+rs.getString("rs_position")+") "+splitedStr[i]+" "+rs.getString("rs_email")+"

International

"); out.println(""); if (rs.getInt("rs_contactd") == 1) { if (rs.getString("rs_position")==null) out.println(""); else out.println(""); } if (rs.getInt("rs_telephoned") == 1) { tmp=rs.getString("rs_telephone"); splitedStr=tmp.split(","); for(i=0;i < splitedStr.length;i++) out.println(""); } if (rs.getInt("rs_emaild") == 1) out.println(""); out.println(" "+rs.getString("rs_name")+" ("+rs.getString("rs_country")+") "+rs.getString("rs_address")+" "+rs.getString("rs_contact")+" ("+rs.getString("rs_position")+") "+rs.getString("rs_contact")+" "+splitedStr[i]+" "+rs.getString("rs_email")+"