コード例 #1
0
  /**
   * insert
   *
   * @param order
   * @return
   */
  @Override
  public int insert(Order order) {

    int orderId = order.getOrderId();
    int userId = order.getUserId();
    int ready = order.getReady();
    LinkedList<Integer> dishIdList = order.getDishIDList();

    Connection connection = MyConnection.getInstance().getConnection();

    try {

      PreparedStatement preparedStatement =
          connection.prepareStatement(
              "INSERT INTO order_table (orderId, userId, ready, summ) " + "VALUES (?, ?, 0, 0)");
      preparedStatement.setInt(1, orderId);

      preparedStatement.setInt(2, userId);
      preparedStatement.execute();

      PreparedStatement preparedStatement2 = connection.prepareCall("select last_insert_id();");
      ResultSet resultSet2 = preparedStatement2.executeQuery();
      if (resultSet2.next()) {
        orderId = resultSet2.getInt(MYSQL_LAST_INSERT_ID.toString());
      }

      connection.setAutoCommit(false);
      for (int i = 0; i < dishIdList.size(); i++) {
        PreparedStatement preparedStatement1 =
            connection.prepareStatement(
                "INSERT INTO order_content (orderId, dishId) " + "VALUES (?, ?)");
        preparedStatement1.setInt(1, orderId);
        preparedStatement1.setInt(2, dishIdList.get(i));
        preparedStatement1.execute();
      }

      connection.commit();
      connection.setAutoCommit(true);

    } catch (SQLException | NullPointerException ex) {
      Logger.getLogger(MySQLOrderDAO.class.getName()).error(ex);
    } finally {
      try {
        if (connection != null) {
          connection.close();
        }
      } catch (SQLException ex) {
        Logger.getLogger(MySQLOrderDAO.class.getName()).error(ex);
      }
    }

    return orderId;
  }