public static void logAccess(AccessLog objAL) {
PreparedStatement ps = null;
String sInsert = "INSERT INTO AccessLogs (accessid, userid, accesstime) VALUES (?, ?, ?)";
Connection ad_conn = MedwanQuery.getInstance().getAdminConnection();
try {
ps = ad_conn.prepareStatement(sInsert);
ps.setInt(1, MedwanQuery.getInstance().getOpenclinicCounter("AccessLogs"));
ps.setInt(2, objAL.getUserid());
ps.setTimestamp(3, objAL.getAccesstime());
ps.execute();
ps.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (ps != null) ps.close();
ad_conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
