获取结果集行数

#!/usr/bin/python3
import xgcondb

conn = xgcondb.connect(host="127.0.0.1", port="5138", database="SYSTEM", user="SYSDBA", password="SYSDBA") 
cur = conn.cursor()

##DDL
## create
cur.execute("CREATE TABLE TAB_ROWCOUNT_TEST(A INT,B VARCHAR, C DATETIME);")
print("CREATE:",cur.rowcount)

##DML
## INSERT
cur.execute("INSERT INTO TAB_ROWCOUNT_TEST VALUES(1,'TA','2019-01-29');")
print("INSERT ONE:",cur.rowcount)
cur.execute("INSERT INTO TAB_ROWCOUNT_TEST VALUES(2,'TB','2019-02-28');")
print("INSERT TWO:",cur.rowcount)
cur.execute("INSERT INTO TAB_ROWCOUNT_TESTVALUES(3,'TC','2019-03-29')(2,'TB','2019-02-28');")
print("INSERT THREE:",cur.rowcount)

## UPDATE
cur.execute("UPDATE TAB_ROWCOUNT_TEST SET B='NN' WHERE A=2;")
print("UPDATE:",cur.rowcount)
## SELECT 
cur.execute("SELECT * FROM TAB_ROWCOUNT_TEST;")
print("SELECT:",cur.rowcount)
## DELETE
cur.execute("DELETE FROM TAB_ROWCOUNT_TEST WHERE A=3;")
print("DELETE:",cur.rowcount)
## drop
cur.execute("DROP TABLE TAB_ROWCOUNT_TEST;")
print("DROP:",cur.rowcount)
conn.close()