实例代码如下:
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) {
}
一起交流学习请访问:Tore_m_1206686_21115_1_1.html”>http://www.shangxueba.com/sTore_m_1206686_21115_1_1.html
人生才会更有意义。如果没有梦想,那就托做庸人。