1234567891011121314151617181920212223 |
- import pymysql
- def execSql(host, port, user, password, database,sql):
- try:
- connection = pymysql.connect(host=host, port=port, user=user, password=password, database=database)
- cursor = connection.cursor()
- cursor.execute(sql)
- result = cursor.fetchall()
- cursor.close()
- connection.close()
- if result:
- print(result)
- return True
- else:
- return False
- except Exception as e:
- print(f"An error occurred: {e}")
- return False
- print(execSql('172.16.104.106', 3322, 'cs_user', 'ceshimima.1', 'vered_system',""))
|