u need a table which will have the userid, logintime, logouttime columns...
whenever the user logs into the application save the system date time into the database with userid as the criteria
when the user logs off or directly closes the application then prompt with a yes / no msg whether he wants to log out...
if he selects yes then save the logout time in the database with the same userid as criteria
Can the user log in on more than one machine at a time.
What happens if the user loses his/her connection without logging out, for example, if the user's machine or application fails or if the machine hosting the application dies.
You can account for #1 by storing the machine name in the table. You can account for #2 by resolving "orphaned" records at log in time (if the user logs in and there is a record for that user with a log in time and no log out time then you have to resolve the missing log out).
i have a query about loging details
Query = "INSERT INTO tbllog (USERID, userNAME, LOGIN) VALUES(' "& TextBOX1.text & " ',' " TextBox2.Text & " ',' " & Now &" ' "
it work fine for Login but when the user Logout how update the tblLOG FOR LogOUT column. . . . e.g
Query= " update tblLOG set Logout=' "& now &" ' where < here what we write to update the curent Login > "
. . . . , . !. ?
Help! I want to create a java program that finds the highest even integer among the values entered by the user. Stop asking values when a value less than 1 have been entered. If no even integer is entered, display "No Even Integer"
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...