扫描二维码下载沐宇APP

沐宇

微信扫码使用沐宇小程序

沐宇

python鍙嶅簭鍒楀寲鏂规硶鎬庝箞搴旂敤

扬州沐宇科技
2023-08-18 11:15:06
python

Python涓殑鍙嶅簭鍒楀寲鏂规硶鍙互搴旂敤浜庡绉嶅満鏅紝渚嬪锛?/p>

  1. 浠庢枃浠朵腑璇诲彇搴忓垪鍖栫殑瀵硅薄锛氫娇鐢?code>pickle妯″潡鐨?code>load()鏂规硶锛屽彲浠ュ皢鏂囦欢涓簭鍒楀寲鐨勫璞″姞杞戒负Python瀵硅薄锛岀劧鍚庡彲浠ュ湪绋嬪簭涓娇鐢ㄥ畠浠€?/li>
import pickle
# 浠庢枃浠朵腑璇诲彇搴忓垪鍖栫殑瀵硅薄
with open('data.pickle', 'rb') as file:
data = pickle.load(file)
# 浣跨敤鍙嶅簭鍒楀寲鐨勫璞?/span>
print(data)
  1. 閫氳繃缃戠粶浼犺緭鐨勬暟鎹細浣跨敤pickle妯″潡鐨?code>loads()鏂规硶锛屽彲浠ュ皢缃戠粶浼犺緭涓殑搴忓垪鍖栧璞¤浆鎹负Python瀵硅薄锛岀劧鍚庡彲浠ュ鍏惰繘琛屾搷浣溿€?/li>
import pickle
# 閫氳繃缃戠粶浼犺緭鐨勫簭鍒楀寲鏁版嵁
data = b'\x80\x04\x95\x14\x00\x00\x00\x00\x00\x00\x00\x8c\x0fHello, World!\x94.'
# 鍙嶅簭鍒楀寲鏁版嵁
obj = pickle.loads(data)
# 浣跨敤鍙嶅簭鍒楀寲鐨勫璞?/span>
print(obj)
  1. 鏁版嵁搴撲氦浜掞細鏈変簺鏁版嵁搴撴敮鎸佸皢Python瀵硅薄鐩存帴搴忓垪鍖栦繚瀛橈紝渚嬪SQLite涓殑BLOB绫诲瀷銆傚彲浠ヤ娇鐢?code>pickle妯″潡灏嗗璞″簭鍒楀寲涓轰簩杩涘埗鏁版嵁锛岀劧鍚庝繚瀛樺埌鏁版嵁搴撲腑锛屽啀浠庢暟鎹簱涓鍙栧嚭鏉ユ椂杩涜鍙嶅簭鍒楀寲銆?/li>
import sqlite3
import pickle
# 杩炴帴鏁版嵁搴?/span>
conn = sqlite3.connect('data.db')
c = conn.cursor()
# 鍒涘缓琛?/span>
c.execute('''CREATE TABLE IF NOT EXISTS data
(id INTEGER PRIMARY KEY AUTOINCREMENT,
obj BLOB)''')
# 搴忓垪鍖栧璞?/span>
data = pickle.dumps({'name': 'Alice', 'age': 25})
# 鎻掑叆鏁版嵁
c.execute('INSERT INTO data (obj) VALUES (?)', (sqlite3.Binary(data),))
conn.commit()
# 浠庢暟鎹簱涓鍙栨暟鎹?/span>
c.execute('SELECT obj FROM data WHERE id = ?', (1,))
row = c.fetchone()
# 鍙嶅簭鍒楀寲鏁版嵁
obj = pickle.loads(row[0])
# 浣跨敤鍙嶅簭鍒楀寲鐨勫璞?/span>
print(obj)
# 鍏抽棴鏁版嵁搴撹繛鎺?/span>
conn.close()

杩欎簺鏄弽搴忓垪鍖栨柟娉曞湪涓嶅悓鍦烘櫙涓嬬殑搴旂敤绀轰緥锛屽彲浠ユ牴鎹叿浣撶殑闇€姹傞€夋嫨鍚堥€傜殑鏂规硶杩涜鍙嶅簭鍒楀寲銆?/p>

扫码添加客服微信