中文拼音混合查询.txt

在程序中实现拼音检索数据库中的信息

今天终于实现中文,拼音混合名字短信查询,将实现方式共享

期待结识更多喜欢研究的朋友!

package dhmtxl.ztp;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.regex.Pattern;

import com.common.DBConnectionManager;

public class ZTP {

 public String ZtoP(String str) {
  DBConnectionManager connMgr = DBConnectionManager.getInstance();
  Connection con = connMgr.getConnection("idb");
  Statement stmt = null;
  ResultSet rs = null;
  String py = "";
  String sql = "select py FROM t_zhongwenToPing where hz='" + str + "'";
  try {
   stmt = con.createStatement();

   rs = stmt.executeQuery(sql);

   while (rs.next()) {
    py = rs.getString(1);
   }
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   try {
    if (rs != null)
     rs.close();
   } catch (Exception e) {
    e.printStackTrace();
   }
   try {
    if (stmt != null)
     stmt.close();
   } catch (Exception e) {
    e.printStackTrace();
   }
   try {
    connMgr.freeConnection("idb", con);
    connMgr.release();
   } catch (Exception e) {
    e.getMessage();
   }
  }
  return py;
 }

 public static void main(String arg[]) {
  ZTP ztp = new ZTP();
  String name = "意大利";
  String nameP = "";
  char names[] = name.toCharArray();
  for (int i = 0; i < names.length; i++) {

//判断是否为中文
   if (Pattern.matches("[\u4e00-\u9fa5]", String.valueOf(names))) {

   //如果是中文,则从拼音表里查处该中文的拼音
    nameP += ztp.ZtoP(String.valueOf(names));
   } else
    nameP += names;
  }
  System.out.println(nameP);
 }
}