Import java. util .*;
Import java. SQL .*;
Import javax. SQL .*;
Import java. Text .*;
Public class test3 {
Public static hashtable ht = new hashtable (10 );
Public static void main (string [] ARGs) throws exception {
Class. forname ("com. Microsoft. JDBC. sqlserver. sqlserverdriver ");
String url = "xxxxxxxxxx ";
String user = "xxxxxxxxxxxx ";
String Password = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ";
String SQL = "select hid, project_name from newhouse_t ";
Connection conn = drivermanager. getconnection (URL, user, password );
Statement stmt = conn. createstatement ();
Resultset rs = stmt.exe cutequery (SQL );
Vector Vc = new vector ();
While (Rs. Next ()){
Vector VCs = new vector ();
VCs. Add (Rs. getstring ("hid "));
VCs. Add (Rs. getstring ("project_name "));
VC. Add (VCS );
}
For (INT I = 0; I <VC. Size (); I ++ ){
Vector VCR = (vector) VC. Get (I );
String hid = (string) VCR. Get (0 );
String STR = (string) VCR. Get (1 );
STR = Str. substring (0, 1 );
String strresult = C (STR );
If (strresult. Length ()> 1 ){
Strresult = strresult. substring (0, 1 );
}
String sqls = "Update newhouse_t set indexorder = '" + strresult + "'where hid ='" + hid + "'";
Stmt.exe cute (sqls );
}
}
Public static string convert (){
String restr = "";
Return restr;
}
Public static string g (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. Size () = 0) {B ();}
While (! Ht. containskey (integer. tostring (Num) num --;
Return Ht. Get (integer. tostring (Num). tostring ();
}
}
Public static string C (string Str ){
Byte [] bytes = Str. getbytes ();
Short [] Hz = new short [bytes. Length];
For (INT I = 0; I <Hz. length; I ++ ){
If (Bytes [I]> 0 ){
Hz [I] = bytes [I];
} Else {
Hz [I] = (short) (Bytes [I] + 256 );
}
}
Int Len = 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;
}
RET + = g (New INTEGER (p ));
}
Return ret;
}
Public static void B (){
Ht. Put ("-20319", "");
Ht. Put ("-20317", "AI ");
Ht. Put ("-20304", "");
Ht. Put ("-20295", "Ang ");
Ht. Put ("-20292", "Ao ");
Ht. Put ("-20283", "ba ");
Ht. Put ("-20265", "bai ");
Ht. Put ("-20257", "ban ");
Ht. Put ("-20242", "bang ");
Ht. Put ("-20230", "Bao ");
Ht. Put ("-20051", "Bei ");
Ht. Put ("-20036", "Ben ");
Ht. Put ("-20032", "Beng ");
Ht. Put ("-20026", "bi ");
Ht. Put ("-20002", "Bian ");
Ht. Put ("-19990", "Biao ");
Ht. Put ("-19986", "bie ");
Ht. Put ("-19982", "bin ");
Ht. Put ("-19976", "bing ");
Ht. Put ("-19805", "Bo ");
Ht. Put ("-19784", "bu ");
Ht. Put ("-19775", "ca ");
Ht. Put ("-19774", "Cai ");
Ht. Put ("-19763", "can ");
Ht. Put ("-19756", "Cang ");
Ht. Put ("-19751", "Cao ");
Ht. Put ("-19746", "CE ");
Ht. Put ("-19741", "Ceng ");
Ht. Put ("-19739", "cha ");
Ht. Put ("-19728", "chai ");
Ht. Put ("-19725", "Chan ");
Ht. Put ("-19715", "Chang ");
Ht. Put ("-19540", "Chao ");
Ht. Put ("-19531", "Che ");
Ht. Put ("-19525", "Chen ");
Ht. Put ("-19515", "Cheng ");
Ht. Put ("-19500", "Chi ");
Ht. Put ("-19484", "Chong ");
Ht. Put ("-19479", "Chou ");
Ht. Put ("-19467", "chu ");
Ht. Put ("-19289", "Chuai ");
Ht. Put ("-19288", "Chuan ");
Ht. Put ("-19281", "Chuang ");
Ht. Put ("-19275", "Chui ");
Ht. Put ("-19270", "Chun ");
Ht. Put ("-19263", "Chuo ");
Ht. Put ("-19261", "Ci ");
Ht. Put ("-19249", "Cong ");
Ht. Put ("-19243", "cou ");
Ht. Put ("-19242", "Cu ");
Ht. Put ("-19238", "Cuan ");
Ht. Put ("-19235", "Cui ");
Ht. Put ("-19227", "cun ");
Ht. Put ("-19224", "CuO ");
Ht. Put ("-19218", "da ");
Ht. Put ("-19212", "Dai ");
Ht. Put ("-19038", "Dan ");
Ht. Put ("-19023", "Dang ");
Ht. Put ("-19018", "Dao ");
Ht. Put ("-19006", "de ");
Ht. Put ("-19003", "Deng ");
Ht. Put ("-18996", "Di ");
Ht. Put ("-18977", "Dian ");
Ht. Put ("-18961", "Diao ");
Ht. Put ("-18952", "die ");
Ht. Put ("-18783", "ding ");
Ht. Put ("-18774", "Diu ");
Ht. Put ("-18773", "Dong ");
Ht. Put ("-18763", "dou ");
Ht. Put ("-18756", "Du ");
Ht. Put ("-18741", "Duan ");
Ht. Put ("-18735", "DUI ");
Ht. Put ("-18731", "Dun ");
Ht. Put ("-18722", "duo ");
Ht. Put ("-18710", "E ");
Ht. Put ("-18697", "en ");
Ht. Put ("-18696", "er ");
Ht. Put ("-18526", "Fa ");
Ht. Put ("-18518", "fan ");
Ht. Put ("-18501", "fang ");
Ht. Put ("-18490", "fei ");
Ht. Put ("-18478", "Fen ");
Ht. Put ("-18463", "Feng ");
Ht. Put ("-18448", "FO ");
Ht. Put ("-18447", "fou ");
Ht. Put ("-18446", "Fu ");
Ht. Put ("-18239", "Ga ");
Ht. Put ("-18237", "Gai ");
Ht. Put ("-18231", "Gan ");
Ht. Put ("-18220", "Gang ");
Ht. Put ("-18211", "Gao ");
Ht. Put ("-18201", "Ge ");
Ht. Put ("-18184", "gei ");
Ht. Put ("-18183", "gen ");
Ht. Put ("-18181", "Geng ");
Ht. Put ("-18012", "Gong ");
Ht. Put ("-17997", "gou ");
Ht. Put ("-17988", "Gu ");
Ht. Put ("-17970", "Gua ");
Ht. Put ("-17964", "Guai ");
Ht. Put ("-17961", "Guan ");
Ht. Put ("-17950", "Guang ");
Ht. Put ("-17947", "Gui ");
Ht. Put ("-17931", "gun ");
Ht. Put ("-17928", "Guo ");
Ht. Put ("-17922", "ha ");
Ht. Put ("-17759", "Hai ");
Ht. Put ("-17752", "Han ");
Ht. Put ("-17733", "hang ");
Ht. Put ("-17730", "hao ");
Ht. Put ("-17721", "he ");
Ht. Put ("-17703", "Hei ");
Ht. Put ("-17701", "success ");
Ht. Put ("-17697", "Heng ");
Ht. Put ("-17692", "Hong ");
Ht. Put ("-17683", "Hou ");
Ht. Put ("-17676", "Hu ");
Ht. Put ("-17496", "Hua ");
Ht. Put ("-17487", "Huai ");
Ht. Put ("-17482", "Huan ");
Ht. Put ("-17468", "Huang ");
Ht. Put ("-17454", "Hui ");
Ht. Put ("-17433", "hun ");
Ht. Put ("-17427", "Huo ");
Ht. Put ("-17417", "Ji ");
Ht. Put ("-17202", "Jia ");
Ht. Put ("-17185", "jian ");
Ht. Put ("-16983", "Jiang ");
Ht. Put ("-16970", "Jiao ");
Ht. Put ("-16942", "Jie ");
Ht. Put ("-16915", "Jin ");
Ht. Put ("-16733", "jing ");
Ht. Put ("-16708", "jiong ");
Ht. Put ("-16706", "Jiu ");
Ht. Put ("-16689", "Ju ");
Ht. Put ("-16664", "Juan ");
Ht. Put ("-16657", "Jue ");
Ht. Put ("-16647", "Jun ");
Ht. Put ("-16474", "ka ");
Ht. Put ("-16470", "Kai ");
Ht. Put ("-16465", "kan ");
Ht. Put ("-16459", "Kang ");
Ht. Put ("-16452", "kao ");
Ht. Put ("-16448", "Ke ");
Ht. Put ("-16433", "Ken ");
Ht. Put ("-16429", "Keng ");
Ht. Put ("-16427", "Kong ");
Ht. Put ("-16423", "Kou ");
Ht. Put ("-16419", "ku ");
Ht. Put ("-16412", "Kua ");
Ht. Put ("-16407", "Kuai ");
Ht. Put ("-16403", "Kuan ");
Ht. Put ("-16401", "Kuang ");
Ht. Put ("-16393", "Kui ");
Ht. Put ("-16220", "Kun ");
Ht. Put ("-16216", "Kuo ");
Ht. Put ("-16212", "La ");
Ht. Put ("-16205", "Lai ");
Ht. Put ("-16202", "Lan ");
Ht. Put ("-16187", "Lang ");
Ht. Put ("-16180", "Lao ");
Ht. Put ("-16171", "Le ");
Ht. Put ("-16169", "lei ");
Ht. Put ("-16158", "leng ");
Ht. Put ("-16155", "Li ");
Ht. Put ("-15959", "Lia ");
Ht. Put ("-15958", "Lian ");
Ht. Put ("-15944", "Liang ");
Ht. Put ("-15933", "liao ");
Ht. Put ("-15920", "lie ");
Ht. Put ("-15915", "Lin ");
Ht. Put ("-15903", "Ling ");
Ht. Put ("-15889", "Liu ");
Ht. Put ("-15878", "long ");
Ht. Put ("-15707", "Lou ");
Ht. Put ("-15701", "Lu ");
Ht. Put ("-15681", "LV ");
Ht. Put ("-15667", "Luan ");
Ht. Put ("-15661", "Lue ");
Ht. Put ("-15659", "Lun ");
Ht. Put ("-15652", "Luo ");
Ht. Put ("-15640", "Ma ");
Ht. Put ("-15631", "Mai ");
Ht. Put ("-15625", "man ");
Ht. Put ("-15454", "mang ");
Ht. Put ("-15448", "Mao ");
Ht. Put ("-15436", "me ");
Ht. Put ("-15435", "Mei ");
Ht. Put ("-15419", "men ");
Ht. Put ("-15416", "Meng ");
Ht. Put ("-15408", "mi ");
Ht. Put ("-15394", "Mian ");
Ht. Put ("-15385", "Miao ");
Ht. Put ("-15377", "Mie ");
Ht. Put ("-15375", "min ");
Ht. Put ("-15369", "Ming ");
Ht. Put ("-15363", "Miu ");
Ht. Put ("-15362", "Mo ");
Ht. Put ("-15183", "MOU ");
Ht. Put ("-15180", "Mu ");
Ht. Put ("-15165", "Na ");
Ht. Put ("-15158", "Nai ");
Ht. Put ("-15153", "Nan ");
Ht. Put ("-15150", "Nang ");
Ht. Put ("-15149", "Nao ");
Ht. Put ("-15144", "ne ");
Ht. Put ("-15143", "Nei ");
Ht. Put ("-15141", "Nen ");
Ht. Put ("-15140", "Neng ");
Ht. Put ("-15139", "Ni ");
Ht. Put ("-15128", "Nian ");
Ht. Put ("-15121", "Niang ");
Ht. Put ("-15119", "niao ");
Ht. Put ("-15117", "Nie ");
Ht. Put ("-15110", "Nin ");
Ht. Put ("-15109", "Ning ");
Ht. Put ("-14941", "niu ");
Ht. Put ("-14937", "Nong ");
Ht. Put ("-14933", "Nu ");
Ht. Put ("-14930", "NV ");
Ht. Put ("-14929", "Nuan ");
Ht. Put ("-14928", "nue ");
Ht. Put ("-14926", "nuo ");
Ht. Put ("-14922", "O ");
Ht. Put ("-14921", "ou ");
Ht. Put ("-14914", "Pa ");
Ht. Put ("-14908", "Pai ");
Ht. Put ("-14902", "pan ");
Ht. Put ("-14894", "Pang ");
Ht. Put ("-14889", "pao ");
Ht. Put ("-14882", "Pei ");
Ht. Put ("-14873", "pen ");
Ht. Put ("-14871", "peng ");
Ht. Put ("-14857", "Pi ");
Ht. Put ("-14678", "pian ");
Ht. Put ("-14674", "Piao ");
Ht. Put ("-14670", "pie ");
Ht. Put ("-14668", "pin ");
Ht. Put ("-14663", "ping ");
Ht. Put ("-14654", "po ");
Ht. Put ("-14645", "Pu ");
Ht. Put ("-14630", "Qi ");
Ht. Put ("-14594", "QIA ");
Ht. Put ("-14429", "Qian ");
Ht. Put ("-14407", "Qiang ");
Ht. Put ("-14399", "Qiao ");
Ht. Put ("-14384", "Qie ");
Ht. Put ("-14379", "Qin ");
Ht. Put ("-14368", "Qing ");
Ht. Put ("-14355", "Qiong ");
Ht. Put ("-14353", "Qiu ");
Ht. Put ("-14345", "Qu ");
Ht. Put ("-14170", "Quan ");
Ht. Put ("-14159", "que ");
Ht. Put ("-14151", "Qun ");
Ht. Put ("-14149", "ran ");
Ht. Put ("-14145", "rang ");
Ht. Put ("-14140", "Rao ");
Ht. Put ("-14137", "re ");
Ht. Put ("-14135", "Ren ");
Ht. Put ("-14125", "reng ");
Ht. Put ("-14123", "Ri ");
Ht. Put ("-14122", "rong ");
Ht. Put ("-14112", "Rou ");
Ht. Put ("-14109", "Ru ");
Ht. Put ("-14099", "Ruan ");
Ht. Put ("-14097", "Rui ");
Ht. Put ("-14094", "run ");
Ht. Put ("-14092", "RuO ");
Ht. Put ("-14090", "sa ");
Ht. Put ("-14087", "sai ");
Ht. Put ("-14083", "San ");
Ht. Put ("-13917", "sang ");
Ht. Put ("-13914", "Sao ");
Ht. Put ("-13910", "se ");
Ht. Put ("-13907", "Sen ");
Ht. Put ("-13906", "Seng ");
Ht. Put ("-13905", "Sha ");
Ht. Put ("-13896", "Shai ");
Ht. Put ("-13894", "Shan ");
Ht. Put ("-13878", "Shang ");
Ht. Put ("-13870", "shao ");
Ht. Put ("-13859", "she ");
Ht. Put ("-13847", "shen ");
Ht. Put ("-13831", "Sheng ");
Ht. Put ("-13658", "Shi ");
Ht. Put ("-13611", "Shou ");
Ht. Put ("-13601", "Shu ");
Ht. Put ("-13406", "Shua ");
Ht. Put ("-13404", "Shuai ");
Ht. Put ("-13400", "Shuan ");
Ht. Put ("-13398", "Shuang ");
Ht. Put ("-13395", "Shui ");
Ht. Put ("-13391", "Shun ");
Ht. Put ("-13387", "Shuo ");
Ht. Put ("-13383", "Si ");
Ht. Put ("-13367", "Song ");
Ht. Put ("-13359", "Sou ");
Ht. Put ("-13356", "Su ");
Ht. Put ("-13343", "Suan ");
Ht. Put ("-13340", "Sui ");
Ht. Put ("-13329", "Sun ");
Ht. Put ("-13326", "Suo ");
Ht. Put ("-13318", "ta ");
Ht. Put ("-13147", "Tai ");
Ht. Put ("-13138", "Tan ");
Ht. Put ("-13120", "Tang ");
Ht. Put ("-13107", "Tao ");
Ht. Put ("-13096", "te ");
Ht. Put ("-13095", "Teng ");
Ht. Put ("-13091", "ti ");
Ht. Put ("-13076", "Tian ");
Ht. Put ("-13068", "tiao ");
Ht. Put ("-13063", "Tie ");
Ht. Put ("-13060", "ting ");
Ht. Put ("-12888", "tong ");
Ht. Put ("-12875", "TOU ");
Ht. Put ("-12871", "tu ");
Ht. Put ("-12860", "tuan ");
Ht. Put ("-12858", "Tui ");
Ht. Put ("-12852", "tun ");
Ht. Put ("-12849", "Tuo ");
Ht. Put ("-12838", "wa ");
Ht. Put ("-12831", "Wai ");
Ht. Put ("-12829", "Wan ");
Ht. Put ("-12812", "Wang ");
Ht. Put ("-12802", "wei ");
Ht. Put ("-12607", "Wen ");
Ht. Put ("-12597", "Weng ");
Ht. Put ("-12594", "wo ");
Ht. Put ("-12585", "Wu ");
Ht. Put ("-12556", "Xi ");
Ht. Put ("-12359", "xia ");
Ht. Put ("-12346", "Xian ");
Ht. Put ("-12320", "Xiang ");
Ht. Put ("-12300", "Xiao ");
Ht. Put ("-12120", "xie ");
Ht. Put ("-12099", "Xin ");
Ht. Put ("-12089", "Xing ");
Ht. Put ("-12074", "Xiong ");
Ht. Put ("-12067", "Xiu ");
Ht. Put ("-12058", "Xu ");
Ht. Put ("-12039", "Xuan ");
Ht. Put ("-11867", "Xue ");
Ht. Put ("-11861", "Xun ");
Ht. Put ("-11847", "ya ");
Ht. Put ("-11831", "Yan ");
Ht. Put ("-11798", "Yang ");
Ht. Put ("-11781", "Yao ");
Ht. Put ("-11604", "Ye ");
Ht. Put ("-11589", "Yi ");
Ht. Put ("-11536", "Yin ");
Ht. Put ("-11358", "ying ");
Ht. Put ("-11340", "yo ");
Ht. Put ("-11339", "Yong ");
Ht. Put ("-11324", "you ");
Ht. Put ("-11303", "Yu ");
Ht. Put ("-11097", "Yuan ");
Ht. Put ("-11077", "Yue ");
Ht. Put ("-11067", "Yun ");
Ht. Put ("-11055", "za ");
Ht. Put ("-11052", "Zai ");
Ht. Put ("-11045", "Zan ");
Ht. Put ("-11041", "Zang ");
Ht. Put ("-11038", "Zao ");
Ht. Put ("-11024", "ze ");
Ht. Put ("-11020", "Zei ");
Ht. Put ("-11019", "Zen ");
Ht. Put ("-11018", "Zeng ");
Ht. Put ("-11014", "Zha ");
Ht. Put ("-10838", "Zhai ");
Ht. Put ("-10832", "Zhan ");
Ht. Put ("-10815", "Zhang ");
Ht. Put ("-10800", "Zhao ");
Ht. Put ("-10790", "zhe ");
Ht. Put ("-10780", "Zhen ");
Ht. Put ("-10764", "Zheng ");
Ht. Put ("-10587", "Zhi ");
Ht. Put ("-10544", "Zhong ");
Ht. Put ("-10533", "Zhou ");
Ht. Put ("-10519", "zhu ");
Ht. Put ("-10331", "zhua ");
Ht. Put ("-10329", "zhuai ");
Ht. Put ("-10328", "Zhuan ");
Ht. Put ("-10322", "Zhuang ");
Ht. Put ("-10315", "Zhui ");
Ht. Put ("-10309", "Zhun ");
Ht. Put ("-10307", "Zhuo ");
Ht. Put ("-10296", "zi ");
Ht. Put ("-10281", "Zong ");
Ht. Put ("-10274", "zou ");
Ht. Put ("-10270", "Zu ");
Ht. Put ("-10262", "Zuan ");
Ht. Put ("-10260", "Zui ");
Ht. Put ("-10256", "Zun ");
Ht. Put ("-10254", "Zuo ");
Ht. Put ("-10247", "ZZ ");
}
}