首頁 > 開發者 > Java

java 讀取csv檔案代碼

來源：互聯網
上載者：User
創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

java 讀取csv檔案代碼<%@ page contenttype="text/html; charset=gb2312" language="java" import="java.sql.*" errorpage="" %>
<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">
<html xmlns="http://www.111cn.net/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312" />
<title>java 讀取csv檔案代碼</title>
</head>

<body>
<%
/*

*/

import java.io.bufferedreader;
import java.io.bufferedwriter;
import java.io.file;
import java.io.filereader;
import java.io.filewriter;
import java.io.ioexception;
import java.text.simpledateformat;
import java.util.arraylist;
import java.util.date;
import java.util.list;
import java.util.stringtokenizer;
import java.util.logging.filehandler;
import java.util.logging.formatter;
import java.util.logging.level;
import java.util.logging.logrecord;
import java.util.logging.logger;

public class inputfile
{
    private static logger getlogger()
    {
        try
        {
            filehandler hand = new filehandler( "c:/test/log.txt" );
            hand.setlevel( level.all );
            logger log = logger.getlogger( "log_file" );
            hand.setformatter( new myloghander() );
            log.addhandler( hand );
            return log;
        }
        catch( exception e )
        {
            e.printstacktrace();
        }
        return null;

    }


    public static list< list< string > > fileinput( file file )
    {
        list< list< string > > listoflist = new arraylist< list< string > >();
        try
        {
            if( file.exists() )
            {
                bufferedreader reader = new bufferedreader( new filereader( file ) );;
                string line;
                line = reader.readline();
                for( ; line != null; line = reader.readline() )
                {
                    stringtokenizer stokenizer = new stringtokenizer( line, " " );
                    list< string > list = new arraylist< string >();
                    while( stokenizer.hasmoreelements() )
                        list.add( stokenizer.nexttoken() );
                    listoflist.add( list );
                }
            }
            else
                getlogger().info( file + " not exist" );

        }
        catch( ioexception e )
        {
            getlogger().info( e.getmessage() );
        }

        return listoflist;
    }


    public static list< list< string > > changevalue( list< list< string > > input, list< list< string > > param )
    {
        for( list< string > list : param )
        {
            int row = integer.parseint( list.get( 0 ) );
            int line = integer.parseint( list.get( 1 ) );
            string value = list.get( 2 );
            input.get( row - 1 ).set( line - 1, value );
        }
        return input;
    }


    public static string fileoutput( list< list< string >> input )
    {
        string string = null;
        for( int i = 0; i < input.size(); i ++ )
        {
            list< string > list = input.get( i );
            for( int j = 0; j < list.size(); j ++ )
            {
                if( j == list.size() - 1 )
                    string += list.get( j ) + "n";
                else
                    string += list.get( j ) + " ";
            }
        }
        return string;
    }


    public static void writefile( string string, string pfad )
    {
        try
        {
            file datafile = new file( pfad );
            bufferedwriter writer = new bufferedwriter( new filewriter( datafile ) );
            writer.write( string );
            writer.close();
        }
        catch( ioexception e )
        {
            getlogger().info( e.getmessage() );
        }
        }


    public static void main( string[] args ) throws ioexception
    {

        file datefile = new file( args[0] );
        file parafile = new file( args[1] );
        list< list< string >> inputfile = inputfile.fileinput( datefile );
        list< list< string >> paramfile = inputfile.fileinput( parafile );
        inputfile = inputfile.changevalue( inputfile, paramfile );
        string string = inputfile.fileoutput( inputfile );
        inputfile.writefile( string, args[2] );
    }
}

class myloghander extends formatter
{
    public string format( logrecord record )
    {
        date date = new date();
        simpledateformat sdf = new simpledateformat( "yyyy/mm/dd hh:mm:ss" );
        return sdf.format( date ) + ":" + record.getmessage() + "n";
    }
}

%>
</body>
</html>

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

聯繫我們

該頁面正文內容均來源於網絡整理，並不代表阿里雲官方的觀點，該頁面所提到的產品和服務也與阿里云無關，如果該頁面內容對您造成了困擾，歡迎寫郵件給我們，收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容，歡迎發送郵件至： info-contact@alibabacloud.com 進行舉報並提供相關證據，工作人員會在 5 個工作天內聯絡您，一經查實，本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More