一种新的编程思路(中)附:

类别:Java 点击:0 评论:0 推荐:

由于太长:只能这样分开贴

-------------------------------------------------------
核心实现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

     file://process
     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{
   file://begin
     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{
   file://begin
     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)) ;
     } file://for
     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

----------------------------------------------------------

本文地址:http://com.8s8s.com/it/it18277.htm