Excel导入MySql(Hibernate+Spring+jxl)

try {

                     Stringsourcefile = "D://klb.xls";

                     InputStreamis = new FileInputStream(sourcefile);

                     jxl.Workbookrwb = Workbook.getWorkbook(is);

                     //获得Sheet 1

                     Sheetsheet = rwb.getSheet(0);

 

                     StringsheetName = sheet.getName();

                     System.out.println(sheetName);

 

                     intsheetColumns = sheet.getColumns();

                     System.out.println("列数" + sheetColumns);

 

                     intsheetRows = sheet.getRows();

                     System.out.println("行数" + sheetRows);

 

                     ApplicationContextcontext = new ClassPathXmlApplicationContext(

                                   "applicationContext.xml");

                     KlServiceImpklservice = (KlServiceImp) context

                                   .getBean("klService");

                     /*

                      * Klb kl=new Klb(); kl.setXh(110);kl.setKl(220);

                      * klservice.save(kl);

                      */

                     for(int i = 0; i < sheetRows; i++) { // i标记当前行数

                            Klbkl = new Klb();

                            for(int j = 0; j < sheetColumns; j++) { // j标记当前列数

                                   Cellcell1 = sheet.getCell(j, i); // 取出j列i行的值

                                   Stringresult = cell1.getContents();

                                   System.out.println(result);

                                   if(j == 0) {

                                          kl.setXh(Integer.parseInt(result));

                                   }

                                   if(j == 1) {

                                          kl.setKl(Integer.parseInt(result));

                                   }

                            }

                            System.out.print("第"+(i+1)+"行");

                            klservice.save(kl);

                     }

              }catch (Exception e) {

                     System.out.println(e);

              }