?? 中文拼音混合查詢.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);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -