// Fig. 16.28: GetTitlesServlet.java
// Retrieves titles 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 GetTitlesServlet 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 productNode = xmlCreator.initialize( "products" );
         String techID = req.getParameter( "techID" );
         String query = "SELECT title, edition, productID FROM "
            + "products WHERE techid= " + techID;
         ResultSet rs = database.get( query );

         while ( rs.next() ) {
            Node itemNode = xmlCreator.addChild( productNode,
               "item" );

            xmlCreator.addTextNode( xmlCreator.addChild( itemNode,
               "title" ), rs.getString( "title" ) );
            xmlCreator.addTextNode( xmlCreator.addChild( itemNode,
               "productID" ), rs.getString( "productID" ) );
            xmlCreator.addTextNode( xmlCreator.addChild( itemNode,
               "techID" ), techID );
         }

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

   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.                     *
 **************************************************************************
*/