<%--
Document : viewmember
Created on : Jan 9, 2011, 7:19:23 PM
Author : zamir
--%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
View Members
<% if (session.getAttribute("xname") == null) { %>
<% response.sendRedirect("login.jsp?id="+request.getParameter("id")); %>
<% } else {
String param = request.getParameter("id");
String connectionURL = "jdbc:mysql://localhost:3306/itfnet_itfnetportal?user=itfnet_itfnet&password=qwerty";
//String connectionURL = "jdbc:mysql://localhost:3306/itfnet_itfnetportal?user=root&password=password";
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
String query;
String memId = "";
String cname = "";
String add1 = "";
String add2 = "";
String add3 = "";
String add4 = "";
String add5 = "";
String add = "";
String country="";
String cat="";
String contactno="";
String faxnum="";
String email = "";
String website ="";
String desc = "";
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL);
statement = connection.createStatement();
query = "SELECT * FROM tradeinfo a, tradeinfocategory b WHERE tradeinfo_id = "+param+" AND a.tradeinfo_cat = b.id ";
if(request.getParameter("country")!= null){
String c = request.getParameter("country");
query += "and tradeinfo_country='"+c+"'";
}
query += "ORDER BY tradeinfo_country";
rs = statement.executeQuery(query);
while (rs.next()) {
cname = rs.getString("tradeinfo_name");
add1 = rs.getString("tradeinfo_address");
add2 = rs.getString("tradeinfo_address2");
add3 = rs.getString("tradeinfo_city");
add4 = rs.getString("tradeinfo_state");
country = rs.getString("tradeinfo_country");
add5 = rs.getString("tradeinfo_postal");
add = add1 +","+add2+","+add5+","+add3+","+add4;
cat = rs.getString("category");
contactno = rs.getString("tradeinfo_contact");
faxnum = rs.getString("tradeinfo_fax");
email = rs.getString("tradeinfo_email");
website = rs.getString("tradeinfo_web");
desc = rs.getString("tradeinfo_desc");
}
rs.close();
connection.close();
%>
Company Details |
| Category |
: |
<% out.println(cat); %> |
| Company Name |
: |
<% out.println(cname); %> |
| Address |
: |
<% out.println(add); %> |
| Country |
: |
<% out.println(country); %> |
| Contact No. |
: |
<% out.println(contactno); %> |
| Fax No. |
: |
<% out.println(faxnum);%> |
| Email |
: |
<% out.println(email); %> |
| Website |
: |
<% out.println(website); %> |
| Main Product & Description |
: |
<% out.println(desc); %> |
<% } %>
