Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form class="form-horizontal" method="post" action="InsertOrderServlet">
- <center>
- <table border="10" cellpadding="20" cellspacing="20">
- <thead>
- <tr>
- <th colspan="2"><h2 style="line-height: 3;" >Order Food</h2></th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td><br><br>Food</br></br></td>
- <td>
- <br><br>
- <div class="col-lg-9">
- <select class="form-control" name="menuName">
- <c:forEach items="${sessionScope.menus}" var="currentmenu" varStatus="loop">
- <option><c:out value="${currentmenu.foodName}" /></option>
- </c:forEach>
- </select>
- </div>
- </td>
- </tr>
- <tr>
- <td>Quantity</td>
- <td><input type="text" name="quantity" required/></td>
- </tr>
- <tr style="line-height: 10;" >
- <td> <button class="btn btn-primary" type="reset" >Cancel</button></td>
- <td > <button type="submit" class="btn bt primary">Submit</button></td>
- </td>
- </tr>
- </tbody>
- </table>
- </center>
- </form>
- //select all from menu
- try {
- ResultSet rs = jdbcUtility.getPSSelectMenu().executeQuery();
- while (rs.next()) {
- menu = new Menu();
- menu.setId(rs.getInt("menuid"));
- menu.setfoodName(rs.getString("foodName"));
- menu.setImage(rs.getString("image"));
- menu.setPrice(rs.getDouble("price"));
- //put into arraylist
- menus.add(menu);
- }
- }
- catch (SQLException ex)
- {
- }
- //put into sessions
- session.setAttribute("menus", menus);
- String sqlValidateLogin = "Select username,password from customer where username=? and password=?";
- psInsertLogin = con.prepareStatement(sqlValidateLogin);
- String sqlInsertOrder = "INSERT INTO orderfood(menuName, quantity) " + "VALUES(?, ?)";
- psInsertOrder = con.prepareStatement(sqlInsertOrder);
- String sqlSelectAllMenu ="SELECT * FROM menu";
- psSelectAllMenu = con.prepareStatement(sqlSelectAllMenu);
- String sqlSelectAllOrder ="SELECT * FROM orderfood";
- psSelectAllOrder = con.prepareStatement(sqlSelectAllOrder);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement