数据库字段:VOUCHER_POOL_ID(INTEGER) VOUCHER_NUMBER(VARCHAR2)实体类:
package com.wanda.ccs.schedule.voucher.bean;import java.io.Serializable;public class VoucherPoolBean implements Serializable{
public VoucherPoolBean() {
} private static final long serialVersionUID = 3793712138949820534L;
private Long voucherPoolId;
private String voucherPoolCode; public Long getVoucherPoolId() {
return voucherPoolId;
} public void setVoucherPoolId(Long voucherPoolId) {
this.voucherPoolId = voucherPoolId;
}
public String getVoucherPoolCode() {
return voucherPoolCode;
} public void setVoucherPoolCode(String voucherPoolCode) {
this.voucherPoolCode = voucherPoolCode;
}
}券库ID 券编码 这是excel内容
1 VRR201306030001
2 VRR201306030002
3 VRR201306030003
4 VRR201306030004
5 VRR201306030005
6 VRR201306030006
7 VRR201306030007
8 VRR201306030008
9 VRR201306030009
10 VRR2013060300010
11 VRR2013060300011
12 VRR2013060300012
13 VRR2013060300013
下面是解析excel的方法 :private void resolveExcel() {
File file = new File("E:\\file\\副本voucher_pool_2013-06-04 14_38_22.xls");
ExecuteExcel readExcel = new ExecuteExcel(file);
//打开文件 try {
readExcel.open();
} catch (IOException e) {
e.printStackTrace();
}
readExcel.setSheetNum(0); // 设置读取索引为0的工作表 // 总行数
int count = readExcel.getRowCount();
//循环读取Excel文件中的内容
for (int i = 1; i <= count; i++) {
String[] rows = readExcel.readExcelLine(i);
for (int j = 0; j < rows.length; j++) {
}
}
}
问题:我已经将excel的内容读出来了,问题是,我现在想以一行一行的方式把内容存到数据库对应的字段中去,
就是如何将二维数组的数据set到对应的实体类属性中,然后存储到数据库。感谢给位高手给予解答。
package com.wanda.ccs.schedule.voucher.bean;import java.io.Serializable;public class VoucherPoolBean implements Serializable{
public VoucherPoolBean() {
} private static final long serialVersionUID = 3793712138949820534L;
private Long voucherPoolId;
private String voucherPoolCode; public Long getVoucherPoolId() {
return voucherPoolId;
} public void setVoucherPoolId(Long voucherPoolId) {
this.voucherPoolId = voucherPoolId;
}
public String getVoucherPoolCode() {
return voucherPoolCode;
} public void setVoucherPoolCode(String voucherPoolCode) {
this.voucherPoolCode = voucherPoolCode;
}
}券库ID 券编码 这是excel内容
1 VRR201306030001
2 VRR201306030002
3 VRR201306030003
4 VRR201306030004
5 VRR201306030005
6 VRR201306030006
7 VRR201306030007
8 VRR201306030008
9 VRR201306030009
10 VRR2013060300010
11 VRR2013060300011
12 VRR2013060300012
13 VRR2013060300013
下面是解析excel的方法 :private void resolveExcel() {
File file = new File("E:\\file\\副本voucher_pool_2013-06-04 14_38_22.xls");
ExecuteExcel readExcel = new ExecuteExcel(file);
//打开文件 try {
readExcel.open();
} catch (IOException e) {
e.printStackTrace();
}
readExcel.setSheetNum(0); // 设置读取索引为0的工作表 // 总行数
int count = readExcel.getRowCount();
//循环读取Excel文件中的内容
for (int i = 1; i <= count; i++) {
String[] rows = readExcel.readExcelLine(i);
for (int j = 0; j < rows.length; j++) {
}
}
}
问题:我已经将excel的内容读出来了,问题是,我现在想以一行一行的方式把内容存到数据库对应的字段中去,
就是如何将二维数组的数据set到对应的实体类属性中,然后存储到数据库。感谢给位高手给予解答。
for (int j = 0; j < rows.length; j++) {
VoucherPoolBean vp=new VoucherPoolBean();
vp.setVoucherPoolId(“第1列值”);
vp.setVoucherPoolCode(“第2列值”);
ret.add(vp);
}
下面再从ret中取出存入到数据库
楼上正解 我觉得这里用VoucherPoolBean[] 比用集合更好
VoucherPoolBean[] vpbs = new VoucherPoolBean[readExcel.getRowCount()];