%@ include file="style.jsp"%>
<%@ include file="header.jsp"%>
<%@ include file="mainLeft.jsp"%>
Home
> Resellers
Malaysia
<%@ 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("
"+rs.getString("rs_name")+"
("+rs.getString("rs_country")+")
"); out.println("
"+rs.getString("rs_address")+"
"); if (rs.getInt("rs_contactd") == 1) { out.println("
"+rs.getString("rs_contact")+" ("+rs.getString("rs_position")+")
"); } if (rs.getInt("rs_telephoned") == 1) { tmp=rs.getString("rs_telephone"); splitedStr=tmp.split(","); for(i=0;i < splitedStr.length;i++) out.println("
"+splitedStr[i]+"
"); } if (rs.getInt("rs_emaild") == 1) out.println("
"+rs.getString("rs_email")+"
"); out.println("
"); if (n % 2 != 0) out.println("
"); n++; } out.println("
International
"); 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("
"+rs.getString("rs_name")+"
("+rs.getString("rs_country")+")
"); out.println("
"+rs.getString("rs_address")+"
"); if (rs.getInt("rs_contactd") == 1) { if (rs.getString("rs_position")==null) out.println("
"+rs.getString("rs_contact")+" ("+rs.getString("rs_position")+")
"); else out.println("
"+rs.getString("rs_contact")+"
"); } if (rs.getInt("rs_telephoned") == 1) { tmp=rs.getString("rs_telephone"); splitedStr=tmp.split(","); for(i=0;i < splitedStr.length;i++) out.println("
"+splitedStr[i]+"
"); } if (rs.getInt("rs_emaild") == 1) out.println("
"+rs.getString("rs_email")+"
"); 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()); } %>
<%@ include file="footer.jsp"%>