Question

java把excel文件导入数据库报错！！

public void getDate() {

List liststu = new ArrayList();
// 找到导入的文件
InputStream is = Date.class.getClassLoader().getResourceAsStream(
"N3单词分类表(1).xls");

try {
// 创建工作簿
Workbook wb = Workbook.getWorkbook(is);
// 创建工作表
jxl.Sheet sheet = wb.getSheet(0);
String content = null;
for (int i = 0; i < sheet.getRows(); i++) {
Characters characters = new Characters();
for (int j = 0; j < sheet.getColumns(); j++) {
content = sheet.getCell(j, i).getContents();
System.out.print(content);

if (characters.getId() == 0) {
characters.setId(Integer.parseInt(sheet.getCell(j, i)
.getContents().trim()));
continue;
}
if (characters.getPronunciation() == null) {
characters.setPronunciation(sheet.getCell(j, i)
.getContents());
continue;
}
if (characters.getCharacters() == null) {
characters.setCharacters(sheet.getCell(j, i)
.getContents());
continue;
}

if (characters.getMeaning() == null) {
characters
.setMeaning(sheet.getCell(j, i).getContents());
continue;
}

}
insert(characters);

}

} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();

} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

public void insert(Characters characters) {
String sql = "insert into characters values(" + characters.getId()
+ ",'" + characters.getPronunciation() + "','"
+ characters.getCharacters() + "','" + characters.getMeaning()
+ "')";
ConnCOnnection conn = new ConnCOnnection();
Connection con = conn.getConnect();
try {
Statement state = con.createStatement();
state.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {

try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:468)
at java.lang.Integer.parseInt(Integer.java:497)
at net.company.dao.Date.getDate(Date.java:41)
at net.company.server.ExcelServer.getDate(ExcelServer.java:10)
at net.company.servlet.ExcelServlet.ExcelToMySql(ExcelServlet.java:40)
at net.company.servlet.ExcelServlet.doPost(ExcelServlet.java:33)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

Answer 1

字符串不能软换为数字类型.第一种exel应该有字符串,第二种你在程序中判断下当前要转换的是为空
if (characters.getId() == 0) {
characters.setId(Integer.parseInt(sheet.getCell(j, i).getContents().trim()));
sheet.getCell(j, i).getContents().得到的内容为空,所以会报这个错

Answer 2

你先检查Excel 中id 那一列是否有空值（我觉得这种可能比较大），
如果没有你可以设断点单步调试，看看sheet.getCell(j, i).getContents().trim()的值是否为“”

Answer 3

不知道