Search user in user/list...

newbiejforum — GMT

In file generic_queries.sql:

[code]UserModel.findByName = SELECT user_id, username, user_email, user_regdate, user_posts, deleted \
FROM jforum_users \
WHERE UPPER(u.username) \
LIKE UPPER(?) [/code]

In file GenericUserDAO:

[code]public List findByName(String input, boolean exactMatch)
{
List namesList = new ArrayList();

PreparedStatement p = null;
ResultSet rs = null;
try {
p = JForumExecutionContext.getConnection().prepareStatement(SystemGlobals.getSql("UserModel.findByName"));
p.setString(1, exactMatch ? input : "%" + input + "%");

rs = p.executeQuery();
while (rs.next()) {
User u = new User();

u.setId(rs.getInt("user_id"));
u.setUsername(rs.getString("username"));
u.setColor(rs.getString("group_color"));
u.setEmail(rs.getString("user_email"));
u.setRegistrationDate(new Date(rs.getTimestamp("user_regdate").getTime()));
u.setTotalPosts(rs.getInt("user_posts"));
u.setDeleted(rs.getInt("deleted"));

namesList.add(u);
}
return namesList;
}
catch (SQLException e) {
throw new DatabaseException(e);
}
finally {
DbUtils.close(rs, p);
}
}[/code]

In file view/forum/UserAction:
[code]private void commonData()
{
this.setTemplateName(TemplateKeys.USER_LIST);
}

public void search()
{
String search = this.request.getParameter("username");

if (search != null && !"".equals(search)) {
List users;
users = DataAccessDriver.getInstance().newUserDAO().findByName(search, false);

this.commonData();

this.context.put("users", users);
this.context.put("search", search);
}
else {
this.list();
}
}[/code]

In file user_list.htm (not in admin/user_list.htm):
[code]

[/code]

Latest posts for the topic "Search user in user/list..."

Search user in user/list...