public Weekplanning getWeekplanningByID(int id){
		int Wid = 0;
		String klusNaam = null;
		String monteur = null;
		String auto = null;
		String datum = null;
		
		try {
			this.leesDatabase();
			statement = con.createStatement();
			output = statement.executeQuery("SELECT * FROM klussen where id='"+ id +"'");
			
			while (output.next()) {
				Wid = output.getInt("id");
				klusNaam = output.getString("klusnaam");
				monteur = output.getString("monteur");
				auto = output.getString("auto");
				datum = output.getString("datum");
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		Weekplanning week = new Weekplanning(id, klusNaam, monteur, auto, datum);
		
		return week;
	}