hibernate中文输入信息搜索，要用参数的查询方式-CSDN博客

本文链接：https://blog.csdn.net/Jahson/article/details/1880919

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();
}