一站式网上办事大厅

import sqlite3

# 创建数据库连接

conn = sqlite3.connect('application.db')

cursor = conn.cursor()

# 创建表

cursor.execute('''

CREATE TABLE IF NOT EXISTS applications (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

status TEXT DEFAULT 'pending'

)

''')

# 插入新申请

def submit_application(name):

cursor.execute("INSERT INTO applications (name) VALUES (?)", (name,))

conn.commit()

print(f"Application for {name} submitted successfully.")

# 更新申请状态

def update_status(app_id, new_status):

cursor.execute("UPDATE applications SET status = ? WHERE id = ?", (new_status, app_id))

conn.commit()

print(f"Status updated to {new_status}.")

# 查询所有申请

def view_applications():

cursor.execute("SELECT * FROM applications")

rows = cursor.fetchall()

for row in rows:

print(row)

# 示例使用

submit_application("Alice")

update_status(1, "approved")

view_applications()

# 关闭连接

conn.close()

]]>

访问我们的网站并登录您的账户。

在主页上找到“提交申请”按钮并填写相关信息。

在个人中心查看申请的状态更新。

]]>