|
/*
MySQL and Java Developer's Guide
Mark Matthews, Jim Cole, Joseph D. Gradecki
Publisher Wiley,
Published February 2003,
ISBN 0471269239
*/
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
public class SeeAccount extends HttpServlet {
public void doGet(HttpServletRequest inRequest,
HttpServletResponse outResponse) throws ServletException,
IOException {
PrintWriter out = null;
Connection connection = null;
Statement statement = null;
ResultSet rs;
try {
outResponse.setContentType("text/html");
out = outResponse.getWriter();
Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx
.lookup("java:comp/env/jdbc/AccountsDB");
connection = ds.getConnection();
statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM acc_acc");
ResultSetMetaData md = rs.getMetaData();
out
.println("<HTML><HEAD><TITLE> Thumbnail Identification Record</TITLE></HEAD>");
out.println("<BODY>");
out.println("Account Information:<BR>");
out.println("<table>");
out.println("<tr><td>");
for (int i = 1; i <= md.getColumnCount(); i++) {
out.println("Column #" + i + "<BR>");
out.println("getColumnName : " + md.getColumnName(i) + "<BR>");
out.println("getColumnClassName : " + md.getColumnClassName(i)
+ "<BR>");
out.println("getColumnDisplaySize : "
+ md.getColumnDisplaySize(i) + "<BR>");
out.println("getColumnType : " + md.getColumnType(i) + "<BR>");
out.println("getTableName : " + md.getTableName(i) + "<BR>");
out.println("<HR>");
}
out.println("</BODY></HTML>");
} catch (Exception e) {
e.printStackTrace();
}
}
public void doPost(HttpServletRequest inRequest,
HttpServletResponse outResponse) throws ServletException,
IOException {
doGet(inRequest, outResponse);
}
}
|
