由于太长：只能这样分开贴
-------------------------------------------------------
核心实现bean
ntDB.java
package dba;
/* newtower存取数据库 */
/* 调用范例
nttest
<%@page import="java.util.*"%>
<%@page import="java.text.*"%>
<%@page import="dba.ntDB"%>
<%
ntDB nt = new ntDB();
nt.executeQuery("yw","select * from msgboard_wjm");
out.println( (new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss.SSS")).format(new Date()) );
file://out.println( (new Date()).toString() );
out.println("<br>");
out.println( nt.rowCount );
out.println("<table border=1 >");
for(int i=0;i< nt.rowCount;i++ ){
if(i==0){
out.println("<tr>");
for(int k=0;k< nt.colCount;k++ ){
out.println("<td>");
out.print( nt.fieldName[k] );
out.print("</td>");
}
out.println("</tr>");
}
out.println("<tr>");
for(int j=0;j< nt.colCount;j++ ){
out.println("<td>");
out.println( nt.data[i][j] );
out.println("</td>");
}
out.println("</tr>");
}
out.println("</table>");
%>
*/
import java.util.*;
import java.lang.*;
import java.text.*;
import java.sql.*;
import java.sql.Connection;
import javax.sql.*;
import javax.naming.*;
import javax.transaction.*;
import java.io.*;
import java.net.*;
public class ntDB {
private Connection con;
private String connName;
private Statement statement ;
private ResultSet rs = null ;
private ResultSetMetaData rsmd;
file://额外方法
private Hashtable ht_PinYin=new Hashtable(10);
public int rowCount ;
public int colCount ;
public String[] fieldName ;
public int[] fieldType ;
public int[] columnDisplaySize ;
public String[][] data = null ;
////额外方法
public ntDB() {
rowCount=-1;
colCount=-1;
}
private void getConn(){
try{
Context env=(Context)new InitialContext().lookup("java:comp/env");
DataSource ds = (DataSource) env.lookup("jdbc/"+connName);
con = ds.getConnection();
}catch(Exception e){
e.printStackTrace();
con = null;
}
}
private void closeConn() throws Exception
{
if( con != null )
con.close();
}
public void executeQuery( String _connName, String SQL )
throws SQLException,Exception
{
file://Hashtable ht = new Hashtable();
try{
connName = _connName;
getConn();
statement = con.createStatement();
String sql = SQL ;
file://sql = new String(sql.getBytes("GBK"),"8859_1");
try{
rs = statement.executeQuery( sql );
}catch(Exception e){
throw new Exception( e.getMessage() + "\n" + sql );
}
if( rs == null )
return ;
// getMetaData
rsmd = rs.getMetaData(); file://ResultSetMetaData
colCount = -1;
colCount = rsmd.getColumnCount();
fieldName = new String[colCount]; file://String[]
fieldType = new int[colCount]; file://int[]
columnDisplaySize = new int[colCount]; file://int[]
for(int i=0;i<colCount;i++)
{
fieldName[i] = rsmd.getColumnName(i+1) ;
columnDisplaySize[i] = rsmd.getColumnDisplaySize(i+1) ;
fieldType[i] = rsmd.getColumnType(i+1) ;
}
//
if( colCount <= 0 )
return ;
Vector v = new Vector();
while( rs.next() )
{
String[] sRow = new String[colCount];
for(int i=0;i<colCount;i++){
sRow[i] = rs.getString(i+1);
/*
if( fieldType[i] == java.sql.Types.DATE
||
fieldType[i] == java.sql.Types.TIME
||
fieldType[i] == java.sql.Types.TIMESTAMP
)
{
sRow[i] = (new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss.SSS")).format(rs.getTimestamp(i+1));
}
*/
}
v.add( sRow );
file://(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS")).format(new Date())
// java.sql.Types.DATE
}
rowCount = -1; file://int
rowCount = v.size(); file://int
data = new String[rowCount][colCount];
for(int i=0;i<rowCount;i++)
{
for(int j=0;j<colCount;j++){
data[i][j] = ((String[])v.elementAt(i))[j];
if( data[i][j] == null )
data[i][j] = "";
data[i][j] = data[i][j].trim();
}
}
rs.close();
statement.close();
/*
if( colCount >= 0 ){
ht.put("fieldCount",""+colCount);
ht.put("colCount",""+colCount);
}
if( fieldName != null )
ht.put("fieldName",fieldName);
if( fieldType != null )
ht.put("fieldType",fieldType);
if( data != null )
ht.put("data",data); file://return data;
ht.put("rowCount",""+rowCount);
*/
}finally{
closeConn();
}
file://return ht;
}
file://return row count affected
// public void executeQuery( String _connName, String SQL )
public int executeUpdate( String _connName, String SQL ) throws Exception
{
String sql = SQL ;
file://sql = new String(sql.getBytes("GBK"),"8859_1");
int result ;
connName = _connName;
getConn();
statement = con.createStatement(); file://Statement
try
{
result = statement.executeUpdate( sql );
}
catch (Exception e33)
{
throw new Exception( "newtower:ntDB:executeUpdate:"+ e33.getMessage() + "\n" + sql );
}
finally{
closeConn();
}
return result;
}
public String data(int i, String _fieldName){
if( i > rowCount-1 )
return "";
return data[i][ntStringIndexOf(fieldName,_fieldName)];
}
public String data(int i, String _fieldName, int _begin , int _end ){
if( i > rowCount-1 )
return "";
String s = data[i][ntStringIndexOf(fieldName,_fieldName)];
s = ntSubString( s , _begin , _end );
return s;
}
public String getKV( String tableName,int _pid , String _k ) throws Exception{
String tableNameSuffix = "";
if( _k.indexOf("numeric")==0 && tableName.indexOf("_numeric")<0 )
tableNameSuffix = "_numeric";
else if( _k.indexOf("text")==0 && tableName.indexOf("_text")<0 )
tableNameSuffix = "_text";
else if( _k.indexOf("date")==0 && tableName.indexOf("_datetime")<0 )
tableNameSuffix = "_datetime";
this.executeQuery("eweb",
" select v from "+ tableName + tableNameSuffix +
" where pid = " + _pid +
" and k ='"+ (_k) + "'" +
"");
if( this.rowCount > 1 )
throw new Exception( tableName + tableNameSuffix +
"发现多于一个值 pid=["+ _pid +"] k=[" + _k +"]" );
if( this.rowCount ==1 )
return data[0][0];
else
return "";
}
public String getKV( String tableName
,int _pid
,String _k
,int _begin //
,int _end //
) throws Exception{
String s = getKV( tableName, _pid , _k );
s = ntSubString( s , _begin , _end );
return s;
}
public String getKV( int _pid , String _k ) throws Exception{
String s = "";
for(int i=0;i<rowCount;i++)
{
if( data(i,"pid").equals(""+_pid)
&& data(i,"k").equals(""+_k)
)
{ s = data(i,"v") ; break; }
}
return s;
}
public String getKV( int _pid file://1
,String _k file://2
,int _begin file://3
,int _end file://4
) throws Exception{
String s = getKV( _pid , _k );
s = ntSubString( s , _begin , _end );
return s;
}
public String getPublish( int _pid , String _k ) throws Exception{
return getKV( "publish" , _pid, _k );
}
//////////////////////////////////////////////////////////
public String ntSubString( String _s , int _begin , int _end ){
String r = _s ;
try{
r = _s.substring(_begin,_end);
}catch(Exception e238SubString){
r = _s ;
}
return r;
}
public String nt8859( String s ) throws Exception{
return new String(s.getBytes("GBK"),"8859_1");
}
public String ntFormatHour( String s ){
if( s == null )
return null;
String r = s;
if( s.trim().length() == 1 )
r = "0" + r;
return r;
}
public int ntGetMonthDayCount( int year ,int month ){
int r = 31 ;
if( month == 4 || month == 6 || month == 9 || month == 11 )
r = 30 ;
if( month == 2 ){
r = 28 ;
if( (year%4)==0 && (year%400)==0 ) r = 29 ;
if( (year%4)==0 && (year%100)!=0 ) r = 29 ;
}
return r;
}
public String ntEncodeSimple( String s ){
if( s == null )
return null;
String r = "";
for( int i=0;i<s.length() ;i++ ){
char c = s.charAt(i);
if( c == '\n' )
r = r + "\n" ;
else if( c == '\\' )
r = r + "\\\\";
else if( c == (char)(13) )
r = r ;
else if( c == (char)(10) )
r = r ;
else if( c == '\"' )
r = r + "\\\"";
else
r = r + c;
}
return r;
} // end ntEncodeSimple
public String ntEncodeDB( String s ){
if( s == null )
return null;
String r = "";
for( int i=0;i<s.length() ;i++ ){
char c = s.charAt(i);
if( c == '\'' )
r = r + "''" ;
else
r = r + c;
}
return r;
} // end ntEncodeDB
public String ntRemoveChar( String s, char cDel ){
if( s == null ) return null;
String r = "";
for( int i=0;i<s.length() ;i++ ){
char c = s.charAt(i);
if( c == cDel ) ;
else r = r + c;
}
return r;
} // end ntRemoveChar
public int ntStringIndexOf( String[] ss , String s )
{
int pos = -1 ;
for(int i=0;i<ss.length;i++)
{
if( ss[i].equalsIgnoreCase(s) )
{
pos = i;
break;
}
}
return pos;
}
public String toPinYin(String str, String flag) throws Exception {
char[] hz= nt8859(str).toCharArray();
int len=nt8859(str).length();
int p,q;
String ret="";
for(int i=0;i<len;i++){
p=(int)hz[i];
if(p>160){
q=(int)hz[++i];
p=p*256+q-65536;
}
if( flag.length()>0 )
if( flag.indexOf("C")==0 ){
String s = toPinYin_IntToPY(new Integer(p));
s = s.substring(0,1).toUpperCase() +
s.substring(1,s.length());
ret+= s + flag.substring(1,flag.length()) ;
}
else
ret+= toPinYin_IntToPY(new Integer(p)) + flag ;
else
ret+= toPinYin_IntToPY(new Integer(p)) ;
if( flag.indexOf("C")==0 )
return ret.substring(0,ret.length()-flag.length()+1);
else
return ret.substring(0,ret.length()-flag.length());
}
String toPinYin_IntToPY(Integer n){
int num=n.intValue();
if(num>0&&num<160){
return String.valueOf((char)num);
}
else if(num<-20319||num>-10247){
return "";
}
else{
if(ht_PinYin.size()==0){toPinYin_ht();}
while(!ht_PinYin.containsKey(Integer.toString(num)))num--;
return ht_PinYin.get(Integer.toString(num)).toString();
}
}
void toPinYin_ht(){
ht_PinYin.put("-20319","a");
ht_PinYin.put("-20317","ai");
ht_PinYin.put("-20304","an");
ht_PinYin.put("-20295","ang");
ht_PinYin.put("-20292","ao");
ht_PinYin.put("-20283","ba");
ht_PinYin.put("-20265","bai");
ht_PinYin.put("-20257","ban");
ht_PinYin.put("-20242","bang");
ht_PinYin.put("-20230","bao");
ht_PinYin.put("-20051","bei");
ht_PinYin.put("-20036","ben");
ht_PinYin.put("-20032","beng");
ht_PinYin.put("-20026","bi");
ht_PinYin.put("-20002","bian");
ht_PinYin.put("-19990","biao");
ht_PinYin.put("-19986","bie");
ht_PinYin.put("-19982","bin");
ht_PinYin.put("-19976","bing");
ht_PinYin.put("-19805","bo");
ht_PinYin.put("-19784","bu");
ht_PinYin.put("-19775","ca");
ht_PinYin.put("-19774","cai");
ht_PinYin.put("-19763","can");
ht_PinYin.put("-19756","cang");
ht_PinYin.put("-19751","cao");
ht_PinYin.put("-19746","ce");
ht_PinYin.put("-19741","ceng");
ht_PinYin.put("-19739","cha");
ht_PinYin.put("-19728","chai");
ht_PinYin.put("-19725","chan");
ht_PinYin.put("-19715","chang");
ht_PinYin.put("-19540","chao");
ht_PinYin.put("-19531","che");
ht_PinYin.put("-19525","chen");
ht_PinYin.put("-19515","cheng");
ht_PinYin.put("-19500","chi");
ht_PinYin.put("-19484","chong");
ht_PinYin.put("-19479","chou");
ht_PinYin.put("-19467","chu");
ht_PinYin.put("-19289","chuai");
ht_PinYin.put("-19288","chuan");
ht_PinYin.put("-19281","chuang");
ht_PinYin.put("-19275","chui");
ht_PinYin.put("-19270","chun");
ht_PinYin.put("-19263","chuo");
ht_PinYin.put("-19261","ci");
ht_PinYin.put("-19249","cong");
ht_PinYin.put("-19243","cou");
ht_PinYin.put("-19242","cu");
ht_PinYin.put("-19238","cuan");
ht_PinYin.put("-19235","cui");
ht_PinYin.put("-19227","cun");
ht_PinYin.put("-19224","cuo");
ht_PinYin.put("-19218","da");
ht_PinYin.put("-19212","dai");
ht_PinYin.put("-19038","dan");
ht_PinYin.put("-19023","dang");
ht_PinYin.put("-19018","dao");
ht_PinYin.put("-19006","de");
ht_PinYin.put("-19003","deng");
ht_PinYin.put("-18996","di");
ht_PinYin.put("-18977","dian");
ht_PinYin.put("-18961","diao");
ht_PinYin.put("-18952","die");
ht_PinYin.put("-18783","ding");
ht_PinYin.put("-18774","diu");
ht_PinYin.put("-18773","dong");
ht_PinYin.put("-18763","dou");
ht_PinYin.put("-18756","du");
ht_PinYin.put("-18741","duan");
ht_PinYin.put("-18735","dui");
ht_PinYin.put("-18731","dun");
ht_PinYin.put("-18722","duo");
ht_PinYin.put("-18710","e");
ht_PinYin.put("-18697","en");
ht_PinYin.put("-18696","er");
ht_PinYin.put("-18526","fa");
ht_PinYin.put("-18518","fan");
ht_PinYin.put("-18501","fang");
ht_PinYin.put("-18490","fei");
ht_PinYin.put("-18478","fen");
ht_PinYin.put("-18463","feng");
ht_PinYin.put("-18448","fo");
ht_PinYin.put("-18447","fou");
ht_PinYin.put("-18446","fu");
ht_PinYin.put("-18239","ga");
ht_PinYin.put("-18237","gai");
ht_PinYin.put("-18231","gan");
ht_PinYin.put("-18220","gang");
ht_PinYin.put("-18211","gao");
ht_PinYin.put("-18201","ge");
ht_PinYin.put("-18184","gei");
ht_PinYin.put("-18183","gen");
ht_PinYin.put("-18181","geng");
ht_PinYin.put("-18012","gong");
ht_PinYin.put("-17997","gou");
ht_PinYin.put("-17988","gu");
ht_PinYin.put("-17970","gua");
ht_PinYin.put("-17964","guai");
ht_PinYin.put("-17961","guan");
ht_PinYin.put("-17950","guang");
ht_PinYin.put("-17947","gui");
ht_PinYin.put("-17931","gun");
ht_PinYin.put("-17928","guo");
ht_PinYin.put("-17922","ha");
ht_PinYin.put("-17759","hai");
ht_PinYin.put("-17752","han");
ht_PinYin.put("-17733","hang");
ht_PinYin.put("-17730","hao");
ht_PinYin.put("-17721","he");
ht_PinYin.put("-17703","hei");
ht_PinYin.put("-17701","hen");
ht_PinYin.put("-17697","heng");
ht_PinYin.put("-17692","hong");
ht_PinYin.put("-17683","hou");
ht_PinYin.put("-17676","hu");
ht_PinYin.put("-17496","hua");
ht_PinYin.put("-17487","huai");
ht_PinYin.put("-17482","huan");
ht_PinYin.put("-17468","huang");
ht_PinYin.put("-17454","hui");
ht_PinYin.put("-17433","hun");
ht_PinYin.put("-17427","huo");
ht_PinYin.put("-17417","ji");
ht_PinYin.put("-17202","jia");
ht_PinYin.put("-17185","jian");
ht_PinYin.put("-16983","jiang");
ht_PinYin.put("-16970","jiao");
ht_PinYin.put("-16942","jie");
ht_PinYin.put("-16915","jin");
ht_PinYin.put("-16733","jing");
ht_PinYin.put("-16708","jiong");
ht_PinYin.put("-16706","jiu");
ht_PinYin.put("-16689","ju");
ht_PinYin.put("-16664","juan");
ht_PinYin.put("-16657","jue");
ht_PinYin.put("-16647","jun");
ht_PinYin.put("-16474","ka");
ht_PinYin.put("-16470","kai");
ht_PinYin.put("-16465","kan");
ht_PinYin.put("-16459","kang");
ht_PinYin.put("-16452","kao");
ht_PinYin.put("-16448","ke");
ht_PinYin.put("-16433","ken");
ht_PinYin.put("-16429","keng");
ht_PinYin.put("-16427","kong");
ht_PinYin.put("-16423","kou");
ht_PinYin.put("-16419","ku");
ht_PinYin.put("-16412","kua");
ht_PinYin.put("-16407","kuai");
ht_PinYin.put("-16403","kuan");
ht_PinYin.put("-16401","kuang");
ht_PinYin.put("-16393","kui");
ht_PinYin.put("-16220","kun");
ht_PinYin.put("-16216","kuo");
ht_PinYin.put("-16212","la");
ht_PinYin.put("-16205","lai");
ht_PinYin.put("-16202","lan");
ht_PinYin.put("-16187","lang");
ht_PinYin.put("-16180","lao");
ht_PinYin.put("-16171","le");
ht_PinYin.put("-16169","lei");
ht_PinYin.put("-16158","leng");
ht_PinYin.put("-16155","li");
ht_PinYin.put("-15959","lia");
ht_PinYin.put("-15958","lian");
ht_PinYin.put("-15944","liang");
ht_PinYin.put("-15933","liao");
ht_PinYin.put("-15920","lie");
ht_PinYin.put("-15915","lin");
ht_PinYin.put("-15903","ling");
ht_PinYin.put("-15889","liu");
ht_PinYin.put("-15878","long");
ht_PinYin.put("-15707","lou");
ht_PinYin.put("-15701","lu");
ht_PinYin.put("-15681","lv");
ht_PinYin.put("-15667","luan");
ht_PinYin.put("-15661","lue");
ht_PinYin.put("-15659","lun");
ht_PinYin.put("-15652","luo");
ht_PinYin.put("-15640","ma");
ht_PinYin.put("-15631","mai");
ht_PinYin.put("-15625","man");
ht_PinYin.put("-15454","mang");
ht_PinYin.put("-15448","mao");
ht_PinYin.put("-15436","me");
ht_PinYin.put("-15435","mei");
ht_PinYin.put("-15419","men");
ht_PinYin.put("-15416","meng");
ht_PinYin.put("-15408","mi");
ht_PinYin.put("-15394","mian");
ht_PinYin.put("-15385","miao");
ht_PinYin.put("-15377","mie");
ht_PinYin.put("-15375","min");
ht_PinYin.put("-15369","ming");
ht_PinYin.put("-15363","miu");
ht_PinYin.put("-15362","mo");
ht_PinYin.put("-15183","mou");
ht_PinYin.put("-15180","mu");
ht_PinYin.put("-15165","na");
ht_PinYin.put("-15158","nai");
ht_PinYin.put("-15153","nan");
ht_PinYin.put("-15150","nang");
ht_PinYin.put("-15149","nao");
ht_PinYin.put("-15144","ne");
ht_PinYin.put("-15143","nei");
ht_PinYin.put("-15141","nen");
ht_PinYin.put("-15140","neng");
ht_PinYin.put("-15139","ni");
ht_PinYin.put("-15128","nian");
ht_PinYin.put("-15121","niang");
ht_PinYin.put("-15119","niao");
ht_PinYin.put("-15117","nie");
ht_PinYin.put("-15110","nin");
ht_PinYin.put("-15109","ning");
ht_PinYin.put("-14941","niu");
ht_PinYin.put("-14937","nong");
ht_PinYin.put("-14933","nu");
ht_PinYin.put("-14930","nv");
ht_PinYin.put("-14929","nuan");
ht_PinYin.put("-14928","nue");
ht_PinYin.put("-14926","nuo");
ht_PinYin.put("-14922","o");
ht_PinYin.put("-14921","ou");
ht_PinYin.put("-14914","pa");
ht_PinYin.put("-14908","pai");
ht_PinYin.put("-14902","pan");
ht_PinYin.put("-14894","pang");
ht_PinYin.put("-14889","pao");
ht_PinYin.put("-14882","pei");
ht_PinYin.put("-14873","pen");
ht_PinYin.put("-14871","peng");
ht_PinYin.put("-14857","pi");
ht_PinYin.put("-14678","pian");
ht_PinYin.put("-14674","piao");
ht_PinYin.put("-14670","pie");
ht_PinYin.put("-14668","pin");
ht_PinYin.put("-14663","ping");
ht_PinYin.put("-14654","po");
ht_PinYin.put("-14645","pu");
ht_PinYin.put("-14630","qi");
ht_PinYin.put("-14594","qia");
ht_PinYin.put("-14429","qian");
ht_PinYin.put("-14407","qiang");
ht_PinYin.put("-14399","qiao");
ht_PinYin.put("-14384","qie");
ht_PinYin.put("-14379","qin");
ht_PinYin.put("-14368","qing");
ht_PinYin.put("-14355","qiong");
ht_PinYin.put("-14353","qiu");
ht_PinYin.put("-14345","qu");
ht_PinYin.put("-14170","quan");
ht_PinYin.put("-14159","que");
ht_PinYin.put("-14151","qun");
ht_PinYin.put("-14149","ran");
ht_PinYin.put("-14145","rang");
ht_PinYin.put("-14140","rao");
ht_PinYin.put("-14137","re");
ht_PinYin.put("-14135","ren");
ht_PinYin.put("-14125","reng");
ht_PinYin.put("-14123","ri");
ht_PinYin.put("-14122","rong");
ht_PinYin.put("-14112","rou");
ht_PinYin.put("-14109","ru");
ht_PinYin.put("-14099","ruan");
ht_PinYin.put("-14097","rui");
ht_PinYin.put("-14094","run");
ht_PinYin.put("-14092","ruo");
ht_PinYin.put("-14090","sa");
ht_PinYin.put("-14087","sai");
ht_PinYin.put("-14083","san");
ht_PinYin.put("-13917","sang");
ht_PinYin.put("-13914","sao");
ht_PinYin.put("-13910","se");
ht_PinYin.put("-13907","sen");
ht_PinYin.put("-13906","seng");
ht_PinYin.put("-13905","sha");
ht_PinYin.put("-13896","shai");
ht_PinYin.put("-13894","shan");
ht_PinYin.put("-13878","shang");
ht_PinYin.put("-13870","shao");
ht_PinYin.put("-13859","she");
ht_PinYin.put("-13847","shen");
ht_PinYin.put("-13831","sheng");
ht_PinYin.put("-13658","shi");
ht_PinYin.put("-13611","shou");
ht_PinYin.put("-13601","shu");
ht_PinYin.put("-13406","shua");
ht_PinYin.put("-13404","shuai");
ht_PinYin.put("-13400","shuan");
ht_PinYin.put("-13398","shuang");
ht_PinYin.put("-13395","shui");
ht_PinYin.put("-13391","shun");
ht_PinYin.put("-13387","shuo");
ht_PinYin.put("-13383","si");
ht_PinYin.put("-13367","song");
ht_PinYin.put("-13359","sou");
ht_PinYin.put("-13356","su");
ht_PinYin.put("-13343","suan");
ht_PinYin.put("-13340","sui");
ht_PinYin.put("-13329","sun");
ht_PinYin.put("-13326","suo");
ht_PinYin.put("-13318","ta");
ht_PinYin.put("-13147","tai");
ht_PinYin.put("-13138","tan");
ht_PinYin.put("-13120","tang");
ht_PinYin.put("-13107","tao");
ht_PinYin.put("-13096","te");
ht_PinYin.put("-13095","teng");
ht_PinYin.put("-13091","ti");
ht_PinYin.put("-13076","tian");
ht_PinYin.put("-13068","tiao");
ht_PinYin.put("-13063","tie");
ht_PinYin.put("-13060","ting");
ht_PinYin.put("-12888","tong");
ht_PinYin.put("-12875","tou");
ht_PinYin.put("-12871","tu");
ht_PinYin.put("-12860","tuan");
ht_PinYin.put("-12858","tui");
ht_PinYin.put("-12852","tun");
ht_PinYin.put("-12849","tuo");
ht_PinYin.put("-12838","wa");
ht_PinYin.put("-12831","wai");
ht_PinYin.put("-12829","wan");
ht_PinYin.put("-12812","wang");
ht_PinYin.put("-12802","wei");
ht_PinYin.put("-12607","wen");
ht_PinYin.put("-12597","weng");
ht_PinYin.put("-12594","wo");
ht_PinYin.put("-12585","wu");
ht_PinYin.put("-12556","xi");
ht_PinYin.put("-12359","xia");
ht_PinYin.put("-12346","xian");
ht_PinYin.put("-12320","xiang");
ht_PinYin.put("-12300","xiao");
ht_PinYin.put("-12120","xie");
ht_PinYin.put("-12099","xin");
ht_PinYin.put("-12089","xing");
ht_PinYin.put("-12074","xiong");
ht_PinYin.put("-12067","xiu");
ht_PinYin.put("-12058","xu");
ht_PinYin.put("-12039","xuan");
ht_PinYin.put("-11867","xue");
ht_PinYin.put("-11861","xun");
ht_PinYin.put("-11847","ya");
ht_PinYin.put("-11831","yan");
ht_PinYin.put("-11798","yang");
ht_PinYin.put("-11781","yao");
ht_PinYin.put("-11604","ye");
ht_PinYin.put("-11589","yi");
ht_PinYin.put("-11536","yin");
ht_PinYin.put("-11358","ying");
ht_PinYin.put("-11340","yo");
ht_PinYin.put("-11339","yong");
ht_PinYin.put("-11324","you");
ht_PinYin.put("-11303","yu");
ht_PinYin.put("-11097","yuan");
ht_PinYin.put("-11077","yue");
ht_PinYin.put("-11067","yun");
ht_PinYin.put("-11055","za");
ht_PinYin.put("-11052","zai");
ht_PinYin.put("-11045","zan");
ht_PinYin.put("-11041","zang");
ht_PinYin.put("-11038","zao");
ht_PinYin.put("-11024","ze");
ht_PinYin.put("-11020","zei");
ht_PinYin.put("-11019","zen");
ht_PinYin.put("-11018","zeng");
ht_PinYin.put("-11014","zha");
ht_PinYin.put("-10838","zhai");
ht_PinYin.put("-10832","zhan");
ht_PinYin.put("-10815","zhang");
ht_PinYin.put("-10800","zhao");
ht_PinYin.put("-10790","zhe");
ht_PinYin.put("-10780","zhen");
ht_PinYin.put("-10764","zheng");
ht_PinYin.put("-10587","zhi");
ht_PinYin.put("-10544","zhong");
ht_PinYin.put("-10533","zhou");
ht_PinYin.put("-10519","zhu");
ht_PinYin.put("-10331","zhua");
ht_PinYin.put("-10329","zhuai");
ht_PinYin.put("-10328","zhuan");
ht_PinYin.put("-10322","zhuang");
ht_PinYin.put("-10315","zhui");
ht_PinYin.put("-10309","zhun");
ht_PinYin.put("-10307","zhuo");
ht_PinYin.put("-10296","zi");
ht_PinYin.put("-10281","zong");
ht_PinYin.put("-10274","zou");
ht_PinYin.put("-10270","zu");
ht_PinYin.put("-10262","zuan");
ht_PinYin.put("-10260","zui");
ht_PinYin.put("-10256","zun");
ht_PinYin.put("-10254","zuo");
ht_PinYin.put("-10247","zz");
}
} // end class
----------------------------------------------------------
