天数:第十一天
时间:2023年12月25日
内容:
第十天到目前天数的json综合练习:(下面是我根据练习自己打的代码)
基础练习1:
写一个数据库程序。可以在里面进行查询已有的信息,如果没有查到,就创一个新的,跟在已有的信息后面
# 目前数据库,也可以自己创建,根据第十天的自律笔记:[{"uname":"zhangsan","ipwd":"123456"},{"uname":"lisi","ipwd":"1234567"},{"uname":"wangwu","ipwd":"123456"},{"uname":"zhaoliu","ipwd":"123456"}]
import json
# 读取json数据库 读取下来的是python版本
def readData():
with open(r"C:\Users\gw\OneDrive\桌面\python\user数据库.txt", "r") as f1:
pythonData = f1.read()
normalData = json.loads(pythonData)
return normalData
#将新内容或者修改的内容写入数据库
def writeData(userlist):
jsonData = json.dumps(userlist) #重点1:写入前要将传入的数据写进一个变量jsonData里面去
with open(r"C:\Users\gw\OneDrive\桌面\python\user数据库.txt", "w") as f2:
f2.write(jsonData)
#将所有注册的会保存下来
def register():
userName = input("输入用户名")
pwd = input("输入密码")
normalData = readData() # 存入所有user在
for s in range(len(normalData)):
if userName != normalData[s]['uname']:
newUser = {'uname': userName, 'ipwd': pwd} #重点2:这里写入的要为字典模式,因为你在写python,转json的时候使用write方法
normalData.append(newUser)
writeData(normalData)
print("注册成功")
return
def login():
while 1 == 1:
userName = input("输入用户名")
pwd = input("输入密码")
pythonData = readData()
msg = "失败"
for s in range(len(pythonData)):
if userName == pythonData[s]["uname"] and pwd == pythonData[s]["ipwd"]:
print("登录成功")
msg = "成功"
if msg == "失败":
print("登录失败")
value = int(input(print("是否选择重新注册 1 / 0")))
if value == 1:
register()
break
else:
continue
return
if __name__ == '__main__':
login()
进阶练习2:写一个记账本程序。记录每次消费的支出和支入。记账的初始值要自己写个程序创建(下面代码我写了,是注释部分),这个一定要会!!!(能巩固json转python,或者是python转json的结构,这个要搞清楚)
这里我用了前面 文件读写\time\datetime\main函数 的点(分别在自律第七,八天)
效果图:
打的码:
# 生成的data。txt:[{"时间": "2023/12/25 15:20:21", "项目": "收到王敏货款", "金额": 20000, "分类": "收入"}, {"时间": "2023/12/25 19:59:41", "项目": "吃饭", "金额": 23.0, "分类": "支出"}, {"时间": "2023/12/25 20:00:12", "项目": "买手机", "金额": 4000.0, "分类": "支出"}, {"时间": "2023/12/25 21:03:32", "项目": "吃饭", "金额": 5.0, "分类": "支出"}, {"时间": "2023/12/25 21:06:07", "项目": "买菜", "金额": 34.0, "分类": "支出"}, {"时间": "2023/12/25 21:06:28", "项目": "发工资", "金额": 23000.0, "分类": "收入"}]
# -*- coding: utf-8 -*-
import json
import time
from datetime import datetime
# 初始数据一定要通过程序写入
# 写入初始数据
# d='[{"时间": "2023/12/25 15:20:21", "项目": "收到王敏货款", "金额": 20000, "分类": "收入"}, {"时间": "2023/12/25 19:59:41", "项目": "吃饭", "金额": 23.0, "分类": "支出"}, {"时间": "2023/12/25 20:00:12", "项目": "买手机", "金额": 4000.0, "分类": "支出"}, {"时间": "2023/12/25 21:03:32", "项目": "吃饭", "金额": 5.0, "分类": "支出"}, {"时间": "2023/12/25 21:06:07", "项目": "买菜", "金额": 34.0, "分类": "支出"}, {"时间": "2023/12/25 21:06:28", "项目": "发工资", "金额": 23000.0, "分类": "收入"}]'
# jsonData1 = json.loads(d) #先把str数据转为字典类型
# jsonData2 = json.dumps(jsonData1,ensure_ascii=False) #把字典类型转为json类型(每一步写入json,都要这么做)
# with open(r"C:\Users\gw\OneDrive\桌面\python\data.txt","w") as f:
# data = f.write(jsonData2)
#
#读json数据
def readData():
with open(r"C:\Users\gw\OneDrive\桌面\python\data.txt","r") as f1:
readDatas = f1.read()
pythonData = json.loads(readDatas)
return pythonData
#写入python数据
def writeData(bills):
bill = json.dumps(bills, ensure_ascii=False) # ensure_ascii=False可以让中文出入,不会对中文进行ascii编码
with open(r"C:\Users\gw\OneDrive\桌面\python\data.txt","w") as f2:
f2.write(bill)
print("------数据写入成功!")
# 里面要有个分辨,一个是支出,另外一个是支入
def showData():
dataList = readData()
sumIn = 0
sumOut = 0
for s in dataList:
if s["分类"] == "支出":
sumOut+=s["金额"]
print(s["时间"], " ", s["项目"], " ", s["金额"] * -1)
else:
sumIn += s["金额"]
print(s["时间"], " ", s["项目"], " ", s["金额"])
print("**************************************************************")
print("**总收入:", sumIn, "元,总开支:", sumOut, "元,结余:", sumIn - sumOut, "元!")
def addData():
dataList = readData()
content = input("请输入账单明细:(例:今天做了啥)")
amount = float(input("请输入账单金额:(单位:元)"))
c=int(input("请选择(1.收入 2.支出):"))
cla = "支出"
if c == 1: #实现支入和支出切换
cla = "支入"
t = datetime.now().strftime("%Y-%m-%d --------%H:%M:%S") #为了区别是否成功写入,格式与一开始写入的不同
newData = {"时间": t, "项目": content, "金额": amount, "分类": cla}
dataList.append(newData)
writeData(dataList)
if __name__ == '__main__':
while 1 ==1:
showData()
c = int(input("=====增加账目请输入:1:"))
if c == 1:
addData()
time.sleep(2)
print("\n")