資源簡介
mysql版本 5.5以上
類中的數據庫連接只需要修改一下數據庫連接就可以了
文字數量:6763條

代碼片段和文件信息
package?com.gshm.hrp.core.util;
import?java.io.IOException;
import?java.io.InputStream;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.util.Properties;
public?class?CnToCode?{
private?String?wordKey; //中文字
private?StringBuffer?wbCode?=?new?StringBuffer(); //五筆碼
private?StringBuffer?pingCode?=?new?StringBuffer();; //拼音
private?Connection?connection;
private?static?String?driver;
private?static?String?url;
static{
InputStream?inputStream?=?CnToCode.class.getClassLoader().getResourceAsStream(“mysql.properties“);??
Properties?p?=?new?Properties();???
try?{
p.load(inputStream);
driver?=?p.getProperty(“jdbc.driverClassName“);
url?=?p.getProperty(“jdbc.url“);
}?catch?(IOException?e)?{
e.printStackTrace();
}
}
/*
?* 使用方法
CnToCode?ctc?=?new?CnToCode(str); //實例化的時候把需要轉換的字符串傳進去
五筆碼是??ctc.getWbCode() //然后用get獲取
拼音碼是??ctc.getPingCode());
?*/
public?CnToCode(String?wordStr){
try?{
Class.forName(driver);
connection?=?DriverManager.getConnection(url);
//把字符串換成char數組
char[]?chars?=?wordStr.toCharArray();
for?(int?i?=?0;?i? //中文在Unicode中的編碼區間為:0x4e00--0x9fbb?判斷是否中文
if((chars[i]?>=?0x4e00)?&&?(chars[i]?<=?0x9fbb)){
String?sql?=?“SELECT?*?FROM?aas_workcode?WHERE?WORDKEY=‘“?+?chars[i]?+?“‘“;
Statement?ps?=?connection.createStatement();
ResultSet?rs?=?ps.executeQuery(sql);
if(rs.next()){
wbCode.append(rs.getString(“wbCode“).substring(0?1).toUpperCase());
pingCode.append(rs.getString(“pingCode“).toUpperCase());
}
rs.close();
rs=null;
ps.close();
ps=null;
sql=null;
//釋放資源
}else{
wbCode.append((chars[i]+““).toUpperCase());
pingCode.append((chars[i]+““).toUpperCase());
}
}
connection.close();
connection=null;
}catch?(Exception?e)?{
e.printStackTrace();
}
}
public?String?getWordKey()?{
return?wordKey;
}
public?void?setWordKey(String?wordKey)?{
this.wordKey?=?wordKey;
}
public?StringBuffer?getWbCode()?{
return?wbCode;
}
public?void?setWbCode(StringBuffer?wbCode)?{
this.wbCode?=?wbCode;
}
public?StringBuffer?getPingCode()?{
return?pingCode;
}
public?void?setPingCode(StringBuffer?pingCode)?{
this.pingCode?=?pingCode;
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????441926??2012-09-18?11:21??aas_workcode.sql
?????文件????????2587??2012-09-18?11:20??CnToCode.java
- 上一篇:mappwidget切圖工具
- 下一篇:基于JSP的人事管理系統源代碼
評論
共有 條評論