Discuss / Java / 如何从csv文件中读取数据,通过servlet显示在网页上

如何从csv文件中读取数据,通过servlet显示在网页上

ThreshYeah

#1 Created at ... [Delete] [Delete and Lock User]

已经把csv文件中的数据导入到arrylist数组里 如何通过servlet显示在网页上。代码如下

import java.io.BufferedReader;

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import java.io.InputStreamReader;

import java.util.ArrayList;

import java.util.List;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

/**

 * Servlet implementation class MyServlet3

 */

@WebServlet("/ms3")

public class MyServlet3 extends HttpServlet {

private static final long serialVersionUID = 1L;

    /**

     * @see HttpServlet#HttpServlet()

     */

    public MyServlet3() {

        super();

        // TODO Auto-generated constructor stub

    }

    public List<String[]> getCsvData() throws IOException{

    /**

* 读取csv中的数据,形成二维列表,列表中的每项是数组

*/

File file = new File("D:\\Eclipse\\score.csv");

//以行为单位读取

BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream(file), "gbk"));

String line = null;

//记录行号,第一行作为标题行,跳过

boolean firstline = true;

//全部数据读取到data列表中

List<String[]> data = new ArrayList<String[]>();

while((line=br.readLine())!=null) {

if(firstline) {

firstline = false;

continue;

}

//空行跳过

if(line.equals(""))

continue;

String[] array = line.split(",");

//数组长度必须是5

if(array.length!=5) 

continue;

//加入到data

data.add(array);

}

br.close();

return data;

    }

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

//经过程序的处理,组装符合html规范的字符串,返回给浏览器

String html = "";

//返回浏览器之前,需要告知浏览器这些字符串的编码

//国际通用的一个编码: utf-8,   gbk, gb2312

response.setCharacterEncoding("utf-8");

response.getWriter().println(html);

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

doGet(request, response);

}

}

请问doGet内的语句应该如何填写?


  • 1

Reply