get rowcount
fix rowcount when DELETE
remove temp variable
retun result as list of tuple
rollback only while connection keeping