mysql中文全文检索方案

package com.qa.tools;
import java.io.UnsupportedEncodingException;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
publicclass ChineseCode {
static Pattern p = pile("[\u4E00-\u9FA5]+");
privatefinalstaticboolean is2 = true;
staticpublic String byteToHexString(byte b) {
byte[] bt = { b };
return byteToHexString(bt);
}
staticpublic String byteToHexString(byte[] bt) {
String hexUpper = "";
for (int i = 0; i<bt.length; i++) {
String hex = Integer.toHexString(bt[i] & 0xFF);
if (hex.length() == 1) {
hex = '0' + hex;
}
hexUpper += hex.toUpperCase();
}
return hexUpper;
}
staticpublic String chineseToCode2(String txt)
{
StringBuffer t = new StringBuffer();
for(int i=1;i<txt.length();i++)
{
if(is2)
{
String s = chineseToCode(txt.substring(i-1, i+1)) ;
t.append(s).append(" ");
}
else
{
t.append(chineseToCode(txt.substring(i-1, i))).append(" ");
}
}
return t.toString();
}
staticpublic String chineseToCode(String chinese) {
byte[] bt;
StringBuffer code = new StringBuffer();
try {
bt = chinese.getBytes("GB2312");
for (int i = 0; i<bt.length; i++) {
int a = Integer.parseInt(byteToHexString(bt[i]), 16);
code.append((a - 0x80 - 0x20));
}
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
return code.toString();
}
publicstatic String str2Hex(String s)
{
StringBuffersbf = new StringBuffer(s.length() * 6);
Matcher m = p.matcher(s);
while (m.find()) {
m.appendReplacement(sbf, " "
+ ChineseCode.chineseToCode2(m.group(0)));
}
m.appendTail(sbf);
return sbf.toString();
}
publicstatic String index2(String txt)
{
StringBuffer t = new StringBuffer();
for(int i=1;i<txt.length();i++)
{
t.append(txt.charAt(i-1)).append(txt.charAt(i)).append(" ");
}
return txt;
}
publicstaticvoid main(String[] args) throws Exception { System.out.println(str2Hex("中华人a民共和b国,"));
System.out.println(chineseToCode2("中华人a民共和b国,"));
} }。