title: When I try o insert data dataexecuteQuery() isn't working?
body: <p>Can't seem to fix this. Been trying to get it to work for the past hour. any help would be appreciated.</p>
  
  <pre><code>INFO: Server startup in 868 ms
  java.sql.SQLException: Can not issue data manipulation statements with executeQuery().Event{id=0, name='dads', venue='dasd', startDate='11/11/11', endDate='12/11/11'}
  </code></pre>
  
  <p>Seemed to be getting an error when I try to do an insert.</p>
  
  <pre><code>public void addEvent(Event event) throws DaoException{
          Connection con = null;
          PreparedStatement ps = null;
          ResultSet rs = null;
          try {
              con = this.getConnection();
  
              String query = "INSERT INTO TABLE EVENT VALUES(null, ?, ?, ?, ?)";         
              ps = con.prepareStatement(query);
              ps.setString(1, event.getName());
              ps.setString(2, event.getVenue());
              ps.setString(3, event.getStartDate());
              ps.setString(4, event.getEndDate());
  
              rs = ps.executeQuery();
          }catch(SQLException e) {
              System.out.println(event.toString());
              e.printStackTrace();
          }finally {
              try {
                  if (rs != null) {
                      rs.close();
                  }
                  if (ps != null) {
                      ps.close();
                  }
                  if (con != null) {
                      freeConnection(con);
                  }
              } catch (SQLException e) {
                  throw new DaoException("Couldn't " + e.getMessage());
              }
          }
      }
  </code></pre>