java导入excel到数据库

package com.utils;

 

import java.io.File;

import java.util.ArrayList;

import java.util.List;

 

import jxl.Sheet;

import jxl.Workbook;

 

import com.jiumai.shgold.model.aboutas.AboutAs;

 

public class Test {

 

     /**

      * 查询指定目录中电子表格中所有的数据

      * @param file 文件完整路径

      * @return

      */

     public static List<AboutAs> getAllByExcel(String file){

         List<AboutAs> list= new ArrayList<AboutAs>();

         try {

             Workbook rwb=Workbook.getWorkbook( new File(file));

             Sheet rs=rwb.getSheet( 0 );

             int clos=rs.getColumns(); //得到所有的列

             int rows=rs.getRows(); //得到所有的行

             

             System.out.println(clos+ " rows:" +rows);

             for ( int i = 1 ; i < rows; i++) {

                 for ( int j = 0 ; j < clos; j++) {

                     //第一个是列数，第二个是行数

                     String id=rs.getCell(j++, i).getContents(); //默认最左边编号也算一列 所以这里得j++

                     String name=rs.getCell(j++, i).getContents();

                     String sex=rs.getCell(j++, i).getContents();

                     String num=rs.getCell(j++, i).getContents();

                     

                     AboutAs as = new AboutAs();

                     as.setContent(name);

                     list.add(as);

                 }

             }

         } catch (Exception e) {

             // TODO Auto-generated catch block

             e.printStackTrace();

         }

         return list;

         

     }

     

     

     public static void main(String[] args) {

         //得到表格中所有的数据

         List<AboutAs> listExcel=getAllByExcel( "D://test.xls" );

         /*//得到数据库表中所有的数据

         List<StuEntity> listDb=StuService.getAllByDb();*/

         

        

         

         for (AboutAs stuEntity : listExcel) {

             System.out.println(stuEntity.getContent());

         }

     }

}

转载于:https://my.oschina.net/u/2357991/blog/473642