public static void uploadAssignedJob(AssignedJob job) { try { String sql = "INSERT INTO assigned_jobs (jobId, employeeId, days, repeat, startTime, endTime, startingWeek) VALUES (?, ?, ?, ?, ?, ?, ?)"; PreparedStatement query = connection.prepareStatement(sql); query.setInt(1, job.getJobId()); query.setInt(2, job.getEmployeeId()); query.setByte(3, job.getDays()); query.setByte(4, job.getRepeat()); query.setLong(5, job.getStartTime().inMillis()); query.setLong(6, job.getEndTime().inMillis()); query.setLong(7, job.getStartingWeek()); query.executeUpdate(); query.close(); System.out.println(query.toString()); } catch (Exception e){ e.printStackTrace(); } }