uvkf2r3Y

1if(race.getCutOffTime()!=null){
2    long cutOffHour=(race.getCutOffTime().getTime())/(3600000);
3    int cutOffMinute=(int)(race.getCutOffTime().getTime()%(60*60*1000));
4    System.out.println(cutOffHour+":"+cutOffMinute);
5    }
6	
7INSERT INTO MagEye.Races(RaceName, EventID,CutOffTime) 
8VALUES ('TEST', SELECT EventID FROM MagEye.Events 
9WHERE EventName='Sabrina Love',TIME '5:50:00');
10	
11CREATE TABLE IF NOT EXISTS MagEye.Races (RaceID INT PRIMARY KEY AUTO_INCREMENT ,  RaceName VARCHAR(100) ,EventID INT, Description TEXT, MaxEntrants INT, MinAge INT, MaxAge INT, RacePrefix VARCHAR (5), TimingMethod CHAR(1), CutOffTime TIME, RaceEnd TIMESTAMP,Finished BOOLEAN DEFAULT FALSE, Autostart BOOLEAN, FOREIGN KEY(EventID) REFERENCES MagEye.Events(EventID));
12	
13INSERT INTO MagEye.Races(RaceName, EventID,CutOffTime) VALUES ('TEST', SELECT EventID FROM MagEye.Events WHERE EventName='Sabrina Love',TIME '5:50:00');
14	
15raceDB.result = raceDB.state.executeQuery("SELECT * FROM MagEye.Races WHERE EventID=" + eventID + " ORDER BY RaceName");
16            java.util.ArrayList<Race> races = new java.util.ArrayList<>();
17
18
19            while (raceDB.result.next()) {
20                Race thisRace;
21                String timingMethodString = raceDB.result.getString("TimingMethod");
22                Race.TimingMethod timingMethod = null;
23                if (timingMethodString != null) {
24                    timingMethod = Race.TimingMethod.valueOf(timingMethodString);
25                } else {
26                    timingMethod = Race.TimingMethod.MANUAL;
27                }
28                thisRace = new Race(raceDB.result.getInt("RaceID"), event, raceDB.result.getString("RaceName"), raceDB.result.getString("Description"), raceDB.result.getInt("MaxEntrants"), raceDB.result.getInt("MinAge"), raceDB.result.getInt("MaxAge"), raceDB.result.getString("RacePrefix"), timingMethod,(raceDB.result.getTime("CutOffTime")), raceDB.result.getBoolean("Autostart"));
29thisRace = new Race(raceDB.result.getInt("RaceID"), event, raceDB.result.getString("RaceName"), raceDB.result.getString("Description"), raceDB.result.getInt("MaxEntrants"), raceDB.result.getInt("MinAge"), raceDB.result.getInt("MaxAge"), raceDB.result.getString("RacePrefix"), timingMethod,(raceDB.result.getTime("CutOffTime")), raceDB.result.getBoolean("Autostart"));
30	
31if(race.getCutOffTime()!=null){
32    long cutOffHour=(int)(race.getCutOffTime().getTime())/(3600000);
33    RacesCutOffLength.setText(cutOffHour+"");      
34    int cutOffMinute=(int)(race.getCutOffTime().getTime()%(60*60*1000));
35    this.RacesMinutes.setText(cutOffMinute+"");
36    }
37    else{
38        RacesCutOffLength.setText("0");      
39        RacesMinutes.setText("0");      
40    }