Forum:

Shopping cart help

Greenhorn

Posts: 16

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I'm currently working on a school project that deals with shopping cart. I'm not using MVC 2 Model, Cos I don't learn struts and so things are getting complicated.
I couldn't seem to add any other items into the cart, other than the ID and the quantity. What should I do if I want to add the rest of the string from the data, i.e. unit Price and total price?

Here's the following codes in mind (will be quite long):

Or you can PM me if you want the whole set of files.

Thanks & regards.

This is the product JSP page:

<%@ include file="/setErrorPage.jsf"%>

<%@ page import="java.util.*, edu.rmit.isys2049.MedicinesData" %>

<%-- Instantiate a "worker" bean --%>
<jsp:useBean id="accessBean" scope="session" class="edu.rmit.isys2049.MedicinesAccessBean" /> 
<%-- No "data" bean required --%>

<HTML>
   <HEAD>
      <TITLE>List Products</TITLE>
   </HEAD>

<BODY>
      
      <%@ include file="/header.html"%>
      
      
      <table >
          <tr >
             
             <td   >
                
                <%@ include file="menu01.html"%>           
             </td>
             <td >
                
                
                <H2>List Products</H2>
                
                <%@ include file="setDbDetails.jsf" %>
                
                <% 
                   // Find all employees
                   // findAll() will return a list of employees if any
                   Vector list = accessBean.findAll(); 
                   if(list != null) { %>
                      <FORM ACTION="dispatcher" METHOD="POST"> 
 
 			<table>
 
     			<tr>
       			<td><INPUT TYPE="HIDDEN" NAME="action" VALUE="listEmp2"></td>
    			</tr>
 
    			<tr>
                         <td>Medicine ID</td>  
                         <td>Supplier ID</td>  
                         <td>Medicine Name</td>  
                         <td>Medicine Description</td>
                         <td>Unit Price</td>  
                         <td>Qty </td>
                         <td>min Stock Level</td>
                         <td>order</td>
                         <td>order:</td>
            				</tr>
             
     					<%
     				            MedicinesData    med;
    					    Iterator        it    = list.iterator();
        					    int             count = 0;
 						
        
     				          while (it.hasNext()) {
          				        med = (MedicinesData) it.next();
     					%>
                   
     					<tr FFCCCC":"FFFFFF" %>">
     				       <td><%= med.getMedicineID() %></td>  
    					<td><%= med.getSupplierID() %></td>  
    					<td><%= med.getMedicineName() %></td>  
        					<td><%= med.getMedicineDescription() %></td> 
      					<td><%= med.getUnitPriceString() %></td>  
      	  				<td><%= med.getQtyInStock() %></td>
                                         <td><%= med.getMinStockLevel() %></td>
                                        <td><%= med.getOrderQty() %></td>
   
 
       					 <td><input type="TEXT" size="2" name="quantity_<%=count%>" value=""></td>
       					 <td><input type="HIDDEN" size="2" name="medicine_<%=count%>" value="<%=med.getMedicineID()%>"></td>				 
 	 					</tr>
    						 <%     	 		
 								count++; 
 						 	} %>
 
    						 <tr>
      					 <td><INPUT TYPE="HIDDEN" NAME="count" VALUE="<%=count%>"></td>
    						 </tr>
     
     					 <tr>
       					 <td><INPUT TYPE="SUBMIT" VALUE="Submit"></td>
    						 </tr>
 						 </table>
 					</FORM>
 
                                          
                   <% } else { %>
              		 <%@ include file="listEmp1b.jsf" %>
                   <% } %>
                
                               
                
             </td>
          </tr>
 
       </table>
       
       
       <%@ include file="/footer.html"%>
       
    </BODY>
 </HTML>

The problem lies with this page:

<%-- 
    listEmp2.jsp - Second output page for listing employee
    Version 2    - Innput boxes
    France Cheong
 --%>
 
 <%@ include file="/setErrorPage.jsf"%>
 <%-- Following imports required --%>
 <%@ page import="java.util.*"%> 
 <%@ page import="java.text.NumberFormat" %>
 <%@ page import="edu.rmit.isys2049.MedicinesData"%>
 <%@ page import="edu.rmit.isys2049.LineItemsData"%>
 
 <%-- Instantiate a "worker" bean --%>  
 <jsp:useBean id="accessBean" scope="session" class="edu.rmit.isys2049.MedicinesAccessBean" /> 
 
 <jsp:useBean id="lineItemsBean" scope="session" class="edu.rmit.isys2049.LineItemsAccessBean" />
 
 
 <HTML>
    <HEAD>
       <TITLE>List Medicines</TITLE>
    </HEAD>
 
    <BODY>
       
       <%@ include file="/header.html"%>
       
       
       <table >
          <tr >
             
             <td   >
                
                <%@ include file="menu01.html"%>
             </td>
             <td >
                
                
                <H2>List Products</H2>
   
                <p>
                  <INPUT TYPE="HIDDEN" NAME="action" VALUE="listEmp3">
    				 <%@ include file="listEmp2a.jsf" %>                
    		      <form method="post" action="dispatcher">
        		      <p >
        		      				<%
 							Vector items = order.orderedItems;
 							if(items.size()==0)  {
 						 %>
 							Your cart is empty.
 						<%  }
 							else  {
 						%>
 				<table   class=data >
                   				<tr>
                     				<th>Medicine ID</th>
                    				 <th>Qty Ordered</th>
                     				<th>Unit Price</th>
                     				<th>Total Price</th>
                   				</tr>
                   <%
 					
 					Enumeration e = items.elements();
 					while(enum.hasMoreElements())
 					{
 						//OrderedItem item = (OrderedItem)enum.nextElement();
 						LineItemsData lItem = (LineItemsData) e.nextElement()
 						MedicinesData med	= accessBean.findByPrimaryKey(lItem.nProductID);
 				  %>
                     <tr FFCCCC":"FFFFFF" %>">
                     	<td ><STRONG><%=lItem.txtName%></STRONG><BR></td>
                     	<td ><%=(int)product.dblQtyPerPack%><BR></td>
                     	<td >S$<%=(item.dblPrice)%> per 
                     
                     
                     Qty</td>
                     <td ><STRONG><%=format(item.nQuantity*item.dblPrice)%>$</STRONG></td>
                   </tr>
                   <%
 					}
 				%>
                 </table>
                 <BR>
                 <input type="submit" name="button" id="button" value="Confirm order">
                 <BR>
        		  </form>
 <% } else { %>
                        			<%@ include file="listEmp2b.jsf" %>
      <% } %>
                        
                        </p>                       </td>
                        </tr>
                        </table>
 
                        <%@ include file="/footer.html"%>
    		    </table>
                            
</BODY>
</HTML>

The Java files:

package edu.rmit.isys2049;

//import MedicinesDAO;
//import MedicinesData;

import java.util.Vector;

public class MedicinesAccessBean implements java.io.Serializable   {

// Attributes
	  // ==========

// JNDI attributes needed to connect to datasource
	  // These attributes are set from the calling JSP
	  // from the included JSP fragment setDbDetails.jsf
	  // The values are stored as context-params in web.xml
	  private String jndiName;

// Constructors
	  // ============

/**
	   *  Constructor
	   */
	  public MedicinesAccessBean() {
	     // Do nothing
	  }

// Public methods
	  // ==============

/**
	   *  Find all employees
	   *
	   *  @return list of employees found
	   *
	   *  @throws java.lang.Exception
	   */
	  public Vector findAll()  throws Exception   {
	     // Perform the work within a try-catch block
	     try {
	        // Instantiate a DAO object to do the work
	        // Pass all the parameters to connect to the datasource
	        // in the constructor
	        MedicinesDAO dao = new MedicinesDAO(jndiName);

// Do the work and return a vector of objects
	        return dao.findAll();

} catch (Exception e) {

// Catch any exception thrown
			// Display it on the console
			// And re-throw it to the calling program
	        System.out.println(e.getMessage());
	        throw e;
	     }

} // findAll()

/**
	   *  Find an employee by its primary key
	   *
	   *  @param emp   Employee to find
	   *
	   *  @return Employee found
	   *
	   *  @throws java.lang.Exception
	   */
	  public MedicinesData findByPrimaryKey(MedicinesData med) throws Exception  {

// Perform the work within a try-catch block
	     try {
	        // Instantiate a DAO object to do the work
	        // Pass all the parameters to connect to the datasource
	        // in the constructor
	        MedicinesDAO dao = new MedicinesDAO(jndiName);

// Do the work and return an object
	        return dao.findByPrimaryKey(med);

} catch (Exception e) {

// Catch any exception thrown
			// Display it on the console
			// And re-throw it to the calling program
	        System.out.println(e.getMessage());
	        throw e;
	     }

} // findByPrimaryKey()

/**
	   *  Add an employee
	   *
	   *  @param med  Employee to add
	   *
	   *  @return true if sucess, false otherwise
	   *
	   *  @throws java.lang.Exception
	   */
	  public boolean add(MedicinesData med) throws Exception  {

// Do the work and return true/false
	        return dao.add(med);

} catch (Exception e) {

// Catch any exception thrown
			// Display it on the console
			// And re-throw it to the calling program
	        System.out.println(e.getMessage());
	        throw e;
	     }

} // add()

/**
	   *  Edit an employee
	   *
	   *  @param med  Employee to edit
	   *
	   *  @return true if sucess, false otherwise
	   *
	   *  @throws java.lang.Exception
	   */
	  public boolean edit(MedicinesData med) throws Exception  {

// Do the work and return true/false
	        return dao.edit(med);

} catch (Exception e) {

// Catch any exception thrown
			// Display it on the console
			// And re-throw it to the calling program
	        System.out.println(e.getMessage());
	        throw e;
	     }

} // edit()

/**
	   *  Delete an employee
	   *
	   *  @param med  Employee to delete
	   *
	   *  @return true if sucess, false otherwise
	   *
	   *  @throws java.lang.Exception
	   */
	  public boolean delete(MedicinesData med)throws Exception  {

// Do the work and return true/false
	        return dao.delete(med);

} catch (Exception e) {

// Catch any exception thrown
			// Display it on the console
			// And re-throw it to the calling program
	        System.out.println(e.getMessage());
	        throw e;
	     }

} // delete()

// Getters/Setters
	  // ===============

/**
	   *  Sets JNDI name of datasource
	   *
	   *  @param jndiName  Name of datasource
	   */
	  public void setJndiName(String jndiName)
	  {
	    this.jndiName = jndiName;
	  }

// PRIVATE METHODS
	  // ===============

}

DAO:

package edu.rmit.isys2049;

//import MedicinesData;

import java.util.Vector;

//Needed for JDBC work
import java.sql.*;

//For Datasources
//Make sure jdbc2_0-stdext.jar & jndi.jar is in classpath
//(see build.xml)
//Alternatively, can use j2ee.jar (contains everything)
import javax.sql.*;
import javax.naming.*;

public class MedicinesDAO implements java.io.Serializable {

// Attributes
	  // ==========

// JNDI attributes needed to connect to datasource
	  // These attributes are set from EmployeeAccessBean
	  // which is set from the included JSP fragment setDbDetails.jsf
	  private String jndiName;

// Constructors
	  // ============

/**
	   *  Constructor
	   */
	  public MedicinesDAO(String jndiName) {

// Initialize attributes
	     this.jndiName        = jndiName;
	  }

// Public methods
	  // ==============

/**
	   *  Find all employees
	   *
	   *  @return list of employees found
	   *
	   *  @throws java.lang.Exception
	   */
	  public Vector findAll() throws Exception   {

Connection dbConn = null;

try {
	        // Get a database connection
	        dbConn = getConnection();

// Perform the work
	        return findAllMedicines(dbConn);

} catch (SQLException e) {

// Here we are catching exceptions only to print them for
	        //    debugging purposes
	        // May be we could log them to a file
	        // Once caught, we are re-throwing them once again to a higher level
	        // If you are not doing anything when catching the exceptions
	        //    then don't catch them
	        System.out.println(e.getMessage());
	        // Print any other nested exceptions
	        while ((e = e.getNextException()) != null) {
	           System.out.println("   next " + e.getMessage());
	        }

throw e; // Re-throw the SQLException

} finally {

// Close the DB even if an Exception has occurred
	        // Otherwise it will be left open
	        // SHOULD be in the finally block
	        closeConnection(dbConn);
	     }

} // findAll()

Connection dbConn = null;

try {
	        // Get a database connection
	        dbConn = getConnection();

// Perform the work
	        return findMedByPrimaryKey(dbConn, med);

} catch (SQLException e) {

System.out.println(e.getMessage());
	        // Print any other nested exceptions
	        while ((e = e.getNextException()) != null) {
	           System.out.println("   next " + e.getMessage());
	        }

throw e; // Re-throw the SQLException

} finally {
	        closeConnection(dbConn);
	     }
	  } // findById()

Connection dbConn = null;

try {
	        // Get a database connection
	        dbConn = getConnection();

// Perform the work
	        return addMed(dbConn, med);

} catch (SQLException e) {

throw e; // Re-throw the SQLException

} finally {
	        closeConnection(dbConn);
	     }
	  } // add()

Connection dbConn = null;

try {
	        // Get a database connection
	        dbConn = getConnection();

// Perform the work
	        return editMed(dbConn, med);

} catch (SQLException e) {

throw e; // Re-throw the SQLException

} finally {
	        closeConnection(dbConn);
	     }
	  } // edit()

Connection dbConn = null;

try {

// Get a database connection
	        dbConn = getConnection();

// Perform the work
	        return deleteMed(dbConn, med);

} catch (SQLException e) {

throw e; // Re-throw the SQLException

} finally {
	        closeConnection(dbConn);
	     }

} // delete()

// PRIVATE METHODS
	  // ===============

/**
	   *  Helper method for findAll()
	   *
	   *  @param  conn  Connection object to use
	   *
	   *  @return List of employee objects containing details of employees found
	   *
	   *  @throws java.lang.Exception
	   */
	  private Vector findAllMedicines(Connection conn)
	  throws Exception {

PreparedStatement pSt   = null;
	     Vector            list = null;

// Build the SQL statement
	     // Use a string buffer instead of concatenating strings
	     // Expensive operation since strings are immutable objects
	     // They do not change once they are created
	     // Each time a string is concatenated, a new string is created
	     StringBuffer sql = new StringBuffer();
	     sql.append("SELECT * FROM medicines");

// Execute SQL statement
	     try {

pSt = conn.prepareStatement(sql.toString());
	        ResultSet rs = null;
	        rs = pSt.executeQuery();
	        if (rs.next()) {
	           // Create a list and store any employees found
	           list = new Vector();
	           System.out.println("Created list ...");

do  {
	              MedicinesData med = new MedicinesData();
	              med.setMedicineID(rs.getInt("medicineID"));
	              med.setSupplierID(rs.getInt("supplierID"));
	              med.setMedicineName(rs.getString("medicineName"));
	              med.setMedicineDescription(rs.getString("medicineDescription"));
	              med.setUnitPrice(rs.getDouble("unitPrice"));
	              med.setQtyInStock(rs.getInt("qtyInStock"));
	              med.setMinStockLevel(rs.getInt("minStockLevel"));
	              med.setOrderQty(rs.getInt("orderQty"));
	              list.add(med);

} while (rs.next());

} // if

// Return the list of employees found to the calling program
	        return list;

} catch (SQLException e) {

throw e; // Re-throw the SQLException

} finally {

// Close all the PreparedStatements no matter what happened

pSt.close();

}

} // findAllEmp()

/**
	   *  Helper method for findByPrimaryKey()
	   *
	   *  @param  conn  Connection object to use
	   *  @param  empIn Employee object containing primary key of employee to find
	   *
	   *  @return Employee object containing details of employee found
	   *
	   *  @throws java.lang.Exception
	   */
	  private MedicinesData findMedByPrimaryKey(Connection conn, MedicinesData medIn) throws Exception {

PreparedStatement pSt  = null;
	     MedicinesData     med = null;

// Build the SQL statement
	     StringBuffer sql = new StringBuffer();
	     sql.append("SELECT * FROM medicines "); // Leave a space after EMPLOYEE
	                                            // Guess why?
	     sql.append("WHERE medicineID = ?");

// Execute SQL statement
	     try {

pSt = conn.prepareStatement(sql.toString());
	        // Get the ID of the employee to search from
	        // the employee parameter (empIn) object
	        // Set that value in the prepared statement
	        // And execute the SQL query
	        pSt.setInt(1, medIn.getMedicineID());
	        ResultSet rs = null;
	        rs = pSt.executeQuery();

if (rs.next()) {
	           // Create a new employee and store details
	           System.out.println("Found employee ...");
	           med.setMedicineID(rs.getInt("medicineID"));
	           med.setSupplierID(rs.getInt("supplierID"));
	           med.setMedicineName(rs.getString("medicineName"));
	           med.setMedicineDescription(rs.getString("medDescription"));
	           med.setUnitPrice(rs.getDouble("unitPrice"));
	           med.setQtyInStock(rs.getInt("qtyInStock"));
	           med.setMinStockLevel(rs.getInt("minStockLevel"));
	           med.setOrderQty(rs.getInt("orderQty"));
	        } // if

// Return the employee found to the calling program
	        return med;

} catch (SQLException e) {

throw e; // Re-throw the SQLException

} finally {
	        pSt.close();
	     }

} // findEmpByPrimaryKey()

/**
	   *  Helper method for add()
	   *
	   *  Note that the employee ID is autogenerated
	   *  Do not attemp to insert it
	   *
	   *  @param conn  Connection object to use
	   *  @param medIn Employee object containing details of employee to add
	   *
	   *  @return true if sucess, false otherwise
	   *
	   *  @throws java.lang.Exception
	   */
	  private boolean addMed(Connection conn, MedicinesData medIn)throws Exception {

PreparedStatement pSt = null;

// Build the SQL statement
	     StringBuffer sql = new StringBuffer();
	     sql.append("INSERT INTO medicines "); // Leave a space after EMPLOYEE
	                                          // Guess why?
	     sql.append("(medicineID, supplierID, medicineName, medicineDescription, unitPrice, qtyInStock, minStockLevel, orderQty)" ); // Leave a space at the end
	     sql.append("VALUES (?, ?, ?, ?, ?, ?, ?, ?)");

// Execute SQL statement
	     try {
	        pSt = conn.prepareStatement(sql.toString());
	        // Get the firstName, lastName, address1 and address2
	        // of the employee to add from the employee parameter (medIn) object
	        // Set these values in the prepared statement
	        // And execute the SQL query
	        pSt.setInt(1, medIn.getMedicineID());
	        pSt.setInt(2, medIn.getSupplierID());
	        pSt.setString(3, medIn.getMedicineName());
	        pSt.setString(4, medIn.getMedicineDescription());
	        pSt.setDouble(5, medIn.getUnitPrice());
	        pSt.setInt(6, medIn.getQtyInStock());
	        pSt.setInt(7, medIn.getMinStockLevel());
	        pSt.setInt(8, medIn.getOrderQty());

// Note: Since "empID" field is AutoIncrement
	        // We should not add it to the database table
	        // The database will generate it

// executeUpdate() returns a count of rows affected by the SQL statement
	        // If count>0, return true
	        // Otherwise return false
	        int count;
	        return ((count = pSt.executeUpdate()) > 0 ? true : false);

} catch (SQLException e) {

throw e; // Re-throw the SQLException

} finally {
	        pSt.close();
	     }

} // addEmp()

/**
	   *  Helper method for delete()
	   *
	   *  Before deleting an employee, you have to make sure the employee exists
	   *  This is not handled here!
	   *
	   *  @param conn  Connection object to use
	   *  @param medIn Employee object containing ID of employee to delete
	   *
	   *  @return true if sucess, false otherwise
	   *
	   *  @throws java.lang.Exception
	   */
	  private boolean deleteMed(Connection conn, MedicinesData medIn)throws Exception {

PreparedStatement pSt = null;

// Build the SQL statement
	     StringBuffer sql = new StringBuffer();
	     sql.append("DELETE FROM medicines "); // Leave a space after EMPLOYEE
	                                          // Guess why?
	     sql.append("WHERE medicineID=?");

// Execute SQL statement
	     try {
	        pSt = conn.prepareStatement(sql.toString());
	        // Get the ID of the employee to delete from
	        // the employee parameter (medIn) object
	        // Set that value in the prepared statement
	        // And execute the SQL query
	        pSt.setInt(1, medIn.getMedicineID());

} catch (SQLException e) {

throw e; // Re-throw the SQLException

} finally {
	        pSt.close();
	     }

} // deleteEmp()

/**
	   *  Helper method for edit()
	   *
	   *  Before updating an employee, you have to make sure the employee exists
	   *  This is not handled here!
	   *
	   *  @param conn  Connection object to use
	   *  @param medIn Employee object containing updated details
	   *
	   *  @return true if sucess, false otherwise
	   *
	   *  @throws java.lang.Exception
	   */
	  private boolean editMed(Connection conn, MedicinesData medIn)throws Exception {

PreparedStatement pSt = null;

// Build the SQL statement
	     StringBuffer sql = new StringBuffer();
	     sql.append("UPDATE medicines "); // Leave a space after EMPLOYEE
	                                     // Guess why?
	     sql.append("SET medicineID=?, supplierID=?, medicineName=?, medicineDescription=?, unitPrice=?, qtyInStock=?, minStockLevel=?, orderQty=? "); //space
	     sql.append("WHERE empID=?");

// Debug
	     System.out.println("medicineID: " + medIn.getMedicineID());
	     System.out.println("supplierID: "  + medIn.getSupplierID());
	     System.out.println("medicineName: "  + medIn.getMedicineName());
	     System.out.println("medicineDesc: "  + medIn.getMedicineDescription());
	     System.out.println("unitPrice: "  + medIn.getUnitPrice());
	     System.out.println("qtyInStock: "  + medIn.getQtyInStock());
	     System.out.println("minStockLvl: "  + medIn.getMinStockLevel());
	     System.out.println("orderQty: "  + medIn.getOrderQty());
	    // System.out.println("id: "        + medIn.getAccountID());

// Execute SQL statement
	     try {
	        pSt = conn.prepareStatement(sql.toString());

// Get the firstName, lastName, address1 and address2
	        // of the employee to add from the employee parameter (medIn) object
	        // Set these values in the prepared statement
	        // And execute the SQL query
	        // The System.out.println() statements are used for debugging

System.out.println("Setting Medicine ID ...");
	        pSt.setInt(1, medIn.getMedicineID());

System.out.println("Setting Supplier ID ...");
	        pSt.setInt(2, medIn.getSupplierID());

System.out.println("Setting Medicine Name ...");
	        pSt.setString(3, medIn.getMedicineName());

System.out.println("Setting Medicine Desc ...");
	        pSt.setString(4, medIn.getMedicineDescription());

System.out.println("Setting Unit Price ...");
	        pSt.setDouble(5, medIn.getUnitPrice());

System.out.println("Setting Qty In Stock ...");
	        pSt.setInt(6, medIn.getQtyInStock());

System.out.println("Setting Min Stock Lvl ...");
	        pSt.setInt(7, medIn.getMinStockLevel());

System.out.println("Setting Order Qty ...");
	        pSt.setInt(8, medIn.getOrderQty());

System.out.println("Executing update ...");
	        // executeUpdate() returns a count of rows affected by the SQL statement
	        // If count>0, return true
	        // Otherwise return false
	        int count;
	        return ((count = pSt.executeUpdate()) > 0 ? true : false);

} catch (SQLException e) {

throw e; // Re-throw the SQLException

} finally {
	        pSt.close();
	     }

} // editEmp()

/**
	   *  Gets a datasource connection
	   *  Different from getting a databse connection using DriverManager
	   *
	   *  @return Connection object to connect to datasource
	   *
	   *  @throws java.lang.Exception
	   */
	  private Connection getConnection()
	  throws Exception {

String jndiPrefix = "java:comp/env/jdbc/";   // Works with Tomcat datasource
	                                                  // Doesn't work with jBoss datasource
	     //String jndiPrefix = "java:/";              // Works with jBoss datasource
	                                                  // Doesn't work with Tomcat datasource

Context initCtx = null;
	     try {
	        // Obtain the initial JNDI context
	        initCtx = new InitialContext();

// Perform JNDI lookup to obtain resource manager connection factory
	        DataSource ds =
	           (javax.sql.DataSource)
	           initCtx.lookup(jndiPrefix + jndiName);

// Invoke factory to obtain a connection
	        return ds.getConnection();

} catch (SQLException e) {

System.out.println(e.getMessage());
	       // Print any other nested exceptions
	       while ((e = e.getNextException()) != null) {
	          System.out.println("   next " + e.getMessage());
	       }
	       throw e; // Re-throw the SQLException

} catch (NamingException e) {

System.out.println("Cannot find datasource " + jndiPrefix + jndiName);
	       System.out.println(e.getMessage());
	       throw e; // Re-throw the NamingException

} finally {
	        // Don't forget to close the naming context
	        if (initCtx != null) {
	           initCtx.close();
	        }
	     }

} // getConnection()

/**
	   *  Close datasource connection
	   *  Similar to closing database connection
	   *
	   *  @param conn Connection object to close
	   *
	   *  @throws java.lang.Exception
	   */
	  private void closeConnection (Connection conn)
	  throws Exception {
	     conn.close();
	  } // closeConnection()

} // MedicinesDAO

Data:

package edu.rmit.isys2049;

import java.text.NumberFormat;

public class MedicinesData implements java.io.Serializable {
	
	private int medicineID;
	private int supplierID;
	private String medicineName;
	private String medicineDescription;
	private double unitPrice;
	private int qtyInStock;
	private int minStockLevel;
	private int orderQty;
	/**
	 * @return the medicineID
	 */
	public int getMedicineID() {
		return medicineID;
	}
	/**
	 * @param medicineID the medicineID to set
	 */
	public void setMedicineID(int medicineID) {
		this.medicineID = medicineID;
	}
	/**
	 * @return the supplierID
	 */
	public int getSupplierID() {
		return supplierID;
	}
	/**
	 * @param supplierID the supplierID to set
	 */
	public void setSupplierID(int supplierID) {
		this.supplierID = supplierID;
	}
	/**
	 * @return the medicineName
	 */
	public String getMedicineName() {
		return medicineName;
	}
	/**
	 * @param medicineName the medicineName to set
	 */
	public void setMedicineName(String medicineName) {
		this.medicineName = medicineName;
	}
	/**
	 * @return the medicineDescription
	 */
	public String getMedicineDescription() {
		return medicineDescription;
	}
	/**
	 * @param medicineDescription the medicineDescription to set
	 */
	public void setMedicineDescription(String medicineDescription) {
		this.medicineDescription = medicineDescription;
	}
	/**
	 * @return the unitPrice
	 */
	public double getUnitPrice() {
		return unitPrice;
	}
	/**
	 * @param unitPrice the unitPrice to set
	 */
	public void setUnitPrice(double unitPrice) {
		this.unitPrice = unitPrice;
	}
	/**
	 * @return the qtyInStock
	 */
	public int getQtyInStock() {
		return qtyInStock;
	}
	/**
	 * @param qtyInStock the qtyInStock to set
	 */
	public void setQtyInStock(int qtyInStock) {
		this.qtyInStock = qtyInStock;
	}
	/**
	 * @return the minStockLevel
	 */
	public int getMinStockLevel() {
		return minStockLevel;
	}
	/**
	 * @param minStockLevel the minStockLevel to set
	 */
	public void setMinStockLevel(int minStockLevel) {
		this.minStockLevel = minStockLevel;
	}
	/**
	 * @return the orderQty
	 */
	public int getOrderQty() {
		return orderQty;
	}
	/**
	 * @param orderQty the orderQty to set
	 */
	public void setOrderQty(int orderQty) {
		this.orderQty = orderQty;
	}
	
	public String getUnitPriceString(){
		NumberFormat nf = NumberFormat.getCurrencyInstance();
		return nf.format(getUnitPrice());
	}

}

Ankit Garg

Sheriff

Posts: 9708

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Well I think you need to provide one more code and that is of the action which is handling the form of the first page. In the first page you have written the action of your form as dispatcher. You code for listEmp2.jsp is also wrong I think. There you have used an object order in line 48. But I can't find that object declared in the file. Also in line 74 you are using the object item but you have commented that object on line 97.

The solution to your problem is simple. In the dispatcher action you would be adding objects of LineItemsData class to the session. You have not included that file too. But I don't think that file is needed. When you receive a request to add a medicine to the shopping cart, just take the ID of that medicine and get that object from the database. Then add the whole object into the session. So then in the JSP page you'll not have to do this

LineItemsData lItem = (LineItemsData) e.nextElement();
MedicinesData med = accessBean.findByPrimaryKey(lItem.nProductID);

Instead you will be able to do this

MedicinesData med = (MedicinesData) e.nextElement();

Also I would suggest that you should not use scripting in JSP pages...

SCJP 6 | SCWCD 5 | Javaranch SCJP FAQ | SCWCD Links

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

Jia Bin Tang

Greenhorn

Posts: 16

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Ankit Garg wrote:Well I think you need to provide one more code and that is of the action which is handling the form of the first page. In the first page you have written the action of your form as dispatcher. You code for listEmp2.jsp is also wrong I think. There you have used an object order in line 48. But I can't find that object declared in the file. Also in line 74 you are using the object item but you have commented that object on line 97.

Hmms, which first page are you referring to?

If you're referring to the first page, as in the previous page before that, then it's just:

<%@ include file="/setErrorPage.jsf"%>

<HTML>
   <HEAD>
      <TITLE>List Products</TITLE>
   </HEAD>

<BODY>
      
      <%@ include file="/header.html"%>
      
      
      <table >
          <tr >
             
             <td   >
                
                <%@ include file="menu01.html"%>           
             </td>
             <td >
                
                <H2>List Products</H2>
                
                <FORM ACTION="dispatcher" METHOD="POST"> 
                   <table>
                      <tr>
                         <td><INPUT TYPE="HIDDEN" NAME="action" VALUE="listEmp1"></td>
                      </tr>
                   
                      <tr>
                         <td><INPUT TYPE="SUBMIT" VALUE="List Products">
                         </td>
                      </tr>
                      
                   </table>
                </FORM>              
                
             </td>
          </tr>
       </table>
       
       
       <%@ include file="/footer.html"%>
       
    </BODY>
 </HTML>

which I felt is quite redundant to post. I kind of follow the script from JSPCart http://www.neurospeech.com/Products/JspCart.html And it has this:

Again, it looks quite similar to the one that I'm doing.

But because I use hidden values:

So it seems like the vector can only load quality and the Medicine ID into the next page.
We were suggested to actually use setAttributes() to bring the data over. How do I go about doing it?

Many thanks.

Ankit Garg

Sheriff

Posts: 9708

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am talking about this thing

<FORM ACTION="dispatcher" METHOD="POST">

There must be a servlet mapped to dispatcher URL, just post the code of that. If you can't, then it's simple to do if you understand my instructions. Your page will give you the quantity and ID of the medicine. You can take that to get the medicine that the user chose and add it to the session as an attribute. To do this I would recommend that you build a List and add it as an attribute to the session. Whenever a new item is added to the cart, just take out the list from the session and update it. I think you'll understand what I am trying to say...

SCJP 6 | SCWCD 5 | Javaranch SCJP FAQ | SCWCD Links

Jia Bin Tang

Greenhorn

Posts: 16

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Ankit Garg wrote:I am talking about this thing

<FORM ACTION="dispatcher" METHOD="POST">

There must be a servlet mapped to dispatcher URL, just post the code of that. If you can't, then it's simple to do if you understand my instructions. Your page will give you the quantity and ID of the medicine. You can take that to get the medicine that the user chose and add it to the session as an attribute. To do this I would recommend that you build a List and add it as an attribute to the session. Whenever a new item is added to the cart, just take out the list from the session and update it. I think you'll understand what I am trying to say...

I see. I'm not sure if this dispatcher servlet affects anything because it's a "universal" servlet that must be used to forward any JSP page.
It's a "rule" from school, we cannot post directly to a JSP page.

package edu.rmit.isys2049;

// Imports
// =======
import javax.servlet.*;
import javax.servlet.http.*;

import edu.rmit.isys2049.exceptions.*;

/**
 * A servlet which handles all the requests and dispatches
 * the request to other resources for processing depending
 * on the value of the "action" parameter in the request.
 *
 * @version   Version 1
 *
 * @author    France Cheong
 */
public class DispatcherServlet
extends HttpServlet {

// Attributes
  // ==========

private java.util.HashMap map_;

// Public methods
  // ==============

/**
   * Called by the Web container during Initialization stage
   *
   * @param config  ServletConfig object created by the container for this application
   *
   * @throws javax.servlet.ServletException
   *
   */
  public void init (ServletConfig config)
  throws ServletException {

// Call super to ensure config is initialized
     super.init(config);

// Get context (application) parameters specified in web.xml
     // And store them as key/value pairs in a hashmap
     // Will be used in doPost to forward to the right resource for processing
     map_                       = new java.util.HashMap();
     ServletContext context     = getServletContext();
     java.util.Enumeration enumerator = context.getInitParameterNames();
     while (enumerator.hasMoreElements()) {
        String paramName  = (String) enumerator.nextElement();
          // Notice the cast to String because Enumeration elements
          // are of type "Object"
        if (paramName != null) {
           // This check is necessary, otherwise won't compile
           // because if paramValue is null,
           // getInitParameter() will crash
           // And if paramName is null, don't put anything
           // in the hashmap
           String paramValue =  context.getInitParameter(paramName);
           if (paramValue != null) {
              map_.put(paramName, paramValue);
           }
        }
     }

} // init()

/**
   * Called by a "Post" Http request
   *
   * @param request   request object
   * @param response  response object
   *
   * @throws edu.rmit.isys2049.exceptions.UnknownResourceException
   * @throws java.io.IOException
   *
   */
  public void doPost(HttpServletRequest request,
                     HttpServletResponse response)
  throws UnknownResourceException, java.io.IOException {

// Get the value of any "action" parameter posted in the request
     // And lookup the corresponding resource name
     String action   = request.getParameter("action");
     if (action == null) {
        action = "";
     }

// Debug
     System.out.println("action: " + action);
     String resource = (String) map_.get(action);
        // Notice the cast to String because HashMap elements
        // are of type "Object"

// Debug
     System.out.println("resource: " + resource);

if (resource == null) {
        throw new UnknownResourceException("Unknown action");
        /*
           We defined this Java class in package (folder) "exception"
           Since it is in a different package, we need to import it
           at the beginning of this file

UnknownResourceException is a sub-class of ServletException
           When this exception is thrown, it will be handled by the
           Web container.
           If an error page is defined for this exception,
           that page will be displayed

Notice in the header of doPost() above,
           UnknownResourceException is thrown
           doGet() also need to throw this exception since,
           it calls doPost()

*/
     }

// If we reach this point, this means that "action" has a valid value
     // And this value has been sucessfully converted to a resource name

// Forward to another resource for further processing

/*
     // Resource specified as a relative URL
     RequestDispatcher rd =
        request.getRequestDispatcher("URL path to target resource");

// Resource specified as an absolute URL (starting with a slash)
     RequestDispatcher rd =
        getServletContext().getRequestDispatcher("URL path to target resource");
     // Resource specified as a "named" resource
     RequestDispatcher rd =
        getServletContext().getNamedDispatcher("<servlet-name>");
     */

/*
     // Resource specified as an absolute URL (starting with a slash)
     RequestDispatcher rd =
        getServletContext().getRequestDispatcher(resource);
     */

// Resource specified as a relative URL
     RequestDispatcher rd =
        request.getRequestDispatcher(resource);

// Forward resource
     try {
        rd.forward(request, response);
     } catch (ServletException e) {
        Throwable exception = (Throwable)
           request.getAttribute("javax.servlet.error.exception");
        throw new UnknownResourceException("Resource not found", exception);
     }
  
  } // doPost()
  public void doGet(HttpServletRequest request,
                    HttpServletResponse response)
  throws UnknownResourceException, java.io.IOException  {

doPost(request, response);

} // doGet()

} // DispatcherServlet

Seetharaman Venkatasamy

Ranch Hand

Posts: 5575

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Jia Bin Tang wrote: I'm not using MVC 2 Model

There is no such thing called MVC2 . Model2 design is nothing but MVC

Ankit Garg

Sheriff

Posts: 9708

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Ok now I got your code. But still I don't understand what you basically want. Since there is no servlet between your JSPs (there is one but it is just a dummy), so there is no way for you to find the total price. You can get the per unit price though in your jsp like this

And you can also calculate the total price based on quantity and unit price. The code might be complicated to understand at first

the javascript method would look like this

I have not tied the code so it might fail...

SCJP 6 | SCWCD 5 | Javaranch SCJP FAQ | SCWCD Links

Jia Bin Tang

Greenhorn

Posts: 16

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

seetharaman venkatasamy wrote:

Jia Bin Tang wrote: I'm not using MVC 2 Model

There is no such thing called MVC2 . Model2 design is nothing but MVC

Haha I see, I always thought it's something got to do with struts framework though.
Thanks for correcting.

Jia Bin Tang

Greenhorn

Posts: 16

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Mr Ankit Garg,
I'd like to do something like that on my cart page:

I've tried using this

but it doesn't seem to work, it gives an error message (resource not found) . I always end up getting the medicine ID and the quantity.
Anyway my school project suggests this:

• Information used by several HTML/JSP pages (i.e. the shopping cart) should be stored in the session object. It should not be stored in hidden fields and posted from page to page.

What is the thing that I need to do before using this:

Thanks.

Ankit Garg

Sheriff

Posts: 9708

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Jia I think you should modify your design. There must be no scripting in JSPs. You must create a servlet to handle all the business logic. The JSPs must call the servlets to handle the request processing. The servlet would then handle the business logic. I am not talking about the type of controller servlet that you are using. I am talking about a new servlet to handle business logic. Just google with the tern shopping cart java and you'll get a ton of helpful tutorial on the internet with the right way of creating a shopping cart...

SCJP 6 | SCWCD 5 | Javaranch SCJP FAQ | SCWCD Links

Jia Bin Tang

Greenhorn

Posts: 16

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Ankit Garg wrote: There must be no scripting in JSPs.

Hi, sorry for reviving old thread again, but I don't quite understand this part.

I saw some books that even writes the business logics on the JSP page itself (though I don't prefer to do that).

Bear Bibeault

Sheriff

Posts: 67750

173

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Jia Bin Tang wrote:

Ankit Garg wrote: There must be no scripting in JSPs.

Hi, sorry for reviving old thread again, but I don't quite understand this part.

Modern best practices dictate that JSPs should only be used as units of view. Any logic should be sequestered Java classes delegated by controllers. If you have not read this article yet, it may be helpful.

I saw some books that even writes the business logics on the JSP page itself (though I don't prefer to do that).

These books should be burned!

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

No. No. No. No. Changed my mind. Wanna come down. To see this tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser