tmp5.py 623 B

1234567891011121314151617181920212223
  1. import pymysql
  2. def execSql(host, port, user, password, database,sql):
  3. try:
  4. connection = pymysql.connect(host=host, port=port, user=user, password=password, database=database)
  5. cursor = connection.cursor()
  6. cursor.execute(sql)
  7. result = cursor.fetchall()
  8. cursor.close()
  9. connection.close()
  10. if result:
  11. print(result)
  12. return True
  13. else:
  14. return False
  15. except Exception as e:
  16. print(f"An error occurred: {e}")
  17. return False
  18. print(execSql('172.16.104.106', 3322, 'cs_user', 'ceshimima.1', 'vered_system',""))