<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();
    ????}

    }

    主站蜘蛛池模板: 成人亚洲网站www在线观看| 啦啦啦手机完整免费高清观看| 亚洲国产aⅴ综合网| 亚洲国产精品18久久久久久 | 久久国产乱子精品免费女| 亚洲区不卡顿区在线观看| 一级毛片一级毛片免费毛片| 哒哒哒免费视频观看在线www| 久久精品国产亚洲AV| 日本不卡视频免费| 爱情岛亚洲论坛在线观看 | 久久精品免费全国观看国产| 亚洲精品亚洲人成在线麻豆| 国产精品69白浆在线观看免费| 亚洲三级在线免费观看| 午夜寂寞在线一级观看免费| 豆国产96在线|亚洲| JLZZJLZZ亚洲乱熟无码| 免费一区二区无码东京热| 精品亚洲成AV人在线观看| 青青草a免费线观a| 亚洲精品无码中文久久字幕| 国产91在线免费| 免费一区二区无码东京热| 亚洲国产成人九九综合| 四虎影院免费视频| 美女被爆羞羞网站免费| 亚洲人成图片小说网站| 久久精品一本到99热免费| 亚洲制服丝袜中文字幕| 亚洲 小说区 图片区 都市| A片在线免费观看| 久久综合久久综合亚洲| 免费真实播放国产乱子伦| 免费萌白酱国产一区二区三区| 亚洲女人初试黑人巨高清| 国产精品色午夜免费视频| 中文字幕无码毛片免费看| 色老板亚洲视频免在线观| 亚洲精品综合久久| 无码人妻一区二区三区免费手机 |