head 1.1;
access;
symbols
IT1FALL00:1.1;
locks; strict;
comment @# @;
1.1
date 2000.11.22.22.33.26; author dbc; state Exp;
branches;
next ;
desc
@@
1.1
log
@Added Files:
DBConstants.java.txt DBSession.java.txt DestroyTable.java.txt
MakeTable.java.txt Select.java.txt Student.java.txt
Undo.java.txt Update.java.txt View.java.txt index.html
it1fall00.txt
@
text
@
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Select extends HttpServlet {
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException {
try {
HttpSession session = request.getSession(true) ;
DBSession dbs = (DBSession) session.getAttribute("dbs") ;
if(dbs == null) {
dbs = new DBSession() ;
session.setAttribute("dbs", dbs) ;
session.setMaxInactiveInterval(300) ; // 5 minutes.
}
// Extract keys from table
ResultSet rs = dbs.stat.executeQuery("SELECT login FROM " +
DBConstants.table) ;
// Generate response
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("");
// Print selection form
out.println("");
// Print "undo" form
Vector undoList = (Vector) session.getAttribute("undoList") ;
if(undoList != null && undoList.size() > 0) {
out.println("");
}
out.println("");
} catch (SQLException e) {
response.sendError(HttpServletResponse.SC_OK,
"SQL error: " + e.getMessage()) ;
}
}
}
@