import java.io.*;
import java.util.Random;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class GetTable extends HttpServlet {
public void service(HttpServletRequest req, HttpServletResponse res) //doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
Connection db;
Statement st;
String url = "jdbc:postgresql://ellemose.dina.kvl.dk/gp";
String usr = "gp";
String pwd = "e2000";
res.setContentType("text/html");
ServletOutputStream out = res.getOutputStream();
String[] tableParms = req.getParameterValues("table");
String table = tableParms[0];
String[] field1Parms = req.getParameterValues("field1");
String field1 = field1Parms[0];
String[] field2Parms = req.getParameterValues("field2");
String field2 = field2Parms[0];
out.println("");
out.println("Get Contents of Table " + table + "
");
try {
Class.forName("postgresql.Driver");
db = DriverManager.getConnection(url, usr, pwd);
st = db.createStatement();
String query = "SELECT " + field1 + "," + field2 + " FROM " + table + ";";
boolean resultset = st.execute(query);
out.println("| " + field1 + " | " + field2 + " |
|---|
");
if (resultset) {
ResultSet rs = st.getResultSet();
while (rs.next()) {
String f1 = rs.getString(field1);
String f2 = rs.getString(field2);
out.println("| " + f1 + " | " + f2 + " |
");
}
}
out.println("
");
st.close();
db.close();
} catch (ClassNotFoundException e) {
out.println("Cannot find the Postgresql driver");
} catch (SQLException e) {
out.println("
"+e);
}
out.println("");
}
}