为什么我的代码不能修改Excel文件的每一行呢?请大家帮我看看,谢谢

dragon515 dragon515 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
public CheckbackCopyright(String excelUrl) {
if (this.workbook == null) {
try {
InputStream inputStream = new FileInputStream(excelUrl);
this.workbook = Workbook.getWorkbook(inputStream);
this.excelUrl = excelUrl;
} catch (Exception ex) {
ex.printStackTrace();
}
}
}

// 查询Excel工作表的每一行,并且返回歌手和歌曲
public void getColourringInfo() {
sheet = workbook.getSheet(0);
int rows = sheet.getRows();
int columns = sheet.getColumns();
for (int line = 1; line < rows; line++) {
for (int c = 0; c < columns; c++) {
Cell cell = sheet.getCell(c, line);
if (c == 0)
singer = cell.getContents().trim();
if (c == 1)
song = cell.getContents().trim();
}
executeQuery(line, singer, song);
}
}

// 按歌曲和歌手查询彩铃信息
public void executeQuery(int line, String singer, String song) {
String sql = "select * from COLOURRING where SINGER='" + singer
+ "' and SONG like'" + song + "%' and RING='2'";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
con = DatabaseConnection.getConnection();
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
if (rs.next()) {
addCopyrightAndUsefullife(line,rs.getString(4),rs.getString(5));
} else {
System.out.println(line + "," + singer + "," + song
+ ":没有找到本首彩铃的版权信息");
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DatabaseConnection.close(rs);
DatabaseConnection.close(con, stmt);
}
}

// 更新歌曲列表,即加上所属版权和有限期
public void addCopyrightAndUsefullife(int line, String copyright,
String usefullife) {
try {
WritableWorkbook wwb = Workbook.createWorkbook(new File(excelUrl),workbook);
WritableSheet ws = wwb.getSheet(0);
Label label1 = new Label(3, line, copyright);
ws.addCell(label1);
Label label2 = new Label(4, line, usefullife);
ws.addCell(label2);
wwb.write();
wwb.close();
} catch (IOException ioe) {
ioe.printStackTrace();
} catch (WriteException we) {
we.printStackTrace();
}
}
代码执行后始终只能修改到最后一行,请问是怎么回事,解决了马上给分!
...全文

相关推荐

评论 4
收藏 已收藏
分享
返回顶部
dragon515
Java SE 62,621 成员 307,251 内容