Exemple #1
0
  public static Event getEvent(int eventId) {
    // SELECT * FROM Event WHERE eventId=eventId

    Connection con = null;
    Event event = null;

    try {
      con = DriverManager.getConnection("jdbc:mysql://localhost:8888/poly5", "root", "");

      String sql = "SELECT * FROM event WHERE eventId=?;";

      PreparedStatement preparedStatement = con.prepareStatement(sql);
      preparedStatement.setInt(1, eventId);
      ResultSet result = preparedStatement.executeQuery();

      while (result.next()) {
        event = new Event();
        event.cols = result.getInt("cols");
        event.eventId = result.getInt("eventId");
        event.eventName = result.getString("eventName");
        event.rows = result.getInt("rows");
        break; // only returns the first match
      }

    } catch (SQLException ex) {
      ex.printStackTrace();

    } finally {
      if (con != null) {
        try {
          con.close();
        } catch (SQLException e) {
          // ignore
        }
      }
    }

    return event;
  }
Exemple #2
0
  public static ArrayList<Event> getAllEvents() {
    // SELECT * FROM Event

    Connection con = null;
    ArrayList<Event> events = new ArrayList<Event>();

    try {
      con = DriverManager.getConnection("jdbc:mysql://localhost:8888/poly5", "root", "");

      String sql = "SELECT * FROM event;";

      PreparedStatement preparedStatement = con.prepareStatement(sql);
      ResultSet result = preparedStatement.executeQuery();

      while (result.next()) {
        Event event = new Event();
        event.cols = result.getInt("cols");
        event.eventId = result.getInt("eventId");
        event.eventName = result.getString("eventName");
        event.rows = result.getInt("rows");
        events.add(event);
      }

    } catch (SQLException ex) {
      ex.printStackTrace();

    } finally {
      if (con != null) {
        try {
          con.close();
        } catch (SQLException e) {
          // ignore
        }
      }
    }

    return events;
  }