sqlite is inserting only last element by python

this is my code in python i want to insert all the result in sqlite3 database but it is inserting only last element in sqlite3 the value of 'r' is an sequence of number and 'resu' is the result by r in text

#!usr/bin/python

from __future__ import print_function
import sqlite3
import os, sys, subprocess
import numpy as np 
from Bio import Entrez
from Bio import Medline

Entrez.email = "shayezkarimcide@gmail.com"

handle = Entrez.esearch(db="pmc", 
                        term = "Antimicrobial resistance",
                        rettype = "medline",retmode = "txt",
                        retmax= '10',sort = "pub date")

result = Entrez.read(handle)

handle.close()

Id = result['IdList']

for r in Id:
    print (r)

print (list(Id), "\n")
print ("The length of PubId is :",len(Id))

handle2 = Entrez.efetch(db="pmc", 
                        id=Id, rettype="medline", 
                        retmode="text")

records = Medline.parse(handle2)

for result in records:
    resul = result['AB']
    res = (resul)

    print (res,'\n')
    print ()

handle2.close()

#######################    Sqlite3 Connect ##################
conn = sqlite3.connect('/home/karim/Desktop/karim')
c = conn.cursor()
print ("Opened database successfully")
example =[(r,res)]
c.executemany('INSERT INTO Entrez(PubId,Abstract)  VALUES 
(?,?)',example)
conn.commit()
print("Records Save Successfully")
conn.close()

how to solve it