def query_resource(): # 重构 单查询
conn, cur = mysql_util.get_connect_cursor()
# 获取连接器、游标
sql = "select * from user"
result = mysql_util.execute_query(cur, sql)
# 执行
print(result)
# mysql_util.commit_(conn); # 提交
mysql_util.close_connect_cursor(conn, cur)
def inset_resource():
conn, cur = mysql_util.get_connect_cursor()
#获取连接器、游标
sql = "insert into resource (resource_uri, resource_name, permission) values ('www','wang2', '/baidu')"
mysql_util.execute_insert_update_delete(cur, sql)
#执行
mysql_util.commit_(conn)
#提交
mysql_util.close_connect_cursor(conn, cur)
def query_resource():
conn, cur = mysql_util.get_connect_cursor()
sql = "select * from resource"
result = mysql_util.execute_query(cur, sql)
print(result)
mysql_util.close_connect_cursor(conn, cur)
def inset_resource():
conn, cur = mysql_util.get_connect_cursor()
sql = "insert into resource (resource_uri, resource_name, permission) values ('aa', 'bb', 'cc')"
mysql_util.execute_insert_update_delete(cur, sql)
mysql_util.commit_(conn)
mysql_util.close_connect_cursor(conn, cur)