Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <c:if test="${order.status=='PROCESS'}">
- <center>
- <input type="submit" value="Подтвердить выполнение">
- <input type="hidden" name="command" value="confirm_flight_driver">
- <input type="hidden" name="id" value="${order.id_order}">
- </center>
- </c:if>
- --------------------------------------------------
- DBManager manager = DBManager.getInstance();
- String forward = Path.PAGE_MY_FLIGHTS_OPEN_PROCESS_DRIVER;
- String id = request.getParameter("id");
- if (!Util.isNumber(id))
- throw new AppException(Message.WRONG_FORMAT_OF_DATE.info());
- manager.changeOrderStatus(Status.CLOSED.ordinal(), Integer.parseInt(id));
- return forward;
- --------------------------------------------------------------------------------
- public boolean changeOrderStatus(int statusId, int id) {
- Connection con = null;
- PreparedStatement pstmt = null;
- ResultSet rs = null;
- try {
- con = getConnection();
- pstmt = con.prepareStatement(CHANGE_ORDER_STATUS_WHERE_ID);
- pstmt.setInt(1, statusId);
- pstmt.setInt(2, id);
- System.out.println(pstmt);
- int update = pstmt.executeUpdate();
- con.commit();
- if (update <= 0)
- return false;
- } catch (SQLException ex) {
- ex.printStackTrace();
- rollback(con);
- return false;
- } finally {
- close(con, pstmt, rs);
- }
- return true;
- }
- 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