query = "%"+query+"%";
ps = conn.prepareStatement(RDBMPersonSearcher.person_partial_search);
ups = conn.prepareStatement(RDBMPersonSearcher.user_partial_search);
break;
default:
throw new GroupsException("Unknown search type");
}
ps.clearParameters();
ps.setString(1,query);
ps.setString(2,query);
rs = ps.executeQuery();
//System.out.println(ps.toString());
while (rs.next()){
//System.out.println("result");
uis.clearParameters();
uis.setString(1,rs.getString(1));
urs = uis.executeQuery();
if(urs.next()){
ar.add(new EntityIdentifier(urs.getString(1),personDef));
}
}
ups.clearParameters();
ups.setString(1,query);
uprs = ups.executeQuery();
while (uprs.next()){
ar.add(new EntityIdentifier(uprs.getString(1),personDef));
}
} catch (SQLException e) {
throw new GroupsException("RDBMChannelDefSearcher.searchForEntities(): " + ps,e);
} finally {
if (rs!=null) RDBMServices.closeResultSet(rs);
if (urs!=null) RDBMServices.closeResultSet(urs);
if (uprs!=null) RDBMServices.closeResultSet(uprs);
if (ps!=null) RDBMServices.closeStatement(ps);