return retVal;
}
public UserInfo getUserInfo(UserID id) {
UserInfo retVal = null;
Connection connection = null;
try {
String sql = "select * from bpm_userinfo where userid = " + id;
connection = getConnection();
Statement statement = connection.createStatement();
ResultSet result = statement.executeQuery( sql );
result.next();
retVal = new UserInfo();
retVal.setUserName( result.getString( "name" ) );
retVal.setUserPrincipal( result.getString( "principal" ) );
retVal.setUserPassword( result.getString( "password" ) );
retVal.setAdmin(result.getBoolean("isadmin"));
retVal.setUserID( new UserID( result.getInt( "userid" ) ) );
result.close();
statement.close();
} catch( SQLException e ) {
throw new RuntimeException( e );