import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.time.LocalDateTime;
import java.util.ArrayList;

/**
*
* @author
*/
public class DBHandler {

private Connection connection = null;

/**
* constructor
* @param dbName
*/
public DBHandler(String dbName) {
   try {
         Class.forName("org.sqlite.JDBC");
         String url = "jdbc:sqlite:" + dbName;
         connection = DriverManager.getConnection(url);
   } catch (SQLException | ClassNotFoundException e) {
         System.out.println(e.getMessage());
   }
}

/**
* get all events which haven't happened until the midnight
* @return list of event
*/
public ArrayList<RegistedClass> getUpcommingEvent() {
   String sql = "select s.name, start, end from Sport s inner join "
            + " ( "
            + " select sport_id, start, end "
            + " from Class c inner join TimeTable t "
            + " on c.time_id = t.id "
            + " where start >= ? "
            + " ) s1 on s.id = s1.sport_id";

   // get current time
   LocalDateTime now = LocalDateTime.now();
   // get current hour
   int hour = now.getHour();
   ArrayList<RegistedClass> al = new ArrayList<>();

   // run the query
   try {
         PreparedStatement ps = connection.prepareStatement(sql);
         ps.setInt(1, hour);
         ResultSet rs = ps.executeQuery();
         while (rs.next()) {
            al.add(new RegistedClass(new Time(rs.getInt("start"),
                     rs.getInt("end"), 0), rs.getString("name"), 0));
         }
   } catch (SQLException ex) {
         System.out.println(ex.getMessage());
   }
   return al;
}

/**
* get list of recommended sport
* which is good for the age of the client
* @param user
* @return
*/
public ArrayList<String> recommendedSport(User user) {
   String sql = "select s.name from Sport s where s.id not in "
            + " ("
            + " select c.sport_id "
            + " from Schedule sh inner join Class c "
            + " on sh.class_id = c.id "
            + " where sh.ssn = ? "
            + " ) and s.MaxAge >= ? and s.MinAge <= ?";
   ArrayList<String> al

Further Software Development Assignment 1 Brief Assignment 1 for t...