python连接数据库

python连接数据库实例

# encoding: utf-8
import MySQLdb

#数据库连接实现类
class DbConnection(object):
    def __init__(self):
        # 当前类的实例
        self.conn = None

    def open(self):
        child = type(self)  # child  --->  <class '__main__.DbBi'>
        print child
        if self.conn is None:
            self.conn = MySQLdb.connect(
                host=child.host,
                port=child.port,
                user=child.user,
                passwd=child.passwd,
                db=child.db,
                charset="utf8"
            )
            return self.conn


class DbBi(DbConnection):
    host = '127.0.0.1'
    port = 3306
    user = 'root'
    passwd = '123456'
    db = 'me'


def find_Student():
    # db = MySQLdb.connect('localhost', 'root', '980523', 'me', charset='utf8')
    db = DbBi().open()
    cursor = db.cursor()
    cursor.execute("SET NAMES UTF8")
    sql = """ select * from student ;"""
    cursor.execute(sql)
    print sql
    results = cursor.fetchall()    #  获取所有查询结果
    cursor.close()
    db.close()
    return results


def main():
    data = find_Student()
    # print type(data)   #data 数据类型
    # for i in list(data):
    #     print i
    print str(data).decode('unicode_escape')    # unicode转中文


if __name__ == '__main__':
    main()

python中self 理解    self 即Instance本身。 

Python中规定好了，函数的第一个参数，就必须是实例对象本身，并且建议，约定俗成，把其名字写为self

# encoding: utf-8

class Student(object):
    def __init__(self, name, age):
        self.name = name
        self.age = age

        print ('self: ', self)
        print ('name', self.name)
        print ('type of self: ', type(self))


p = Student('jack', 18)

 运行结果：

最后

以上就是儒雅母鸡为你收集整理的python连接数据库的全部内容，希望文章能够帮你解决python连接数据库所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。