Code (Java)

        public void populateCalendar(){

            Appointment app = new Appointment();

            try{

            String sqlGetCalendar = "SELECT * FROM tbl_calendar";

            Connection conn = db_manage.Connect();

            PreparedStatement pStatementGetCalendar = conn.prepareStatement(sqlGetCalendar);

            ResultSet rSet = pStatementGetCalendar.executeQuery();

            while (rSet.next()){

                Date dateStart = rSet.getDate("dateStart");
                Date dateEnd = rSet.getDate("dateEnd");

                Time timeStart = rSet.getTime("timeStart");
                Time timeEnd = rSet.getTime("timeEnd");

                DateTime startDateTime = new DateTime(dateStart.getYear()+1900, dateStart.getMonth()+1, dateStart.getDate(), timeStart.getHours(), timeStart.getMinutes(), 0);
                DateTime endDateTime = new DateTime(dateEnd.getYear()+1900, dateEnd.getMonth()+1, dateEnd.getDate(), timeEnd.getHours(), timeEnd.getMinutes(), 0);


                app.setStartTime(startDateTime);
                app.setEndTime(endDateTime);

                app.setHeaderText(rSet.getString("assignedTo"));

                calendar.getSchedule().getItems().add(app);

            }

            conn.close();

        }

        catch (Exception ee){

            JOptionPane.showMessageDialog(null, "Cannot get tasks. Error: " + ee);

        }


        }