参数为两个数组的批量插入数据 该怎么写

  //js
        var productcode = shuzu.join(",");
        var covertypecode = typeshuzu.join(",");            
        /*console.log(productcode);
        console.log(covertypecode); */      
        $.ajax({
            type:"post",
            url:"product/addproType.do",
            data:{productCode:productcode,coverTypeCode:covertypecode},
            dataType:"json",
            success:function(result){
                if(result.success){             
                    alert(1);
                }else{
                    alert("添加失败");      
                };
            }           
        });
        //方法
        //添加商品到类别 
public TableJson saveProType(String productCode,String coverTypeCode){
    TableJson json = new TableJson();
     String sql = "INSERT INTO `product_cover_type_ref`(product_code,cover_type_code)VALUES(?,?)";

     final String [] proItems = productCode.split(",");
     final String [] coverTypeItems= coverTypeCode.split(",");
    pcTypeDao.getJdbcTemplate().batchUpdate(sql,new BatchPreparedStatementSetter() {
        String proCode;
        String coverTypeCode;
        //绑定插入的参数
        @Override
        public void setValues(PreparedStatement ps, int index) throws SQLException {
            // TODO Auto-generated method stub
            proCode =proItems[index];
            coverTypeCode=coverTypeItems[index];
            ps.setString(1,proCode);
            ps.setString(2,coverTypeCode);
        }
        //指定该批的记录
        @Override
        public int getBatchSize() {
            // TODO Auto-generated method stub
            return proItems.length;
        }
    });     
    return json;
}

写了下jdbc的批量插入 两个数组真是不知道怎么操作了

用事务+循环，
for (item : proItems)
...