Adding a New User's Information

[Migrated From Jforum.net]

Hi Guys!

I would like to add a new obligatory information when a new user register himself.

In Brazil, for example, almost every citizen has an ID number named CPF. With this number is possible to check if that number is from that user, just visiting a government page!
There you can try the following CPF number: 44444444444, discovering that its number owned to MARIA FERRO PERON, for example! ;)

So, I tried to do some changes, like you can see on the below step-by-step:

1. Add a new column to the database:
ALTER TABLE jforum_users ADD user_cpf VARCHAR(11);

2. Edit the file \WEB-INF\config\languages\pt_BR.properties

User.user = Usu\u00E1rio
User.cpf = CPF
----------
User.fillUsername = Por favor, preencha o campo do Nome de Usu\u00E1rio
User.fillCpf = Por favor, preencha o campo do CPF (Cadastro de Pessoa Fisica)

3. Edit the file \config\database\generic\generic_queries.sql

#UserModel.addNew = INSERT INTO jforum_users (username, user_password,
user_email, user_regdate, user_actkey) VALUES (?, ?, ?, ?, ?)

UserModel.addNew = INSERT INTO jforum_users (username, user_password,
user_email, user_regdate, user_actkey, user_cpf) VALUES (?, ?, ?, ?, ?, ?)

4. Edit the file \src\net\jforum\view\forum\UserAction.java

this.context.put("username", this.request.getParameter("username"));
this.context.put("cpf", this.request.getParameter("cpf"));
----------
String username = this.request.getParameter("username");
String cpf = this.request.getParameter("cpf");
----------
u.setUsername(username);
u.setCpf(cpf);

5. Edit the file \src\net\jforum\entities\User.java

private String username;
private String cpf;
----------
public String getUsername() {
    return this.username;
}

public String getCpf() {
    return this.cpf;
}
----------
public void setUsername(String username) {
    this.username = username;
}

public void setCpf(String cpf) {
    this.cpf = cpf;
}

6. Edit the file \src\net\jforum\dao\generic\GenericUserDao.java

protected void initNewUser(User user, PreparedStatement p) throws Exception
{
    p.setString(1, user.getUsername());
    p.setString(2, user.getPassword());
    p.setString(3, user.getEmail());
    p.setTimestamp(4, new Timestamp(System.currentTimeMillis()));
    p.setString(5, user.getActivationKey());
    p.setString(6, user.getCpf());
}

7. Edit the file \templates\default\user_new.htm

    if (f.username.value == "") {
        alert("${I18n.getMessage("User.fillUsername")}");
        f.username.focus();

        return false;
    }

    if (f.cpf.value == "") {
        alert("${I18n.getMessage("User.fillCpf")}");
        f.cpf.focus();

        return false;
    }
    ----------
    <tr>
      <td CLASS="row1" ><SPAN CLASS="gen">${I18n.getMessage("User.user")}:
        *</SPAN></td>
      <td CLASS="row2">
        <INPUT CLASS="post" TYPE="text" STYLE="WIDTH: 200px" MAXLENGTH="25" SIZE="25"
         NAME="username" VALUE="${username?default("")?html}"/>
      </td>
    </tr>
    <tr>
      <td CLASS="row1" ><SPAN CLASS="gen">${I18n.getMessage("User.cpf")}:
        *</SPAN></td>
      <td CLASS="row2">
        <INPUT CLASS="post" TYPE="text" STYLE="WIDTH: 200px" MAXLENGTH="11" SIZE="25"
         NAME="cpf"")?html}"/>
      </td>
    </tr>
    <tr>

8. Deploy the JForum application with Ant

Finally, the screen created in a new register (/user/insert.page) has the field CPF: * correctly added!

And now, with all these changes, the CPF's value is recorded at user_cpf on jforum_users table!

This post was edited sometimes... but could be instructive for future references!

Enjoy it!!!
[originally posted on jforum.net by leandro_salvador]

[Migrated From Jforum.net]

Maybe the following explanation can help other JForum's newbies in the future:

1. user_new.htm calls pt_BR.properties via
getMessage("User.fillCpf") and
getMessage("User.cpf")

2. user_new.htm calls UserAction.java via
???

3. UserAction.java calls User.java via
u.setCpf(cpf);

4. User.java calls GenericUserDao.java via
setCpf(String cpf) { this.cpf = cpf; }

5. GenericUserDao.java calls generic_queries.sql via
p.setString(6, user.getCpf());

6. generic_queries.sql calls the database via
UserModel.addNew = INSERT INTO jforum_users (username, user_password,
user_email, user_regdate, user_actkey, user_cpf) VALUES (?, ?, ?, ?, ?, ?)

If anybody whose knows this flow better, please, will be a pleasure be corrected and really understand what JForum does in fact! :P

[ ]'s
[originally posted on jforum.net by leandro_salvador]