/*
 * Cree le 22 juin 2005 ?? 14:55:50
 * 
 * Auteur: kiorky
 * 
 * Copyright (C) 22 juin 2005 kiorky
 * 
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License as published by the Free Software
 * Foundation; either version 2 of the License, or (at your option) any later
 * version.
 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
 * details.
 *  
 */

package dodjcms.servlets.test;

import java.io.*;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
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;

/**
 * @author kiorky
 *  
 */
public class srv2 extends HttpServlet{

    public String getServletInfo() {
        return "Servlet connects to MySQL database and displays result of a SELECT";
    }

    // Use http GET
    public void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        PrintWriter out = resp.getWriter();
        try {  	

            Context initContext = new InitialContext();
            javax.naming.Context envContext  = (javax.naming.Context)initContext.lookup("java:/comp/env");
            DataSource ds = (DataSource)envContext.lookup("jdbc/dodjcms");
            Connection conn = ds.getConnection();
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("select * from categdossier;");
            printResultSet(resp, rs);
        }
        
        catch (SQLException ex) { 
           while (ex != null) {
               		resp.getWriter().println ("SQL Exception: " + ex.getMessage ()); ex =
                    ex.getNextException (); 
          } 
        } // end catch SQLException
         
        catch (java.lang.Exception ex) {
            resp.getWriter().println(
                    "<HTML>" + "<HEAD><TITLE>" + "Bedrock: Error"
                            + "</TITLE></HEAD>\n<BODY>"
                            + "<P>SQL error in doGet: " + ex.getMessage()
                            + "</P></BODY></HTML>");
            return;
        }
        out.close();
    }

    private void printResultSet(HttpServletResponse resp, ResultSet rs)
            throws SQLException {
        try {
            PrintWriter out = resp.getWriter();
            out.println("<html>");
            out.println("<head><title>jbs jdbc/mysql servlet</title></head>");
            out.println("<body>");
            out.println("<center><font color=AA0000>");
            out.println("<h3>jbsJDBCServlet</h3>");
            out.println("<h3>Data Retrieved:</h3>");
            out.println("<table border='1'>");

            int numCols = rs.getMetaData().getColumnCount();
            while (rs.next()) {
                out.println("<tr>");
                for (int i = 1; i <= numCols; i++) {
                    out.print("<td>" + rs.getString(i) + "</td>");
                } // end for
                out.println("</tr>");
            } // end while

            out.println("</table>");

            out.println("</font></center>");
            out.println("</body>");
            out.println("</html>");
            out.close();

        } // end try
        catch (IOException except) {
        } // end catch

    } // end returnHTML

}