ArrayList nl = new ArrayList();
ArrayList vl = new ArrayList();
String sql = makeSearchHsqlWithNameParam( userForm, nl, vl );
String [] names = null;
Object[] params = null;
if( nl.size() > 0 )
{
names = new String[ nl.size() ];
Iterator itr = nl.iterator();
for( int i=0; itr.hasNext();i++ )
{
names[i] = (String )itr.next();
}
params = vl.toArray();
}
List list = userBO.findByNamedsql( sql, names, params );
protected String makeSearchHsqlWithNameParam( UserForm userForm, ArrayList nl, ArrayList vl )
{
StringBuffer sbf = new StringBuffer();
String name = "unitId";
nl.add( name );
sbf.append( "select u from TabPUser u where u.unitId=:")
.append( name );
vl.add( userForm.getTabPUnit().getUnitId() );
if( !WebUtils.isNullString(userForm.getUserName() ) )
{
name = "name";
sbf.append( " and u.userName like :")
.append( name );
nl.add( name );
vl.add( "%" + userForm.getUserName() + "%" );
}
if( !WebUtils.isNullString(userForm.getUserNameTrue() ) )
{
name = "nameTrue";
sbf.append( " and u.userNameTrue like :")
.append( name );
nl.add( name );
vl.add( "%" + userForm.getUserNameTrue() + "%" );
}
if( !WebUtils.isNullString( userForm.getUserMobile() ) )
{
name= "mobile";
sbf.append( " and u.userMobile like :")
.append( name );
nl.add( name );
vl.add( "%"+ userForm.getUserMobile()+"%" );
}
return sbf.toString();
}