我想用python存储简单的信息,比如mysql表中的数字。 我将MySQL本地服务器链接到PyCharm,但我不知道如何编写代码来将信息存储在表中。 我在考虑使用一些简单的“if's”并将打印的结果即时存储在某个表中
我该怎么做
谢谢! 首先,如果我能只存储价格,那就太好了。 我的代码:
running = True
while running:
try:
buget = int(input("Money: "))
except ValueError:
print("Please enter your buget using only numbers!")
continue
else:
print("Continue to the next step.")
break
class Cars:
def __init__(self,model,consumption,price,transmision):
self.model = model
self.consumption = consumption
self.price = price
self.transmision = transmision
self.combination = model + " " + price
car_1 = Cars("BMW", "7%", "20000", ["Manual"])
car_2 = Cars("Audi", "8%", "30000 euro", ["Automated"])
car = (car_1, car_2)
for masini in car:
guess = str(input("What car would you like? ").capitalize())
if guess == "Bmw" and buget >= 20000:
print("-----------------")
print(car_1.model)
print(car_1.consumption)
print(car_1.price)
print(",".join(car_1.transmision))
print(car_1.combination)
elif guess == "Audi" and buget >= 30000:
print("-----------------")
print(car_2.model)
print(car_2.consumption)
print(car_2.price)
print(",".join(car_2.transmision))
print(car_2.combination)
elif guess == "Bmw" and buget < 20000:
print("You can't afford this car.")
elif guess == "Audi" and buget < 30000:
print("You can't afford this car.")
elif guess is not "Audi" and buget < 30000:
print("This car doesn't exist!")
elif guess is not "Bmw" and buget < 20000:
print("This car doesn't exist.")
else:
print("This car is unavailable!")
break
首先,你需要一个驱动程序来处理你的连接。一个被广泛使用的是:
MySQLdb
您可以用pip或手动安装它:拥有模块后,可以通过以下方式连接到db:
请确保已使用
import MySQLdb
导入脚本顶部的模块。之后,就可以开始使用数据库了。请参阅非常好的教程here也可以看看here
相关问题 更多 >
编程相关推荐