Advertisement
Guest User

Untitled

a guest
Jun 21st, 2018
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.87 KB | None | 0 0
  1. <c:if test="${order.status=='PROCESS'}">
  2. <center>
  3. <input type="submit" value="Подтвердить выполнение">
  4. <input type="hidden" name="command" value="confirm_flight_driver">
  5. <input type="hidden" name="id" value="${order.id_order}">
  6. </center>
  7. </c:if>
  8.  
  9. --------------------------------------------------
  10. DBManager manager = DBManager.getInstance();
  11. String forward = Path.PAGE_MY_FLIGHTS_OPEN_PROCESS_DRIVER;
  12. String id = request.getParameter("id");
  13. if (!Util.isNumber(id))
  14. throw new AppException(Message.WRONG_FORMAT_OF_DATE.info());
  15. manager.changeOrderStatus(Status.CLOSED.ordinal(), Integer.parseInt(id));
  16. return forward;
  17. --------------------------------------------------------------------------------
  18. public boolean changeOrderStatus(int statusId, int id) {
  19. Connection con = null;
  20. PreparedStatement pstmt = null;
  21. ResultSet rs = null;
  22. try {
  23. con = getConnection();
  24. pstmt = con.prepareStatement(CHANGE_ORDER_STATUS_WHERE_ID);
  25. pstmt.setInt(1, statusId);
  26. pstmt.setInt(2, id);
  27. System.out.println(pstmt);
  28. int update = pstmt.executeUpdate();
  29. con.commit();
  30. if (update <= 0)
  31. return false;
  32. } catch (SQLException ex) {
  33. ex.printStackTrace();
  34. rollback(con);
  35. return false;
  36. } finally {
  37. close(con, pstmt, rs);
  38. }
  39. return true;
  40. }
  41.  
  42. private static final String CHANGE_ORDER_STATUS_WHERE_ID = "UPDATE orders SET id_status=? WHERE id_order=?";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement