Python操作MySQL数据库

from pymysql import connect


# ------------------------------------------------------------
# -------------Python操作MySQL数据库，进行正删改查----------------
# ------------------------------------------------------------
class Goods(object):
    def __init__(self):
        # 创建Connection连接
        self.conn = connect(host='localhost', port=3306, user='root',
                            password='spring123', database='test',
                            charset='utf8')
        # 获得Cursor对象
        self.cursor = self.conn.cursor()

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

    def show_all_question(self):
        sql = "select * from question"
        self.excute_sql(sql)

    def show_all_user(self):
        sql = "select * from user"
        self.excute_sql(sql)

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

    def get_info_by_name(self):
        find_name = input("请输入您要查询的用户姓名：")
        sql = " select * from user where name =%s"
        self.cursor.execute(sql, [find_name])
        print(self.cursor.fetchall())

    def excute_many_data(self, sql, vals):
        self.cursor.executemany(sql, vals)
        self.conn.commit()

    def add_user(self):
        name = input("请输入姓名：")
        age = input("请输入年龄：")
        sex = input("请输入性别：")
        hobby = input("请输入爱好：")
        address = input("请输入地址：")
        cardId = input("请输入身份证：")
        segment = input("请输入段位：")
        sql = "insert into user (name,age,sex,hobby,address,cardId,segment) values ('%s','%s','%s','%s','%s','%s','%s')" % (
            name, age, sex, hobby, address, cardId, segment)
        self.cursor.execute(sql)
        self.conn.commit()

    @staticmethod
    def print_menu():
        print("---------打印信息---------")
        return input("请输入功能对应的序号：")

    def run(self):
        while True:
            num = self.print_menu()
            if num == "1":
                # 查询用户信息
                self.show_all_user()
            elif num == "2":
                # 查询试题信息
                self.show_all_question()
            elif num == "3":
                self.add_user()
            elif num == "4":
                self.get_info_by_name()
            else:
                print("输入有误，重新输入...")


def main():
    g = Goods()
    g.run()


if __name__ == '__main__':
    main()