How to store the login date and time in JSP for the next login

Asa a user login, store time in a DB (update if a row for this user already exist, insert when this is very first login). There is no other way, unless you can be sure that server will never restart(this is impossible though)

Regards,
Mohit

I have changed my code and I am using the following lines:

session = request.getSession(true);
.
.
.
session.getLastAccessedTime();
out.println(new java.util.Date(session.getLastAccessedTime()));

I am bit lost, could you kindly tell me how do I store this in a database?

Regards,

Maria

You can store it as a java.sql.Date (using a PrepearedStatement to avoid date
formatting problems) or as a long value (in millisec. format), ...
but maybe its the database storing as such that is the problem ?

If this system utilized authentication (nick & password) a DB solution with
userdata update on every login is the solution. In fact, for
the case of different computers for same user, its the only solution

As far as I can see newTime is not declared, at least not in the code you
have posted here (it has to be defined before you use it...)

Anyway, I have never managed to stuff a java.util.Date into an sql database
just like that. I'm using java.sql.Date.

Check the code snippet below, I'm using a prepared statement for updating
a date field in the db and a simple date format to print it (its only an
ms-access db that I use to bang around with, but its sql nevertheless)

import java.sql.*;
import java.text.*;

/**
* Updating a date field in an SQL database
*/

public class MSAccessDB {
public static SimpleDateFormat sd=new SimpleDateFormat("MMM dd yyyy");
private PreparedStatement pStmt=null;
private Statement stmt=null;
private Connection msConn=null;

public MSAccessDB() {
try {
jbInit();
int userID=1;
listLoginData();
updateUserLogin(userID);
listLoginData();
}
catch(Exception e) {
e.printStackTrace();
}
}
private void listLoginData() throws SQLException {
ResultSet rs=stmt.executeQuery("select * from user_table");
while (rs.next()) {
System.out.print(rs.getInt("user_id")+"\t");
System.out.print(rs.getString("nick_name")+"\t");
System.out.print(rs.getString("last_name")+"\t");
System.out.print(rs.getString("first_name")+"\t");
System.out.print(sd.format(rs.getDate("last_access_date"))+"\n");
}
}
private void updateUserLogin(int userID) throws SQLException {
java.sql.Date today=new java.sql.Date(System.currentTimeMillis());
pStmt.setDate(1,today);
pStmt.setInt(2,userID);
pStmt.executeUpdate();
}
private void jbInit() throws Exception {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
msConn=DriverManager.getConnection("jdbc:odbc:test_db;;;");
String psStr="update user_table set last_access_date=? where user_id=?";
pStmt=msConn.prepareStatement(psStr);
stmt=msConn.createStatement();
}

public static void main(String[] args) {
MSAccessDB mdb=new MSAccessDB();
}
}

If you want to put the current time into your DB, why not use a statement like

String sql = "UPDATE user_table SET lastlogin=now() WHERE id=" + userID;

Assuming lastlogin is of type datetime, just let the db get the current date with it's now() function.

Then when you login just retrieve this time along with any other user info and store that in a session DTO.