Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2016
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.64 KB | None | 0 0
  1. <form class="form-horizontal" method="post" action="InsertOrderServlet">
  2. <center>
  3. <table border="10" cellpadding="20" cellspacing="20">
  4. <thead>
  5. <tr>
  6. <th colspan="2"><h2 style="line-height: 3;" >Order Food</h2></th>
  7. </tr>
  8. </thead>
  9. <tbody>
  10. <tr>
  11. <td><br><br>Food</br></br></td>
  12. <td>
  13. <br><br>
  14. <div class="col-lg-9">
  15. <select class="form-control" name="menuName">
  16. <c:forEach items="${sessionScope.menus}" var="currentmenu" varStatus="loop">
  17. <option><c:out value="${currentmenu.foodName}" /></option>
  18. </c:forEach>
  19. </select>
  20. </div>
  21. </td>
  22. </tr>
  23. <tr>
  24. <td>Quantity</td>
  25. <td><input type="text" name="quantity" required/></td>
  26. </tr>
  27. <tr style="line-height: 10;" >
  28.  
  29. <td> <button class="btn btn-primary" type="reset" >Cancel</button></td>
  30. <td > <button type="submit" class="btn bt primary">Submit</button></td>
  31.  
  32. </td>
  33. </tr>
  34.  
  35. </tbody>
  36.  
  37. </table>
  38. </center>
  39. </form>
  40.  
  41. //select all from menu
  42. try {
  43. ResultSet rs = jdbcUtility.getPSSelectMenu().executeQuery();
  44.  
  45. while (rs.next()) {
  46.  
  47. menu = new Menu();
  48. menu.setId(rs.getInt("menuid"));
  49. menu.setfoodName(rs.getString("foodName"));
  50. menu.setImage(rs.getString("image"));
  51. menu.setPrice(rs.getDouble("price"));
  52.  
  53. //put into arraylist
  54. menus.add(menu);
  55. }
  56. }
  57. catch (SQLException ex)
  58. {
  59. }
  60.  
  61. //put into sessions
  62. session.setAttribute("menus", menus);
  63.  
  64. String sqlValidateLogin = "Select username,password from customer where username=? and password=?";
  65. psInsertLogin = con.prepareStatement(sqlValidateLogin);
  66.  
  67. String sqlInsertOrder = "INSERT INTO orderfood(menuName, quantity) " + "VALUES(?, ?)";
  68. psInsertOrder = con.prepareStatement(sqlInsertOrder);
  69.  
  70. String sqlSelectAllMenu ="SELECT * FROM menu";
  71. psSelectAllMenu = con.prepareStatement(sqlSelectAllMenu);
  72.  
  73. String sqlSelectAllOrder ="SELECT * FROM orderfood";
  74. psSelectAllOrder = con.prepareStatement(sqlSelectAllOrder);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement