Add new acitivity

[linhnh458]

Add method getAcitvityById(int aid) in ActivityDAO, method return info of an activity, distinguished by id

[linhnh458]

added

public ArrayList getActivityById(int aid) { ArrayList activities = new ArrayList<>(); try { String sql = "SELECT [activity_id]\n"

• " ,[act_description]\n"
• " ,[act_name]\n"

• " FROM [activity]

  • " where activity_id = ?""; connection = new DBContext().getConnection(); st = connection.prepareStatement(sql); st.setInt(1, aid); rs = st.executeQuery(); while (rs.next()) { Activity t = new Activity();

        t.setActivity_id(rs.getInt("activity_id"));
        t.setAct_description(rs.getString("act_description"));
        t.setAct_name(rs.getString("act_name"));
        activities.add(t);
    }

    } catch (SQLException ex) { Logger.getLogger(ActivityDAO.class.getName()).log(Level.SEVERE, null, ex); } catch (Exception ex) { Logger.getLogger(ActivityDAO.class.getName()).log(Level.SEVERE, null, ex); } return activities; }