jxl导入和导出的excel到数据库

java实现Excel导入导出：

?

?1.数据的导出

?
2.数据的导入
//导入EXCEL   if (f.getName().indexOf(".xls") > 0)   {    try    {     fis= new FileInputStream(f);     BookBean bob= new BookBean();     UserBean usb= new UserBean();     jxl.Workbook rwb= Workbook.getWorkbook(fis);     jxl.Sheet sh= rwb.getSheet(0);     int rowCount= sh.getRows();     SimpleDateFormat sdf= new SimpleDateFormat("dd/MM/yyyy");     book= new Book[rowCount - 1];     for (int i= 1; i < rowCount; i++)     {      book[i - 1]= new Book();      jxl.Cell[] ce= sh.getRow(i);      book[i - 1].setIsbn(ce[0].getContents().toString());      book[i - 1].setSeries(ce[1].getContents().toString());      book[i - 1].setBookTitle(ce[2].getContents().toString());      book[i - 1].setWriter(ce[3].getContents().toString());      book[i - 1].setTranscribe(ce[4].getContents().toString());      book[i - 1].setPublisher(ce[5].getContents().toString());      book[i - 1].setPublishDate(sdf.parse(ce[6].getContents().toString(), new ParsePosition(0)));      book[i-1].setVersion(Integer.parseInt(ce[7].getContents().toString()));      book[i-1].setPage(Integer.parseInt(ce[8].getContents().toString()));      book[i-1].setCls(ce[9].getContents().toString());      book[i-1].setPrecisnotes(ce[10].getContents().toString());      book[i-1].setInstall(ce[11].getContents().toString());      book[i-1].setPrice(Float.parseFloat(ce[12].getContents().toString()));      book[i-1].setUserid(usb.getUser().getUserid());      getVector().addElement(book[i - 1]);     }     rwb.close();     fis.close();    } catch (FileNotFoundException e)    {} catch (BiffException e)    {} catch (IOException e)    {} catch (NumberFormatException e)    {     ShowMessage("数据导入失败，请按照本软件要求的EXCEL格式导入定单");    }   }
?