When I used this one:
users.put("emchibiet", new User("emchibiet", "kiemchutchao", new String[] { ADMIN_ROLE }));
I worked fine. But when I wanna insert database values into a Hashmap collection. Please help. Thanks!
I didn't work out. Here is my code:.

...
import java.util.HashMap;
import java.util.Map;
import deth.MSConnectionSQL;
...
public final class SecurityServiceImpl implements SecurityService
{
private Map users;
//private static final String ADMIN_ROLE = "administrator"; //$NON-NLS-1$
private Connection conn;
private ResultSet rs;
private PreparedStatement pre;
...

public SecurityServiceImpl()
{
MSConnectionSQL bean = new MSConnectionSQL();

if(bean != null)
{
try
{
// Open the connection.
conn = bean.getConnection();
StringBuffer sql = new StringBuffer();
sql.append("SELECT * FROM Users");
pre = conn.prepareStatement(sql.toString());
rs = pre.executeQuery();

if(rs.next())
{
users = new HashMap();
/*
users.put("emchibiet", new User("emchibiet", "kiemchutchao", new String[] { ADMIN_ROLE }));//$NON-NLS-1$
*/
users.put(rs.getString(1), new User(rs.getString(2), rs.getString(3), new String[] { rs.getString(4) }));
}

...
public User authenticate(String username, String password)
throws Exception {
User user = (User) users.get(username);
if (user == null)
throw new Exception("Unknown user"); //$NON-NLS-1$
boolean passwordIsValid = user.passwordMatch(password);
if (!passwordIsValid)
throw new Exception("Invalid password"); return user;

}
...

bui-anh-khoa

I will make it more clear.

I wanna add the values of ResultSet to a HashMap.
users.put(string key, Object object);
- object is user object of User class : User (String username, String password, String[] roles)

When I checked user's login as below:
users.put("emchibiet", new User("emchibiet", "kiemchutchao", new String[] { ADMIN_ROLE }));
Then everything was alright.

But in reality, the values must come from database. Therefore, I did:
users.put(rs.getString(1), new User(rs.getString(2), rs.getString(3), new String[] { rs.getString(4) }));
It took no error. But Map named users that had no values. So the authenticate method returns empty and throw an exception.

I heard somewhre it must be converted ResultSet to Map.

Thanks!



bui-anh-khoa