java读取cvs文件并导入数据库

首先获取文件夹下面的所有类型相同的excel，可以用模糊匹配contains(“匹配字段”)

public static List getDictory(String path) {
		File f = new File(path);
		List<String> dictories = new ArrayList<String>();
		if (!f.exists()) {
			System.out.println(path + "路径不存在");
		} else {
			File fa[] = f.listFiles();
			for (int i = 0; i < fa.length; i++) {
				File fs = fa[i];
				if (!fs.isDirectory() && fs.getName().contains("csv")) {
					dictories.add(path + fs.getName());
				}
			}
			System.out.println(dictories);
		}
		return dictories;
	}

操作jxl类型的excel表格需要导入一个jxl的jar包

private static void getExecl(Statement statement) {
		jxl.Workbook readwb = null;
		try {
			// 构建Workbook对象, 只读Workbook对象
			// 直接从本地文件创建Workbook，根据实际情况更改文件路径
			InputStream instream = new FileInputStream("文件路径");
			readwb = Workbook.ge