案例：京东商城查询

#coding:utf-8
from pymysql import connect


class JD(object):
    def __init__(self):
        # 创建connection连接
        self.conn = connect(host='localhost', port=3306, user='root', password='123456', database='scott', charset='utf8')

        # 获得Cursor对象
        self.cursor = self.conn.cursor()


    def __del__(self):
        # 关闭Cursor对象
        self.cursor.close()
        self.conn.close()

    def execute_sql(self, sql):
        self.cursor.execute(sql)
        for temp in self.cursor.fetchall():
            print(temp)

    def show_all_items(self):
        # 显示所有的商品
        sql = 'select * from goods;'
        self.execute_sql(sql)

    def show_cates(self):
        sql = 'select name from goods_cates;'
        self.execute_sql(sql)

    def show_brands(self):
        sql = 'select name from goods_brands;'
        self.execute_sql(sql)

    def add_brands(self):
        item_name = input('输入新商品分类的名称：')
        sql = '''insert into goods_brands (name) values('%s')''' % item_name
        self.cursor.execute(sql)
        self.conn.commit()
        print('商品名称%s已录入' % item_name)

    @staticmethod
    def print_memu():
        print('----京东----')
        print('1:所有的商品')
        print('2:所有的商品分类')
        print('3:所有的商品品牌分类')
        return input('请输入功能对应的序号：')

    def run(self):
        while True:
            num = self.print_memu()
            if num == '1':
                # 查询所有的商品
                self.show_all_items()
            elif num == '2':
                # 查询分类
                self.show_cates()
            elif num == '3':
                # 查询品牌分类
                self.show_brands()
            elif num == '4':
                # 添加品牌分类
                self.add_brands()
            else:
                print('输入有误，请重新输入...')


def main():
    # 1.创建一个京东商城对象
    jd = JD()

    # 2.调用这个对象的run方法，让其运行
    jd.run()



if __name__ == '__main__':
    main()