java 打出jar包后 读写excel数据源
用java 写了一个通讯录的小程序,数据源是个excel文件,调试时读取添加都可以
但将程序打包成可运行的jar文件时,能读到这个excel文件的数据,但是无法更改
更新操作的代码
public static boolean UpdatePeople(People pe)
{
boolean bFlag = false;
try
{
InputStream is = Main.class.getResourceAsStream(sourcefile);
Workbook wb = Workbook.getWorkbook(is);
OutputStream os = new FileOutputStream(Main.class.getResource(sourcefile).getPath());
WritableWorkbook wwb = Workbook.createWorkbook(os,wb);
wb.close();
WritableSheet wws = wwb.getSheet(0);
int Row = pe.iRow;
wws.addCell(new Label(0,Row,String.valueOf(pe.iRow)));
wws.addCell(new Label(1,Row,pe.name));
wws.addCell(new Label(2,Row,pe.mobileTelePhone));
wws.addCell(new Label(3,Row,pe.lineTelePhone));
wws.addCell(new Label(4,Row,pe.qq));
wws.addCell(new Label(5,Row,pe.email));
wws.addCell(new Label(6,Row,pe.address));
wws.addCell(new Label(7,Row,pe.birthday));
wws.addCell(new Label(8,Row,pe.group));
wwb.write();
wwb.close();
bFlag = true;
}
catch(Exception e)
{
e.printStackTrace();
}
return bFlag;
}