src/com/input/input.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.input;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.util.DBO;
import com.util.StaticMethod;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class input {// excel导入类
	public void daoru(String path, int num) {// 读
																				// excel类
		Workbook book = null;
		Sheet sheet = null;
		
		DBO db=new DBO();//链接数据库
		String sql="";
		String value="";
		String temp="";
		String str="";
		try {
			FileInputStream in = new FileInputStream(path);//开始读入excel

		

			book = Workbook.getWorkbook(in);
		
		
			sheet = book.getSheet(0); //get first sheet.读一个excel sheet页
	
			int cnt = sheet.getRows();
		
			Sheet rs = book.getSheet(0);
			int col = rs.getColumns();
			Cell cell = null;
			for (int i = 1; i < num+2; i++) {//行数增加（即增加数据)
				System.out.print("i="+i);
				value="";
				temp="";
				sql="insert into guzhang(fxrq,czh,cxlc,ch,cc,gzly,fxr,fxbz,xtfl,ws,gzdj,gzms,cljg,clbz,clr,clff,";
				sql+="clrq,lrr,xxff ) values ("; //添加数据库数据
				 System.out.println("sqk="+sql);
				 if(sheet.getCell(1, i).getContents()!=null){
				for (int j = 0; j < 19; j++) {//列数修改
					cell = sheet.getCell(j, i);
					str = "'" + cell.getContents().trim() + "'";

					
					if(cell.getContents()!=null){
						value = value + str + ",";
					//System.out.println("行:"+i+"列:"+j+"<>"+cell.getContents().trim());
					}else{