java 读取标准sql语句_Java读取Excel文件，生成SQL语句

import jxl.Sheet;

import jxl.Workbook;

import jxl.read.biff.BiffException;

import java.io.*;

public class Main {

public static void main(String[] args) {

Main obj = new Main();

File file = new File("D:\\工作表1.xls");

obj.readExcel(file);

}

// 去读Excel的方法readExcel，该方法的入口参数为一个File对象

public void readExcel(File file) {

try {

// 创建输入流，读取Excel

InputStream is = new FileInputStream(file.getAbsolutePath());

// jxl提供的Workbook类

Workbook wb = Workbook.getWorkbook(is);

// Excel的页签数量

int sheet_size = wb.getNumberOfSheets();

for (int index = 0; index < sheet_size; index++) {

// 每个页签创建一个Sheet对象

Sheet sheet = wb.getSheet(index);

// sheet.getRows()返回该页的总行数

StringBuilder sb = new StringBuilder();

String str1 = "";

String str2 = "";

String str3 = "";

int count = 0;

for (int i = 0; i < sheet.getColumns(); i++) {

// sheet.getColumns()返回该页的总列数

++count;

for (int j = 0; j < sheet.getRows(); j++) {

String cellinfo = sheet.getCell(i, j).getContents();

if (j == 0) {

str1 = cellinfo;

} else if (j == 1) {

str2 = cellinfo;

} else {

str3 = cellinfo;

}

}

sb.append(str1).append(" ").append(str3).append(" ").append("comment").append("'").append(str2).append("'").append(",");

System.out.println(sb.toString());

sb.setLength(0);

str1 = "";

str2 = "";

str3 = "";

}

System.out.println("总字段数："+count);

}

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (BiffException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

}

}

//id int comment'主键id',

//name varchar comment'姓名',

//age int comment'年龄',

//总字段数：3

//总字段数：0

//总字段数：0

注意;jxl只能解析.xls格式的表格

如果字段较多，可以直接生成SQL语句