<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    posts - 165, comments - 198, trackbacks - 0, articles - 1
      BlogJava :: 首頁 :: 新隨筆 :: 聯系 :: 聚合  :: 管理

    mysql 導出文本數據轉換展現格式

    Posted on 2008-07-25 16:39 G_G 閱讀(2159) 評論(0)  編輯  收藏 所屬分類: javaGeneral


    package ?uu;

    import ?java.io.BufferedReader;
    import ?java.io.File;
    import ?java.io.FileInputStream;
    import ?java.io.FileOutputStream;
    import ?java.io.InputStreamReader;
    import ?java.io.OutputStreamWriter;
    import ?java.util.ArrayList;
    import ?java.util.HashMap;
    import ?java.util.List;
    import ?java.util.Map;
    import ?java.util.regex.Pattern;

    public ? class ?MainExc?{
    ????
    // 數據文本?
    ???? static ?String?filePath? = ? " smsservice.data " ;
    ????
    // 輸出文本
    ???? static ?String?outfile? = ? " outfile.html " ;
    ????
    // 輸出?文本格式
    ???? static ?String?charset? = ? " GBK " ;

    ????
    // 數據邏輯?展現
    ???? static ?Map < Pattern,?String > ?map? = ? new ?HashMap < Pattern,?String > ();
    ????
    static ?{
    ????????map.put(Pattern.compile(
    " ^XZT " ),? " sina " );
    ??????? 。。。。。
    ????}

    ????
    // 類型定義
    ???? static ?Map < Pattern,?String > ?maptype? = ? new ?HashMap < Pattern,?String > ();
    ????
    static ?{
    ????????maptype.put(Pattern.compile(
    " ^3P45 " ),? " 客戶端 " );
    ????????maptype.put(Pattern.compile(
    " ^6930 " ),? " 圖表 " );
    ??????? ......

    ????}

    ????
    // 禁止展現
    ???? static ?List < Pattern > ?listNo? = ? new ?ArrayList < Pattern > ();
    ????
    static ?{
    ????????listNo.add(Pattern.compile(
    " ^9588Command$ " ));
    ????????listNo.add(Pattern.compile(
    " ^5kjsCommand$ " ));
    ????????listNo.add(Pattern.compile(
    " ^529901001011021$ " ));
    ????????listNo.add(Pattern.compile(
    " ^529901001011022$ " ));
    ????}

    ????
    ????
    ????
    public ? static ? void ?main(String[]?args)? throws ?Exception?{
    ????????
    // ?read
    ????????InputStreamReader?read? = ? new ?InputStreamReader(
    ????????????????
    new ?FileInputStream(MainExc. class .getClassLoader().getResource(
    ????????????????????????filePath).getPath()),?charset);
    ????????
    ????????
    // ?writer
    ???????? if ?(MainExc. class .getClassLoader().getResource(outfile)? == ? null )?{
    ????????????
    new ?File(MainExc. class .getClassLoader().getResource( " . " ).getPath()
    ????????????????????
    + ? " /outfile.html " ).createNewFile();
    ????????}
    ????????OutputStreamWriter?writer?
    = ? new ?OutputStreamWriter(
    ????????????????
    new ?FileOutputStream(MainExc. class .getClassLoader()
    ????????????????????????.getResource(outfile).getPath()),?charset);
    ????????
    ????????
    // ?內存?裝載?處
    ????????List < Map < String,?String >> ?datas? = ? new ?ArrayList < Map < String,?String >> ();

    ????????
    ????????
    ????????StringBuffer?buffer?
    = ? new ?StringBuffer();
    ????????BufferedReader?reader?
    = ? new ?BufferedReader(read);
    ????????String?stmp?
    = ? null ;
    ????????List
    < String > ?colName? = ? new ?ArrayList < String > ();
    ????????
    // 得到?列名
    ???????? if ?((stmp? = ?reader.readLine())? != ? null ? && ? ! stmp.trim().equals( "" ))?{
    ????????????
    // ?split?-?>?Tab
    ???????????? for ?(String?stmp2?:?stmp.split( " ???? " ))?{
    ????????????????colName.add(stmp2);
    ????????????}
    ????????}
    ????????
    ????????
    // 列數據收集
    ???????? while ?((stmp? = ?reader.readLine())? != ? null ? && ? ! stmp.trim().equals( "" ))?{

    ????????????Map
    < String,?String > ?data? = ? new ?HashMap < String,?String > ();
    ????????????String[]?sdata?
    = ?stmp.split( " ???? " );
    ????????????
    for ?( int ?i? = ? 0 ;?i? < ?colName.size();?i ++ )?{
    ????????????????data.put(colName.get(i),?sdata[i]);
    ????????????}
    ????????????datas.add(data);
    ????????}

    ????????
    ????????
    // ?writer
    ????????writer.append( " <center><table??border>\n " );
    ????????writer.append(
    " <tr> " ? + ? " <td>通道伙伴</td> " ? + ? " <td>指令</td> " ? + ? " <td>長號碼</td> "
    ????????????????
    + ? " <td>資費</td> " ? + ? " <td>業務類型(圖表/客戶端)</td> " ? + ? " </tr>\n " );
    ????????
    // ?通道伙伴?指令?長號碼?資費?業務類型(圖表?客戶端?)
    ????????wfor:? for ?(Map < String,?String > ?mtmp?:?datas)?{

    ????????????
    for ?(Pattern?ptmp?:?listNo)?{
    ????????????????
    if ?(ptmp.matcher(mtmp.get( " command " )).find())?{
    ????????????????????
    continue ?wfor;
    ????????????????}
    ????????????}

    ????????????String?hzhb?
    = ? "" ;

    ????????????
    for ?(Pattern?ptmp?:?map.keySet())?{
    ????????????????
    if ?(ptmp.matcher(mtmp.get( " command " )).find())?{
    ????????????????????hzhb?
    = ?map.get(ptmp);
    ????????????????}
    ????????????}

    ????????????String?type?
    = ? "" ;
    ????????????
    for ?(Pattern?ptmp?:?maptype.keySet())?{
    ????????????????
    if ?(ptmp.matcher(mtmp.get( " command " )).find())?{
    ????????????????????type?
    = ?maptype.get(ptmp);
    ????????????????}
    ????????????}

    ????????????writer.append(
    " <tr> " ? + ? " <td?align='center'> " ? + ?hzhb? + ? " </td> "
    ????????????????????
    + ? " <td?align='center'> " ? + ?mtmp.get( " command " )? + ? " </td> "
    ????????????????????
    + ? " <td?align='center'> " ? + ?mtmp.get( " num " )? + ? " </td> "
    ????????????????????
    + ? " <td?align='center'> " ? + ?mtmp.get( " money " )? + ? " </td> "
    ????????????????????
    + ? " <td?align='center'> " ? + ?type? + ? " </td> " ? + ? " </tr>\n " );
    ????????}
    ????????writer.append(
    " </table></center>\n " );

    ????????
    // ?save?
    ????????writer.flush();
    ????????writer.close();
    ????}

    }

    主站蜘蛛池模板: 亚洲自偷自偷精品| 亚洲国产精品网站在线播放| 五月婷婷免费视频| 久久免费观看国产精品88av| 国产亚洲精品精品国产亚洲综合| 亚洲日韩在线中文字幕综合| 成人永久福利免费观看| 看成年女人免费午夜视频| 免费一级毛片不卡不收费| 免费一级做a爰片久久毛片潮| mm1313亚洲国产精品美女| 亚洲乱码日产精品BD在线观看| 中文字幕在线成人免费看| 亚洲色精品vr一区二区三区| 久久久久久影院久久久久免费精品国产小说 | 亚洲精品av无码喷奶水糖心| 国产真人无遮挡作爱免费视频| 国产亚洲综合久久| 亚洲欧洲无码AV电影在线观看| 精品国产污污免费网站| 亚洲最大在线视频| 国产精品免费看久久久无码| 一级特黄色毛片免费看| 国产hs免费高清在线观看| 永久免费无码日韩视频| 亚洲av一综合av一区| 西西大胆无码视频免费| 男男黄GAY片免费网站WWW| 亚洲午夜福利在线观看| 免费精品国产自产拍在线观看图片| 亚洲人成电影网站色| 午夜免费福利在线| 羞羞视频免费网站在线看| 亚洲国产日韩成人综合天堂| 久久九九全国免费| 亚洲精品免费网站| 亚洲最大激情中文字幕| 成人在线视频免费| 99久久婷婷免费国产综合精品| 97se亚洲国产综合自在线| 亚洲中文字幕在线乱码|