HELP about login time and date in netbeans

[masterpinuno]

what code should I use to insert a time and date where in when I press login button, the log in time and date of the user will be recorded to the database of mysql automaticallly? thank you and really appreciated your help.. thank you so much..

int pat=0;     

String sql = "Select * from admin";
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/admin","root","");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);


String user = jTextField1.getText();
String pwd = new String (jPasswordField2.getPassword());

while(rs.next()) {
    
String uname=rs.getString("Username");
String password=rs.getString("Password");

if ((user.equals(uname)) && (pwd.equals(password))){
    new AdminLogIn().setVisible(true);
    dispose();
    
    pat++;
    }
}
if (pat==0) {
JOptionPane.showMessageDialog(null, "Cannot find Username/Password in Database!");
}
}
    
catch (Exception e){
JOptionPane.showMessageDialog(this, e.getMessage());
}

[Tolls]

First off, don't check user credentials like that.
SELECT username FROM admin WHERE username = ? AND password = ?
Then use a PreparedStatement and bind (use setString()) to set the two variables.
Then you either get one row back (rs.next() is true) in which case these are correct, or no rows, in which case they are wrong.

As for your actual problem, is there a table in your database for storing the login time?
Then insert a row.
If it's just a last_logged_in column in the admin table then just UPDATE that value with the current time stamp.