public int addReport(Report report) {
		PreparedStatement pStatement = null;
		ResultSet rs = null;
		int id = 0;

		try{
			statement = connection.createStatement();
			String query = "INSERT INTO reports (cabin_id, wood, damage, missing, other, email, report_date) "
					+ "VALUES (?, ?, ?, ?, ?, ?, ?)";
			pStatement = connection.prepareStatement(query, Statement.RETURN_GENERATED_KEYS); 
			pStatement.setInt(1, report.getCabin_id());
			pStatement.setInt(2, report.getWood());
			pStatement.setString(3, report.getDamage());
			pStatement.setString(4, report.getMissing());
			pStatement.setString(5, report.getOther());
			pStatement.setString(6, report.getEmail());
			pStatement.setDate(7, new java.sql.Date(report.getReport_date().getTime()));
			pStatement.execute();
			
			rs = pStatement.getGeneratedKeys();
			if(rs.next()) {
				id = rs.getInt(1);
			} else {
				id = -2;
			}
		} catch (Exception e){
			e.printStackTrace();
			id = -1;
		} finally {
			try{ if(rs != null) rs.close(); } catch(Exception e) {};
			try{ if(statement != null) statement.close(); } catch(Exception e) {};
		}

		return id;
	}