pymysql在调用MySQL静态方法的使用

本次只是使用pymysql在调用MySQL 其中书写了静态方法的使用，本身比较简单，框架很容易。但这个是很经典的代码书写模式，值得多加练习。

from pymysql import connect

class JD(object):
    def __init__(self):
        self.conn = connect(host='192.168.4.2', port=3306, user='sai',
                       password='123456', database='python',
                       charset='utf8')
        self.cursor = self.conn.cursor()

    def show_all_items(self):
        self.cursor.execute("select * from students")
        for i  in self.cursor.fetchall():
            print(i)

    def show_cates(self):
        sql = "select name from students"
        self.cursor.execute(sql)
        print(self.cursor.fetchall())

    def show_brands(self):
        sql = "select id from students"
        self.cursor.execute(sql)
        print(self.cursor.fetchall())

    def __del__(self):
        self.cursor.close()
        self.conn.close()

    @staticmethod
    def print_menu():
        print("------京东商城--------")
        print("1:所有的商品")
        print("2:所有的商品分类")
        print("3:所有的商品品牌分类")
        return input("输入对于的序列号：")

    def run(self):
        while True:
            num = self.print_menu()
            if num == "1":
                self.show_all_items()
            elif num == "2":
                self.show_cates()
            elif num == "3":
                self.show_brands()
            else:
                print("输入有误")

def main():
    jd = JD()
    jd.run()

if __name__ == "__main__":
    main()