public void fillSzenarioIntoTables(String filename){
		
		Statement stmnt;
		StringSplitter ss = StringSplitter.getInstance();
		
		String fileNameVergleich=filename;
		  String finalString=getVehicleScheduleNameSzenario(fileNameVergleich);
		
		try {
			stmnt = connection.createStatement();
		
		  //Szenario
		  Iterator<String> it1 = ss.getSzenarioDutyID().iterator();
		  Iterator<String> it2 = ss.getSzenarioVehicleID().iterator(); 
		  Iterator<String> it3 = ss.getSzenarioServiceJourneyID().iterator(); 
		  Iterator<String> it4 = ss.getSzenarioDepTime().iterator();
		  Iterator<Integer> it5 = ss.getSzenarioDelay().iterator();
		  
		  stmnt.executeUpdate("INSERT INTO Szenario (Bezeichnung, FahrplanID, Datum) VALUES('"+fileNameVergleich+"',(SELECT f.ID FROM Fahrplan AS f WHERE f.Bezeichnung LIKE('%"+finalString+"%')), CURRENT_DATE);");
		  
		  while((it1.hasNext()&&it2.hasNext()&&it3.hasNext()&&it4.hasNext()&&it5.hasNext())){

			  String [] string=it4.next().split(":");
			  String time=string[1]+":"+string[2];
			  stmnt.executeUpdate("INSERT INTO PrimeDelaySzenario (DutyID, VehicleID, ServiceJourneyID, DepTime, Delay, SzenarioID) VALUES('"+it1.next()+"','"+it2.next()+"',(SELECT ID FROM ServiceJourney WHERE ServiceJourneyID='"+it3.next()+"' AND DepTime='"+time+"'),'"+time+"','"+it5.next()+"',(SELECT s.ID FROM Szenario AS s WHERE s.Bezeichnung ='"+fileNameVergleich+"'));");
		  }
		  
		  closeConnection();
		  } 
		catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} 
	}