Dao批处理数据库

<pre name="code" class="java">package domain;public class OrderIterm {private String iid;private int count;/*数量*/private double subtotal;/*小计*/private Order order; /*所属订单 （关联）*/  private Book book;/*订单项所指的商品 （关联）*/public String getIid() {return iid;}public void setIid(String iid) {this.iid = iid;}public int getCount() {return count;}public void setCount(int count) {this.count = count;}public double getSubtotal() {return subtotal;}public void setSubtotal(double subtotal) {this.subtotal = subtotal;}public Order getOrder() {return order;}public void setOrder(Order order) {this.order = order;}public Book getBook() {return book;}public void setBook(Book book) {this.book = book;}}

public void addOrderItermList(List <OrderIterm> orderItermList){/** * 批处理：QueryRunner的batch(String sql,Object [] []params) * params由多个以为数组组成，每个一维数组都与sql在一起执行一次，多个一维数组就执行多次 */try {String sql="insert into orderitem values(?,?,?,?,?)";//把orderItermList转换成二维数组，一个orderIterm是一个一维数组Object [][] params=new Object[orderItermList.size()][];//循环遍历orderItermList，使用每个对象orderIterm为params中的每个一维数组赋值for(int i=0;i< orderItermList.size();i++){OrderIterm iterm=orderItermList.get(i);params[i]=new Object[]{iterm.getIid(),iterm.getCount(),iterm.getSubtotal(),iterm.getOrder().getOid(),iterm.getBook().getBid()};}qr.batch(sql, params);} catch (SQLException e) {// TODO Auto-generated catch blockthrow new RuntimeException(e);}}