#! /usr/bin/env python
# -*- coding:utf-8 -*-
# author: xinlan time:2021/4/11 0011
import pymysql
class DBUtil:
def __init__(self,**kwargs):
#获取数据库联接参数
#建立与数据库的联接
#k1=v1,k2=v2,k3=v3
connection = pymysql.connect(**kwargs)
self.cursor = connection.cursor()
user = kwargs.get('user', 'root')
password=kwargs.get('password', '123456')
host = kwargs.get('host', '127.0.0.1')
port = kwargs.get('port',3306)
database = kwargs.get('database','blog_db')
charset = kwargs.get('charset','utf8')
connection = pymysql.connect(user=user,
password = password,
host = host,
port = port,
database = database,
charset = charset)
if connection:
self.cursor = connection.cursor()
else:
raise Exception('数据库连接参数有误!')
def isloginsuccess(self,username,password):
#根据输入的用户名和密码
#判定用户登录是否成功
sql='select count(*) from tb_user'\
'WHERE user_name =%s and user_password=%s'
params=(username,password)
self.cursor.execute(sql,params)
result = self.cursor.fetchone()
if result[0]:
return True
else:
return False
pass
def saveuser(self):
pass
def isloginsuccess(self,username,password):
sql = 'select count(*) from tb_user' \
'WHERE user_name=%s and user_password=%s'
params=(username,password)
self.cursor.execute(sql,params)
result = self.cursor.fetchone()
if result[0]:
return True
else:
return False
#根据输入的用户名和密码
#判定用户登录是否成功
pass
def saveuser(self,username,password,city,avatar):
sql = 'insert into tb_user(user_name,)'
#根据用户输入的信息
#完成用户注册
pass
def getblog(self):
#取出数据库中与博客相关的内容
#并组织成正确的
pass
if __name__=='__main__':
DBUtil()