import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class View 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.
}
String login, lastname, firstnames, email, dept ;
// Get the key string
login = request.getParameter("login") ;
if(login == null) {
response.sendError(HttpServletResponse.SC_OK,
"No ID selected") ;
return ;
}
// Query the database and extract the fields
ResultSet rs = dbs.stat.executeQuery(
"SELECT * FROM " + DBConstants.table + " " +
"WHERE login='" + login + "'") ;
if(rs.next()) {
lastname = rs.getString(2) ;
firstnames = rs.getString(3) ;
email = rs.getString(4) ;
dept = rs.getString(5) ;
} else {
response.sendError(HttpServletResponse.SC_OK,
"Record not found") ;
return ;
}
// Save fields of current record in session
session.setAttribute("curr",
new Student(login, lastname, firstnames, email, dept)) ;
// Generate updatable display of current record
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("");
out.println("");
out.println("");
out.println("");
} catch (SQLException e) {
response.sendError(HttpServletResponse.SC_OK,
"SQL error: " + e.getMessage()) ;
}
}
}