python与mysql交互

封装   文件名 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