封装 文件名 fz.py
# -*- coding:utf-8 -*-
from MySQLdb import *
class MysqlHelper(object):
def __init__(self, host, port, db, user, passwd, charset="utf8"):
self.host = host
self.port = port
self.db = db
self.user = user
self.passwd = passwd
self.charset = charset
def Open(self):
self.conn = connect(host = self.host, port = self.port, db = self.db, user = self.user, passwd = self.passwd, charset = self.charset)
self.cursor = self.conn.cursor()
def Close(self):
self.cursor.close()
self.conn.close()
def Cud(self, sql, params):
try:
self.Open()
self.cursor.execute(sql, params)
self.conn.commit()
self.Close()
except Exception as e:
print (e.message)
def All(self, sql, params=()):
try:
self.Open()
self.cursor.execute(sql, params)
resule = self.cursor.fetchall()
self.Close()
return resule
except Exception as e:
print (e.message)
插入
from fz import MysqlHelper
name = raw_input("xingmimg:")
id1 = raw_input("id :")
sql = "update students set name=%s where id =%s"
params = [name,id1]
sqlhelp = MysqlHelper('localhost',3306,'python3', 'root', 'helloworld')
sqlhelp.Cud(sql, params)
print "OK"
查询
from fz import MysqlHelper
sql = 'select id,name from students where id <5'
sqlhelp = MysqlHelper('localhost', 3306, 'python3', 'root', 'helloworld')
result = sqlhelp.All(sql)
print result
创建数据库
name =abc
pwd = 123
密码登陆
# -*-coding:utf-8 -*-
from fz import MysqlHelper
from hashlib import sha1
name = raw_input("ming:")
pwd = raw_input("mima :")
s1=sha1()
s1.update(pwd)
pwds = s1.hexdigest()
sql = "select pass from users where name=%s"
helper=MysqlHelper('localhost',3306,'python3','root','helloworld')
result=helper.All(sql, [name])
if len(result)== 0:
print("用户名错误")
elif result[0][0]== pwds:
print("成功登录")
else:
print("密码错误")
#print result