那么怎么樣才能讓這個(gè)類更加地面向?qū)ο竽兀?/h1>

字號(hào):

實(shí)例代碼如下:
    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();// 行數(shù)
    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();
    // 每行單元格數(shù)
    String[] value = new String[cells];
    System.out.println("總行數(shù):" + rows);
    System.out.println("此行單元格數(shù):" + 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;
    }
    // 下面可以將查找到的行內(nèi)容用SQL語句INSERT到sqlserver數(shù)據(jù)庫
    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) {
    }
    }