核心方法：

qr.batch(sql, params);// params 是關(guān)鍵 是一個(gè)二維的Object 數(shù)組

代碼的實(shí)現(xiàn)

QueryRunner qr = new QueryRunner(MyDBUtils.getDataSource());

         int [] arr = {1,2,3} ;//要?jiǎng)h除數(shù)據(jù)的id

        String sql = "delete from  employee where id = ?";

        Object[][] params = new Object[arr.length][];// 二維數(shù)組的長(zhǎng)度代表語句執(zhí)行次數(shù)即arr的長(zhǎng)度
//一維數(shù)組中存著參數(shù)值即？的值
//給二維數(shù)組賦值
        for (int i = 0; i < params.length; i++) {
                        //二維數(shù)組的每一項(xiàng)是一個(gè)一緯數(shù)組里面存著？的值
            params[i] = new Object[] { arr[i] };
        }
        qr.batch(sql, params);