public Klus getKlusById(int id){
		int kN = 0, aI = 0, wI = 0, iG = 0;
		String kNm = null;
		String kO = null;
		String dT = null;
		
		try {
			this.leesDatabase();
			statement = con.createStatement();
			output = statement.executeQuery("SELECT * FROM klussen where id='"+ id +"'");
			
			while (output.next()) {
				kN = output.getInt("id");
				kNm = output.getString("naam");
				kO = output.getString("omschrijving");
				aI = output.getInt("auto_id");
				wI = output.getInt("werknemer_id");
				iG = output.getInt("ingepland");
				dT = output.getString("datum");
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		Klus k = new Klus(kN, kNm, kO, aI, wI, dT, iG);
		
		return k;
	}