/**
* Original version by Wisam Dakka
* Modified by John Cieslewicz
* Modified by Hye Seon Yi
*/
import java.io.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.sql.*;
public class Project1Sample extends HttpServlet {
String database = "jdbc:postgresql://w4111b.cs.columbia.edu/hye_yi"; //Edit this string accordingly
public void doGet (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
try {
Class.forName("org.postgresql.Driver");
Connection conn = DriverManager.getConnection(database,
"coms4111", //user, Edit this string accordingly
"database"); //password, Edit this string accordingly
Statement s = conn.createStatement();
ResultSet r = s.executeQuery("Select * from prof");
out.println("");
out.println("Professors:
");
out.println("| ");
out.println("Name | Department |
");
while (r.next()) {
out.println("");
out.println("| " + r.getString(1) + " | ");
out.println("" + r.getString(2) + " | ");
out.println("
");
}
out.println("
");
out.println("");
s.close();
conn.close();
}
catch (Exception e) {
out.println("The database could not be accessed. More ");
out.println("information is available as follows:
");
e.printStackTrace(out);
}
} // end doGet method
} // end DatabaseServlet class