poi读取xls文件内容并存入数据库

String lujing = servletRequest.getParameter("lujing");
  System.out.println("lujing==="+lujing);
  String fileToBeRead = lujing;
  System.out.println(System.getProperty("user.dir"));

  HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(
    fileToBeRead));
  HSSFSheet sheet = workbook.getSheet("Sheet1");
  int rows = sheet.getPhysicalNumberOfRows();// 行数

  Statement stmt = null;
  Connection conn = DBConn.getConnection();
  try {
   stmt = conn.createStatement();
   for (int r = 0; r < 232; r++) {
    HSSFRow row = sheet.getRow(r);
    if (row != null) {
     int cells = row.getLastCellNum();
     // 每行单元格数
     String[] value = new String[cells];
     System.out.println("总行数：" + rows);
     System.out.println("此行单元格数：" + cells);
     String num = "";
     for (short c = 0; c < cells; c++) {
      HSSFCell cell = row.getCell(c);// 单元格
      
      if (cell != null) {
       switch (cell.getCellType()) {
       
       case HSSFCell.CELL_TYPE_FORMULA:
        //  
        break;
       case HSSFCell.CELL_TYPE_NUMERIC:
        value[c] += (long) cell.getNumericCellValue()
          + "/t";
        break;
       case HSSFCell.CELL_TYPE_STRING:
        value[c] += cell.getStringCellValue() + "/t";
        break;
       default:
        value[c] += "/t";
       }
       if (value[c] != null) {
        value[c] = value[c].substring(4).trim();
        if (value[c].indexOf(" ") > 0)
         value[c] = value[c].substring(0, value[c]
           .indexOf(" ") - 1);   
       }
      }
      if (value[c]==null){
       value[c] = " ";}
//      int k = c + 1;
     }
     // 下面可以将查找到的行内容用SQL语句INSERT到sqlserver数据库
     String lin=value[1]+"##"+value[2]+"##"+value[3]+"##"+value[4];
      String
      sql="insert into ex_question(Q_CLASS,Q_KNOWLEDGE,Q_VALUE,Q_TYPE,Q_DIFFICULTY,Q_CONTENT,Q_ANSWER,Q_STANDARD) values('070','077','5','047','086','"+value[0]+"','"+lin+"','"+value[5]+"')";
      System.out.println("1-2-3-4:"+value[0]+value[1]+value[2]+value[3]+value[4]+value[5]);
      stmt.executeUpdate(sql);

    }
   }

  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } finally {
   try {
    stmt.close();
    stmt = null;
   } catch (Exception e) {
   }
   try {
    conn.close();
    conn = null;
   } catch (Exception e) {
   }
  }