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()) ;
}
}
}