一,Mapper批量添加sql
<insert id="BatchUpdateinsertInvoiceRreceipt" parameterType="java.util.List" >
insert into invoice_receipt (Monthly_receipt_id,bill_date,branch_no,Customer_Name,Collection_wage,
social_security,Accumulation_fund,Management_expense,Total,Sign,salary_staff,Remarks,salary,Branch_Name,Payroll_sorting)
values <foreach collection="list" item="item" index="index" separator=",">
(#{item.Monthly_receipt_id},#{item.bill_date}, #{item.branch_no} ,#{item.Customer_Name},#{item.Collection_wage},
#{item.social_security},#{item.Accumulation_fund},#{item.Management_expense},#{item.Total},
#{item.Sign},#{item.salary_staff},#{item.Remarks},#{item.salary},#{item.Branch_Name},#{item.Payroll_sorting} )
</foreach>
</insert>
二,DAo部分
int BatchUpdateinsertInvoiceRreceipt(List<InvoiceRreceipt > invoiceRreceipt);
三,service和serviceimpl
int BatchUpdateinsertInvoiceRreceipt(List<InvoiceRreceipt > invoiceRreceipt);
四,serviceimpl实现类我是用json获取内容添加也可以放到list集合也可以看个人需求吧
public List<SpecialTicketDO> selectSpecialTicket() {
List<SpecialTicketDO> specialTicketList=invoiceRreceiptMapper.selectSpecialTicket();
JSONArray json = JSONArray.fromObject(specialTicketList );
System.out.println(json) ; // 得到 每个对象中的属性值
List<SpecialTicketDO> list = new ArrayList<SpecialTicketDO>();
if(json.size()>0){
//循环遍历json
for(int i=0;i<json.size();i++){
JSONObject jsonObject = json.getJSONObject(i); // 遍历 jsonarray 数组,把每一个对象转成 json 对象
SpecialTicketDO da=new SpecialTicketDO();
da.setBranch_Name(jsonObject.get("bank")+"");
da.setBranch_Name(jsonObject.get("branch_Name")+"");
da.setBranch_Name(jsonObject.get("branch_no")+"");
da.setBranch_Name(jsonObject.get("collection_wage")+"");
da.setBranch_Name(jsonObject.get("customer_Name")+"");
da.setBranch_Name(jsonObject.get("invoice_name")+"");
da.setBranch_Name(jsonObject.get("management_expense")+"");
da.setBranch_Name(jsonObject.get("salary")+"");
da.setBranch_Name(jsonObject.get("sign")+"");
da.setBranch_Name(jsonObject.get("social_security")+"");
da.setBranch_Name(jsonObject.get("taxpayer_id_num")+"");
da.setBranch_Name(jsonObject.get("tel")+"");
da.setBranch_Name(jsonObject.get("total")+"");
list.add(da);
// System.out.println(job.get("branch_Name")+"=") ; // 得到 每个对象中的属性值
}
}
return null;
}