/* $Id: JndiServlet.java,v 1.1.1.1 2002/01/03 15:07:20 jpan Exp $
 *
 */

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Enumeration;
import java.util.Hashtable;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.naming.NamingException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingEnumeration;
import javax.naming.directory.InitialDirContext;
import javax.sql.DataSource;
import java.sql.*;

/**
 * Based on the JndiServlet as distributed in tomcat.
 *
 */

public class JndiTestServlet
    extends HttpServlet {


    public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

        PrintWriter out = response.getWriter();
        response.setContentType("text/plain");

        Context ctx = null;

        try {
            ctx = new InitialContext();
        } catch (NamingException e) {
            out.println("Couldn't build an initial context : " + e);
            return;
        }

        try {
            Object value = ctx.lookup("java:/comp/env/maxExemptions");
            out.println("Simple lookup test : ");
            out.println("Max exemptions value : " + value);
        } catch (NamingException e) {
            out.println("JNDI lookup failed : " + e);
        }

        try {
            Context envCtx = (Context) ctx.lookup("java:/comp/env/");
            out.println("list() on /comp/env Context : ");
            NamingEnumeration enum = ctx.list("java:/comp/env/");
            while (enum.hasMoreElements()) {
                out.print("Binding : ");
                out.println(enum.nextElement().toString());
            }

            out.println("listBindings() on /comp/env/jdbc Context : ");
            enum = ctx.listBindings("java:/comp/env/jdbc");
            while (enum.hasMoreElements()) {
                out.print("Binding : ");
                out.println(enum.nextElement().toString());
            }

            DataSource ds = (DataSource)envCtx.lookup("jdbc/EmployeeAppDb");
            out.println("DataSource:"+ds);
            Connection connection = ds.getConnection();
            Statement stmt = connection.createStatement();
            ResultSet rs = stmt.executeQuery("Select * from permissions");
            while(rs.next()){
              String subject = rs.getString(1);
              out.println(subject);
            }
        } catch (Exception e) {
            out.println("JNDI lookup failed : " + e);
        }

    }


}