try {
conn = ConnectDB.connectMSDB();
stmt = conn.createStatement();
rs = stmt.executeQuery(query);
while (rs.next()) {
AttendanceBean bean = new AttendanceBean();
bean.setMemberID(rs.getInt("MemberID"));
bean.setEventID(rs.getInt("EventID"));
bean.setType(rs.getInt("Type"));
bean.setTransactionID(rs.getInt("TransactionID"));
list.add(bean);
}
} catch (Exception e) {
e.printStackTrace();
} finally {