<%@ page import="java.sql.*,java.util.*"%>
<%--
Document : vieworder
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 login;";
Statement s = c.createStatement();
rs1 = s.executeQuery(sqlquery1);
if(rs1!=null)
{
%>
Login list |
|
|
LOGIN |
PASSWORD |
USER TYPE |
<%
while(rs1.next()){
%>
| <%=rs1.getString("userid")%> |
<%=rs1.getString("password")%> |
<%=rs1.getString("type")%> |
<%
}
rs1.close();
s.close();
c.close();
%>
|
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{
}
%>