python - 无法在 python 中获取 SQLite 数据库
问题描述
1)我是 python 新手,我正在使用 SQLITE 数据库。在设置连接时,我无法获取数据库(我已经在 SQLite 和表中创建了)
2)执行插入查询时出现以下错误:“sqlite3.OperationalError: no such table: MemberDetails”
这是代码:
import sqlite3
my_cursor = ""
conn = ""
# setting the connection with database
# def con_database_connection():
# try:
globals()
conn = sqlite3.connect('CareForNation.db')
# new_con = sqlite3.connect('CareForNation.db')
print("connection established successfully")
my_cursor = conn.cursor()
# except sqlite3 as error
# print("Connection failed")
# Login Admin Control
user_name = input("Enter user name")
user_password = input("Enter Password")
if user_name == "123" and user_password == "123":
print("Login successful")
else:
print("Invalid user name or password")
# Inserting member information
# con_database_connection()
mid = input("Enter Member ID")
member_name = input("Enter member name")
member_phone_number = input("enter phone number")
member_address = input("Enter address")
insert_data = my_cursor.execute("insert into MemberDetails(Member_ID, Member_Name, Phone_Number, address) "
"values('mid', 'member_name', 'member_phone_number', member_address)")
# abc = conn.executescript("select * from MemberDetails")
print("New data entered to Member details module")
conn.close()
解决方案
首先创建表:
my_cursor.execute("""CREATE TABLE MemberDetails(
mid text,
member_name text,
member_phone_number text,
member_address text
)""")
然后,更换
insert_data = my_cursor.execute("insert into MemberDetails(Member_ID, Member_Name, Phone_Number, address)"
"values('mid', 'member_name', 'member_phone_number', member_address)"
)
和:
with conn:
my_cursor.execute("INSERT INTO MemberDetails VALUES (:mid, :member_name, :member_phone_number, :member_address)",
{'mid': mid, 'member_name': member_name, 'member_phone_number': member_phone_number, 'member_address': member_address})
推荐阅读
- c# - 如何在 DiagnosticAnalyzer 和 CodeFixProvider 中访问 Workspace?(罗斯林)
- google-apps-script - 如何修复谷歌表格中多行、动态、相关下拉列表中的“正在加载...”错误?
- mongodb - 如何在 mongodb 中设置新字段的默认值?
- javascript - How to make Callback run after Promise?
- python - 当我将鼠标悬停在pygame上时,为什么我的按钮不会改变颜色?
- javascript - 将单个 JSON 重构为嵌套数组
- html - CSS布局两列,第二列缩进
- python - 如何在启动 Django 项目时集成 python 脚本以运行
- javascript - 使用 jquery 创建表并选择选项。选项更改时如何隐藏以前的表值?
- python - 修复python中的keyerror