<% int iError = 0; String iErrorV = ""; %> <%try{%> <%@ page import="sitoca.Login, sitoca.ProductList, java.sql.*,java.text.*,java.util.*,java.beans.*" %> <% String openWindow1 = ""; String productCategory = ""; String SelectionNo = "0"; String PreviousSelectionNo = ""; String NextSelectionNo = ""; String ChairType = ""; //String strError = ""; Vector oMainProductList = null; if (request.getParameter("productCategory") == null) { %> <% } else { session.removeAttribute("sessionCategory"); session.setAttribute("sessionCategory", request.getParameter("productCategory")); productCategory = (String)request.getParameter("productCategory"); } if (ProductList.getiPoolStartFlag() == 0) { ProductList.StartProductPool(); } iError = 1; //loop through each cart item display the item number, the item name, an editable count field and a price per item field int iQuantityCount, count,iNoOfProductCount; iQuantityCount = count = iNoOfProductCount = 0; Vector myMainProductVector = new Vector(); Vector myOptionalProductVector = new Vector(); Vector myAccessoriesProductVector = new Vector(); String my= "Sitoca645987"; String root = "sitoca3"; /*String my= ""; String root = "root";*/ int iUpdate = 0; String strError = ""; PreparedStatement pstmt = null; ResultSet resultSet = null; ResultSetMetaData rsmd = null; Connection con = null; DatabaseMetaData dmd = null; if(request.getParameter("SelectionNo") == null){SelectionNo = "0";}else{SelectionNo = request.getParameter("SelectionNo");} if(request.getParameter("PreviousSelectionNo") == null){PreviousSelectionNo = "0";}else{PreviousSelectionNo = request.getParameter("PreviousSelectionNo");} if(request.getParameter("NextSelectionNo") == null){NextSelectionNo = "0";}else{NextSelectionNo = request.getParameter("NextSelectionNo");} iError = 2; System.out.println("productCategory = " + productCategory); String DRIVER = "com.mysql.jdbc.Driver"; //org.gjt.mm.mysql.Driver is old, and com.mysql.jdbc.Driver is new String DB_URL = "jdbc:mysql://localhost/sitoca3_sitoca"; String strResult = "not set"; System.out.println("Getting Main Products"); try { Class.forName(DRIVER).newInstance(); try { con = DriverManager.getConnection(DB_URL, root, my); dmd = con.getMetaData(); pstmt = con.prepareStatement("SELECT * FROM product where productCategory like '%" + productCategory + "%' and type='M' order by productName ASC"); resultSet = pstmt.executeQuery(); rsmd = resultSet.getMetaData(); while(resultSet.next()) //while product list hasnt end go to next product { Vector currentRow = new Vector(); // declare new vector to store current row of products for(int i = 1; i <=rsmd.getColumnCount(); i++) // loop thru the columns like productName and productNo { currentRow.addElement(resultSet.getString(i)); // add each column to get the row of data of a product } myMainProductVector.addElement(currentRow); } while(!(con.isClosed())) { if(!(con == null)) { con.close(); } } } catch (Exception sqle) { strResult = "

Error getting connection, cause: " + sqle + "

"; } } catch (Exception e) { strResult = "

Error instantiating JDBC class, cause:

" + e + ""; } if (con!=null) strResult ="OK"; System.out.println("Getting Optional Products"); try { Class.forName(DRIVER).newInstance(); try { con = DriverManager.getConnection(DB_URL, "root", ""); dmd = con.getMetaData(); pstmt = con.prepareStatement("SELECT * FROM product where productCategory='A' ORDER BY productNo ASC"); resultSet = pstmt.executeQuery(); rsmd = resultSet.getMetaData(); while(!(con.isClosed())) { if(!(con == null)) { con.close(); } } } catch (Exception sqle) { strResult = "

Error getting connection, cause: " + sqle + "

"; } } catch (Exception e) { strResult = "

Error instantiating JDBC class, cause:

" + e + ""; } if (con!=null) strResult ="OK"; if(strResult.equals("ok")) { while(resultSet.next()) //while product list hasnt end go to next product { Vector currentRow = new Vector(); // declare new vector to store current row of products for(int i = 1; i <=rsmd.getColumnCount(); i++) // loop thru the columns like productName and productNo { currentRow.addElement(resultSet.getString(i)); // add each column to get the row of data of a product } myOptionalProductVector.addElement(currentRow); } } System.out.println("Getting Accessories Products"); iError = 3; try { Class.forName(DRIVER).newInstance(); try { con = DriverManager.getConnection(DB_URL, "root", ""); dmd = con.getMetaData(); pstmt = con.prepareStatement("SELECT * FROM product where productCategory like '%" + productCategory + "%' and type='O';"); resultSet = pstmt.executeQuery(); rsmd = resultSet.getMetaData(); while(!(con.isClosed())) { if(!(con == null)) { con.close(); } } } catch (Exception sqle) { strResult = "

Error getting connection, cause: " + sqle + "

"; } } catch (Exception e) { strResult = "

Error instantiating JDBC class, cause:

" + e + ""; } if (con!=null) strResult ="OK"; if(strResult.equals("ok")) { while(resultSet.next()) //while product list hasnt end go to next product { Vector currentRow = new Vector(); // declare new vector to store current row of products for(int i = 1; i <=rsmd.getColumnCount(); i++) // loop thru the columns like productName and productNo { currentRow.addElement(resultSet.getString(i)); // add each column to get the row of data of a product } myAccessoriesProductVector.addElement(currentRow); } } //myAccessoriesProductVector = ProductList.getAccessoriesList(productCategory); // Get list of Accessories for the products selected System.out.println("Gotten All Products"); System.out.println("Main Size : " + myMainProductVector.size()); System.out.println("Optional Size : " + myOptionalProductVector.size()); System.out.println("Accessories Size : " + myAccessoriesProductVector.size()); iError = 4; // out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); iErrorV = myMainProductVector.size() + ""; //iErrorV = ((Vector)sitoca.ProductList.getProductList()).size() + ""; iError = 5; // ########################## Start of Codings for Main Products Listing ################################### String oCurrentNo,oCurrentName,oCurrentCost,oCurrentModel,oCurrentCategory,oCurrentQuantity,oCurrentDimension,oCurrentType, oCurrentColour, oCurrentDescription, oNextName; oCurrentNo=oCurrentName=oCurrentCost=oCurrentModel=oCurrentCategory=oCurrentQuantity=oCurrentDimension=oCurrentType=oCurrentColour=oCurrentDescription=oNextName=""; int iCurrentSelectionNo = Integer.parseInt(SelectionNo); iError = 6; Vector v = (Vector)myMainProductVector.elementAt(iCurrentSelectionNo); iError = 61; oCurrentNo = (String)v.elementAt(0); iError = 62; oCurrentName = (String)v.elementAt(1); //oCurrentCost = (String)v.elementAt(2); oCurrentModel = (String)v.elementAt(3); oCurrentCategory = (String)v.elementAt(4); oCurrentDimension = (String)v.elementAt(5); oCurrentType = (String)v.elementAt(6); oCurrentColour = (String)v.elementAt(7); iError = 7; if(!(v.elementAt(8) == null)){oCurrentDescription = (String)v.elementAt(8);} int iNextSelectionNo = iCurrentSelectionNo; iError = 8; while(((((String)((Vector)myMainProductVector.elementAt(iNextSelectionNo)).elementAt(1)).equals(oCurrentName))) && (iNextSelectionNo < (myMainProductVector.size()-1))) { if((((String)((Vector)myMainProductVector.elementAt(iNextSelectionNo)).elementAt(1)).equals(oCurrentName))) { oNextName = (String)((Vector)myMainProductVector.elementAt(iNextSelectionNo)).elementAt(1); } iNextSelectionNo++; } iError = 9; out.write(""); // *********************Start of Table for Product Info ******************** out.write(""); // *********************End of Table for Product Info ******************** out.write(""); // Spacing between Left and Right Column // *********************Start of Table for Configurations******************** out.write(""); // *********************End of Table for Configurations******************** out.write(""); String openWindow_Configuration1 = ""; out.write(""); out.write(""); out.write(""); if (oCurrentCategory.equals("U")) { out.write(""); out.write(""); out.write(""); } else if(productCategory.equals("M")) { out.write(""); out.write(""); out.write(""); } else if(productCategory.equals("C")) { out.write(""); out.write(""); out.write(""); } else if(productCategory.equals("P")) { out.write(""); out.write(""); out.write(""); } else if(productCategory.equals("N")) { out.write(""); out.write(""); out.write(""); } else if(productCategory.equals("O")) { out.write(""); out.write(""); out.write(""); } else if(productCategory.equals("D")) { out.write(""); out.write(""); out.write(""); } else if(productCategory.equals("T")) { out.write(""); out.write(""); out.write(""); } /*out.write(""); out.write(""); out.write(""); out.write(""); */ out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
   
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"+ oCurrentName.substring(0, (oCurrentName.length() / 2))+""+ oCurrentName.substring((oCurrentName.length() / 2), oCurrentName.length())+"
   
 SITOCA's "); out.write(""); if(oCurrentDescription.length() == 0) { //out.write("Series " + oCurrentModel + " has no information at the moment, for more enquires please contact our sales team at sales@sitoca.com. We look forward to assisting you."); out.write(""); } else { out.write(oCurrentDescription); } out.write(" 
   
   
"); out.write("
 "); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); if(myMainProductVector.size() > 0) { out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); } // ########################## End of Codings for Item Dimension ############################ out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
Customise Your " + oCurrentName + "
 
Currently We Only Customised For Projects Purposed. Please Contact Us To Check Our Available Stocks.
 
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
Dimensions
"); out.write(""); String oValue, oHeight, oBreadth, oWidth; oValue = oHeight = oBreadth = oWidth = ""; int iHeightCount, iBreadthCount; iHeightCount = iBreadthCount = 0; //for (int x =0 ; x <= iNextSelectionNo;++x) for (int x =0 ; x "); /*out.write("");*/ out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); } out.write("
[Series " + ((String)((Vector)myMainProductVector.elementAt(x)).elementAt(3)) + "] "); out.write("" + ((String)((Vector)myMainProductVector.elementAt(x)).elementAt(5)) + ""); out.write("
 Colour:"); out.write(""); //out.write("     Price: S$" + ((String)((Vector)myMainProductVector.elementAt(x)).elementAt(2)) + ""); out.write("
"); out.write("
"); out.write("
"); out.write(""); out.write(""); //out.write(""); //out.write(""); out.write(""); out.write("
Enter Quantity to Order
And Click on Order It
"); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); //out.write(""); //out.write(""); //out.write(""); out.write("

"); out.write(openWindow1 + "page_colourcodes.jsp" + openWindow2 + "Please click here for colour codes legend.
"); out.write("


"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write("  "); out.write(""); out.write("  "); out.write(""); out.write("  "); out.write("
 
"); out.write("  "); out.write(""); out.write("  "); out.write(""); out.write("  "); out.write("
"); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write("
"); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write("
"); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write("
"); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write("
"); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write("
"); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write("
"); out.write("
"); out.write("" + openWindow_Configuration1 + "page_configuration.jsp?productCategory=" + productCategory + openWindow_Configuration2 + "Please click here for more product configuration.
"); // ########################## Start of Codings for Accessories############################## out.write(""); if (myAccessoriesProductVector.size() > 0) { out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); } out.write("
 
Select the Accessories
 
The followings are accessory items that you may add to your workstation. Please check the box on the left of the picture if you would like to include it and select the dimension on the
right.
 
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); v.removeAllElements(); for (int z =0 ; z < myAccessoriesProductVector.size();++z) { v = (Vector)myAccessoriesProductVector.elementAt(z); String oProductAccessoriesNo = (String)v.elementAt(0); String oProductAccessoriesName = (String)v.elementAt(1); String oProductAccessoriesCost = (String)v.elementAt(2); String oProductAccessoriesModel = (String)v.elementAt(3); String oProductAccessoriesCategory = (String)v.elementAt(4); String oProductAccessoriesDimension = (String)v.elementAt(5); String oProductAccessoriesType = (String)v.elementAt(6); String oProductAccessoriesColour = (String)v.elementAt(7); String oProductAccessoriesDescription = (String)v.elementAt(8); String oNextAccName = ""; int iNextAccSelectionNo = z; out.write(""); out.write(""); out.write(""); out.write(""); //out.write(""); out.write(""); out.write(""); out.write(""); } out.write("
Accessory Items
" + oProductAccessoriesName + "
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); //out.write(""); out.write(""); out.write("
Series " + oProductAccessoriesModel + "
"); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); //while(((((String)((Vector)myAccessoriesProductVector.elementAt(iNextAccSelectionNo)).elementAt(5)).equals(oProductAccessoriesDimension))) && ((((String)((Vector)myAccessoriesProductVector.elementAt(iNextAccSelectionNo)).elementAt(1)).equals(oProductAccessoriesName))) && (iNextAccSelectionNo < (myAccessoriesProductVector.size()))) //{ /*String strAccDimension = ""; v = (Vector)myAccessoriesProductVector.elementAt(iNextAccSelectionNo); oProductAccessoriesNo = (String)v.elementAt(0); oProductAccessoriesName = (String)v.elementAt(1); oProductAccessoriesCost = (String)v.elementAt(2); oProductAccessoriesModel = (String)v.elementAt(3); oProductAccessoriesCategory = (String)v.elementAt(4); oProductAccessoriesDimension = (String)v.elementAt(5); oProductAccessoriesType = (String)v.elementAt(6); oProductAccessoriesColour = (String)v.elementAt(7); oProductAccessoriesDescription = (String)v.elementAt(8); if(!(v.elementAt(5) == null)) { if(((String)v.elementAt(5)).length() > 0){strAccDimension = ((String)v.elementAt(5));} }*/ out.write(""); if((z%2)==0) { out.write(""); out.write(""); /* if(!((iNextAccSelectionNo + 1) == myAccessoriesProductVector.size())) { iNextAccSelectionNo++; if((((String)((Vector)myAccessoriesProductVector.elementAt(iNextAccSelectionNo)).elementAt(1)).equals(oProductAccessoriesName))) { oNextAccName = (String)((Vector)myAccessoriesProductVector.elementAt(iNextAccSelectionNo)).elementAt(1); z = iNextAccSelectionNo; } } else { oProductAccessoriesName = ""; }*/ //} /*if(iNextAccSelectionNo > z) { z = iNextAccSelectionNo - 1; }*/ out.write("
Dimensions
"); } else { out.write(""); } out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); //out.write(""); out.write(""); out.write("
"); //out.write(""); out.write(""); out.write("" + oProductAccessoriesDimension + "
 Qty:"); out.write(""); out.write("   Price : S$" + oProductAccessoriesCost + "
 Colour:"); out.write(""); out.write(""); out.write("
"); out.write("
"); out.write("
"); out.write("
"); out.write("
"); out.write("
 
"); // ########################## End of Codings for Accessories############################## out.write("
 "); // ***************************** Start of Table for Optional Items ************************** if (myOptionalProductVector.size() > 0) { out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
 
Select the Optional Items
 
The followings are optional items that you may add to your workstation. Please check the box on the left of the picture if you would like to include it and select the dimension on the right.
 
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); Vector vTempOptional = new Vector(); for (int z =0 ; z < myOptionalProductVector.size();++z) { vTempOptional = (Vector)myOptionalProductVector.elementAt(z); String oProductOptionalNo = (String)vTempOptional.elementAt(0); String oProductOptionalName = (String)vTempOptional.elementAt(1); String oProductOptionalCost = (String)vTempOptional.elementAt(2); String oProductOptionalModel = (String)vTempOptional.elementAt(3); String oProductOptionalCategory = (String)vTempOptional.elementAt(4); String oProductOptionalDimension = (String)vTempOptional.elementAt(5); String oProductOptionalType = (String)vTempOptional.elementAt(6); String oProductOptionalColour = (String)vTempOptional.elementAt(7); String oProductOptionalDescription = (String)vTempOptional.elementAt(8); out.write(""); out.write(""); out.write(""); out.write(""); //out.write(""); out.write(""); out.write(""); out.write(""); } out.write("
Optional Items
" + oProductOptionalName + "
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); //out.write(""); out.write(""); out.write("
Series " + oProductOptionalModel + "
"); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); if((z%2)==0) { out.write(""); out.write(""); out.write("
Dimensions
"); } else { out.write(""); } out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); out.write("
"); //out.write(""); //out.write(""); out.write(""); out.write("" + oProductOptionalDimension + "
 Qty:"); out.write(""); out.write(""); out.write("Price: S$" + oProductOptionalCost + ""); out.write("
 Colour:"); out.write(""); out.write("
"); out.write("
"); out.write("
"); out.write("
"); out.write("
"); out.write("
 
"); } // ########################## End of Table for Optional Items############################## out.write("
"); out.write("
"); //}// Close If Product is Not Chair %> <%}catch(Exception e){System.out.println("ShoppingCart Error " + iError+ " : " + e);%><%}%>