<%@ page import="java.sql.*,java.util.*"%> <%-- Document : vieworders Created on : Jul 1, 2008, 4:46:01 AM Author : deep --%> <%@page contentType="text/html" pageEncoding="UTF-8"%> View orders <% Connection c=null; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (Exception e){ out.println("mysql driver unavailable"); } try { c=DriverManager.getConnection("jdbc:mysql://csci351.usc.edu:5159/deep?user=deep&password=deep"); } catch (Exception e) { out.println("no driver manager"); } // Statement s=null; ResultSet rs1 = null; ResultSet rs2 = null; String sqlquery1="select * from orders;"; Statement s = c.createStatement(); rs1 = s.executeQuery(sqlquery1); if(rs1!=null) { %>

<% while(rs1.next()){ %> <% } rs1.close(); s.close(); c.close(); %>

Login list

BACK

ORDER ID

USER ID

FIRST NAME

LAST NAME

ADDRESS LINE1

ADDRESS LINE2

CITY

STATE

ZIP

COUNTRY

PHONE HOME

PHONE WORK

E-MAIL

SERVICE

MONTH

DATE

YEAR

VALUE

WEIGHT

DESCRIPTION

RECEIVER'S FIRST NAME

RECEIVER'S LAST NAME

RECEIVER'S ADDRESS LINE1

RECEIVER'S ADDRESS LINE2

RECEIVER'S CITY

RECEIVER'S STATE

RECEIVER'S ZIP

RECEIVER'S COUNTRY

RECEIVER'S PHONE HOME

RECEIVER'S PHONE WORK

RECEIVER'S E-MAIL

CARD'S FIRST NAME

CARD'S LAST NAME

CARD NUMBER

CARD TYPE

EXPIRY MONTH

YEAR

SECURITY CODE
<%=rs1.getString("oid")%> <%=rs1.getString("userid")%> <%=rs1.getString("fname")%> <%=rs1.getString("lname")%> <%=rs1.getString("address1")%> <%=rs1.getString("address2")%> <%=rs1.getString("city")%> <%=rs1.getString("state")%> <%=rs1.getString("zip")%> <%=rs1.getString("country")%> <%=rs1.getString("phoneh")%> <%=rs1.getString("phonew")%> <%=rs1.getString("email")%> <%=rs1.getString("service")%> <%=rs1.getString("month")%> <%=rs1.getString("date")%> <%=rs1.getString("year")%> <%=rs1.getString("value")%> <%=rs1.getString("weight")%> <%=rs1.getString("description")%> <%=rs1.getString("rfname")%> <%=rs1.getString("rlname")%> <%=rs1.getString("raddress1")%> <%=rs1.getString("raddress2")%> <%=rs1.getString("rcity")%> <%=rs1.getString("rstate")%> <%=rs1.getString("rzip")%> <%=rs1.getString("rcountry")%> <%=rs1.getString("rphoneh")%> <%=rs1.getString("rphonew")%> <%=rs1.getString("remail")%> <%=rs1.getString("cfname")%> <%=rs1.getString("clname")%> <%=rs1.getString("cnumber")%> <%=rs1.getString("ctype")%> <%=rs1.getString("cmonth")%> <%=rs1.getString("cyear")%> <%=rs1.getString("csecurity")%>

BACK

The University of Southern California does not screen or control the content on this website and thus does not guarantee the accuracy, integrity, or quality of such content. All content on this website is provided by and is the sole responsibility of the person from which such content originated, and such content does not necessarily reflect the opinions of the University administration or the Board of Trustees
<%}else{ } %>