经典sql语句写法，值得借鉴

  public List getFwxList(String title){

 

          String sql = "select * from fwxx where 1 = 1";

 

          if(null != title && ! title.trim().equals("") ){

 

                   sql += "and title like '%" + title + "%' ";

          }

 

  }