// Fig. 16.25: GetTechnologyServlet.java
// Retrieves technologies from database
package cartXML;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.sql.*;
import org.w3c.dom.*;

public class GetTechnologyServlet extends HttpServlet {
   private Database database;

   public void init( ServletConfig config )
      throws ServletException
   {
      super.init( config );
      database = new Database( "jdbc:odbc:catalog", "anonymous",
         "guest" );
      database.connect();
   }

   public void service( HttpServletRequest req,
      HttpServletResponse res )
      throws ServletException, IOException
   {
      try {
         HttpSession session = req.getSession( true );
         ShoppingCart cart =
            ( ShoppingCart ) session.getAttribute( "cart" );
         ServletContext sc = getServletConfig()
            .getServletContext();

         if ( cart.getUsername() == null ) {
            sc.getRequestDispatcher( "/index.wml" )
               .forward( req, res );
            return;
         }

         XMLCreator xmlCreator = new XMLCreator();
         Node catalogNode = xmlCreator.initialize( "catalog" );
         String query = "SELECT * FROM tech";
         ResultSet rs = database.get( query );

         while ( rs.next() ) {
            Node productNode = xmlCreator.addChild( catalogNode,
               "product" );
            xmlCreator.addTextNode( xmlCreator.addChild(
               productNode, "techID" ),
               rs.getString( "techID" ) );
            xmlCreator.addTextNode( xmlCreator.addChild(
               productNode, "technology" ),
               rs.getString( "technology" ) );
         }

         res.setContentType( "text/vnd.wap.wml" );
         PrintWriter output = res.getWriter();
         Processor processor = new Processor();
         processor.process( xmlCreator.getDocument(),
            "C:/jakarta-tomcat/webapps/chapter16/catalog.xsl",
            output );
      }
      catch ( SQLException sqlex ) {
         sqlex.printStackTrace();
      }
   }

   public void destroy()
   {
      database.shutDown();
   }
}
/*
 **************************************************************************
 * (C) Copyright 2001 by Deitel & Associates, Inc. and Prentice Hall.     *
 * All Rights Reserved.                                                   *
 *                                                                        *
 * DISCLAIMER: The authors and publisher of this book have used their     *
 * best efforts in preparing the book. These efforts include the          *
 * development, research, and testing of the theories and programs        *
 * to determine their effectiveness. The authors and publisher make       *
 * no warranty of any kind, expressed or implied, with regard to these    *
 * programs or to the documentation contained in these books. The authors *
 * and publisher shall not be liable in any event for incidental or       *
 * consequential damages in connection with, or arising out of, the       *
 * furnishing, performance, or use of these programs.                     *
 **************************************************************************
*/