src/main/java/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 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 readXls(String path,int num){//读 excel类
        Workbook book = null;
        Sheet sheet = null;

        DBO db=new DBO();//链接数据库
        String sql="";
        String value="";
        String temp="";
        String str="";
        ResultSet r=null;
        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="";
                int lla=0,sca=0,sxa=0;
                int a=0;
                int alla=0;
                sql="insert into tushu(tsmc,lx,zz,cbs,js,kc) values ("; //添加数据库数据
                String xssj="";
                if(sheet.getCell(1, i).getContents()!=null){
                    alla=0;
                    for (int j = 0; j < 6; j++) {//列数修改 6    5

                        cell = sheet.getCell(j, i);

                        str = "'" + cell.getContents().trim() + "'";