Java--sql Fuzzy Query (string splitting and splicing)

Package com.shangyu.utils;

public class Test {

public static void Main (string[] args) {

String str = "Songjiang jiuting";

StringBuffer sb = new StringBuffer ();

for (int i = 0; I <str.length (); i++) {

if (sb.tostring () = null && sb.tostring () = "" ") {

Sb.append (",");

}

Sb.append (Str.charat (i));

}

String keyword = sb.tostring (). substring (1);

Keyword = Keyword.replaceall (",", "%");

SYSTEM.OUT.PRINTLN (keyword);//Result: pine% River Nine Pavilion

}

}

Fuzzy query SQL statement:

SELECT * from tb_table where address like '% ' +str+ "% '

As long as the query's keyword contains this one of these characters is in the results of the query

This article is from the "extraordinary life-seekers of knowledge" blog, please be sure to keep this source http://825272560.blog.51cto.com/11004487/1880107

Java--sql Fuzzy Query (string splitting and splicing)