java将excel或txt中的数据导入mysql中

Question

我想用java编程将excel或txt中的数据导入mysql中.请高手给个模板代码吧,我从来没写过,难苦我了.

Answer 1

import java.io.BufferedReader;
import java.io.FileReader;

public class ReadSql {

public String read()throws Exception{
String s="";
String str="";
//路径
BufferedReader reader=new BufferedReader(new FileReader("d:\\eclipse\\eclipse\\workspace\\java_property\\src\\Example.java"));
//逐行读
while((s = reader.readLine()) != null){
//拼接字符成字符串
str+=s+"!";
}
System.out.println(str);
return str;
}
public int spliteTo(String str){
//拆分
String[]strs=str.split("!");
System.out.println("ok");
int j=0,k=0;
int count=0;
for(int i=0;i<strs.length;i++){
if((j=strs[i].indexOf("public"))!=-1&&(k=strs[i].indexOf("("))!=-1){
String s=strs[i].substring(j+1, k);
String[] st=s.split(" ");
System.out.println(st.length);
if(st.length>2){
count++;
}
}

}

return count;
}
public static void main(String[] args) {
ReadSql rs=new ReadSql();
String[] strs=null;
int i=0;
try {
i = rs.spliteTo(rs.read());
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

System.out.println(i);

}
}
简单的。

package com.excel.excel;

import java.io.File;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import jxl.Workbook;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class PersonExcel {
public String expordExcel(OutputStream os, List<List> list)throws Exception {

WritableWorkbook wbook = Workbook.createWorkbook(os); // 建立excel文件
//String tmptitle = "考试成绩"; // 标题
WritableSheet wsheet = wbook.createSheet("第一页", 0); // sheet名称
// 设置excel标题
WritableFont wfont = new WritableFont(WritableFont.ARIAL, 16,
WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,
Colour.BLACK);
WritableCellFormat wcfFC = new WritableCellFormat(wfont);
wsheet.addCell(new Label(1, 0, "", wcfFC));//tmptitle
wfont = new jxl.write.WritableFont(WritableFont.ARIAL, 14,
WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,
Colour.BLACK);
wcfFC = new WritableCellFormat(wfont);
// 开始生成主体内容
for(int k=0;k<list.get(0).size();k++){
wsheet.addCell(new Label(k, 1, (String)list.get(0).get(k)));
}
for (int i = 0; i < list.size()-1; i++)
for(int j=0;j<list.get(i).size();j++){
wsheet.addCell(new Label(j, i+2, (String)(list.get(i+1)).get(j)));

}
// 主体内容生成结束
wbook.write(); // 写入文件
wbook.close();
os.close();
return "success";
}

}
excel的，这个是以前用过的，读文件也和这个类似！

Answer 2

哦

Answer 3

可以考虑用POI来实现