SeeAccount.java Source code

Introduction

Here is the source code for SeeAccount.java
Source

/*
    
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);
    }
}