How to write Springboot application logs to a postgresql database

How you can implement transactions in the database, like logging? For example, the user is logged in and this is immediately written to the table.

My plan of implementing your example.

1. Create login page (login, password) with url mapping /login. When user writes his credentials, a controller redirects him from /login to /success-login page.

2. Create controller with get mapping /success-login. When user gets to this page, it means that he is logged in. So here you can write an sql query to postgres table, something like id="1", user="user1", event="log in"

Model:

@Entity
public class Log {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
    String user;
    String event;

// getters, setters, equals, hashcode ...
}

Repository:

public interface LogRepository extends CrudRepository<Log, Long> {
}

Controller:

@Controller
public class LoginController {
    @Autowired
    LogRepository logRepository;

    @GetMapping("/login-success")
    public String loginSuccess() {
        Log log = new Log();
        log.setUser("user1");
        log.setEvent("log in");
        logRepository.save(log);
        return "login-success";
    }
}