String sql = "insert into web_users(username, password, phone, company) values(?,?,?,?)";

        KeyHolder keyHolder = new GeneratedKeyHolder();

        getJdbcTemplate().update(

                con -> {

                    PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);

                    ps.setString(1, user.getUsername());

                    ps.setString(2, user.getPassword());

                    ps.setString(3, user.getPhone());

                    ps.setString(4, user.getCompany());

                    return ps;

                }, keyHolder);

        int userid = (int) keyHolder.getKeys().get("id");

        return userid;

CREATE SEQUENCE web_users_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1;