To Track LoggedIn users to a system in JAVA

[Raja]

Scenario : i have the requirement where i need to
update a Table A and along with i have to insert a record in Table B.

We have a system , where we can create Users, and assign resources,
permission to the users,
When ever we create a user ,a record will Insert in the Table A,like
USER_NAME,STATUS,CREATION_TIME,LAST_ACCESSED_DATE, and so when ever
the User get login into the system,,LAST_ACCESS_DATE is getting
updated , with a update query being excuted.

I have a requirement i have to capure all the Logged -In users to the
system and get the details being stored in a database Table B.

Requirement: when ever the user gets logged In ,LAST_ACCESSED_DATE in
Table A and
users details should be get updated in the Table B
like USER_NAME,LOGIN_TIME in one shot.

Please let me know the approach for this in Java.

Any help in this is greatly appriciated.

 

[Sabine Dinis Blochberger]

Scenario : i have the requirement where i need to
update a Table A and along with i have to insert a record in Table B.

We have a system , where we can create Users, and assign resources,
permission to the users,
When ever we create a user ,a record will Insert in the Table A,like
USER_NAME,STATUS,CREATION_TIME,LAST_ACCESSED_DATE, and so when ever
the User get login into the system,,LAST_ACCESS_DATE is getting
updated , with a update query being excuted.

I have a requirement i have to capure all the Logged -In users to the
system and get the details being stored in a database Table B.

Requirement: when ever the user gets logged In ,LAST_ACCESSED_DATE in
Table A and
users details should be get updated in the Table B
like USER_NAME,LOGIN_TIME in one shot.

Please let me know the approach for this in Java.

Any help in this is greatly appriciated.

That shouldn't be too complicated.

Please see http://java.sun.com/docs/books/tutorial/jdbc/index.html
for fundamentals about JDBC.

 

[javalang]

JavaLang

Hi evryone,

you can also solve that using Triggers.
correct me if iam wrong.