首页黑马程序员Python

黑马程序员Python

时间: 2025-01-09 13:54:44 浏览: 52

### 黑马程序员 Python 课程资料教程 #### MySQL数据写入文件操作实例在《黑马程序员Python课程》中提供了丰富的实践案例来帮助学员掌握Python编程技能。对于将MySQL中的数据写入文件这一需求，可以通过定义一个`Record`类并利用该类的方法实现[^1]。 ```python import mysql.connector from data_define import Record def fetch_data_from_mysql(): conn = mysql.connector.connect( host="localhost", user="root", password="password", database="test" ) cursor = conn.cursor() query = "SELECT date, order_id, money, province FROM orders;" cursor.execute(query) records = [] for row in cursor.fetchall(): record = Record(row[0], row[1], row[2], row[3]) records.append(record) cursor.close() conn.close() return records def write_records_to_file(records, filename='output.txt'): with open(filename, 'w', encoding='utf-8') as file: for r in records: line = str(r) + '\n' file.write(line) if __name__ == "__main__": try: fetched_records = fetch_data_from_mysql() write_records_to_file(fetched_records) print("Data has been successfully written into the file.") except Exception as e: print(f"An error occurred: {e}") ``` 此代码片段展示了如何连接至本地运行的一个名为 `test` 的数据库，并从中读取订单表(`orders`)的信息；之后通过创建`Record`对象列表的形式保存这些记录，最后再把这些记录逐条转换成字符串形式存储在一个文本文件当中。

阅读全文