python连接mysql数据库案例（Python经典编程案例）

梦里梦外; 2023-07-03 02:55 8阅读 0赞

import logging
    import pymysql
    
    class MySQLCommand(object):
        def __init__(self,host,port,user,passwd,db,table):
            self.host = host
            self.port = port
            self.user = user
            self.password = passwd
            self.db = db
            self.table = table
    
        def connectMysql(self):
            try:
                self.conn = pymysql.connect(host=self.host,port=self.port,user=self.user,passwd=self.password,db=self.db,charset='utf8')
                self.cursor = self.conn.cursor()
            except:
                print('connect mysql error.')
    
        def queryMysql(self):
            sql = "SELECT * FROM " + self.table
    
            try:
                self.cursor.execute(sql)
                row = self.cursor.fetchone()
                print(row)
    
            except:
                print(sql + ' execute failed.')
    
        def insertMysql(self,id,name,sex):
            sql = "INSERT INTO " + self.table + " VALUES(" + id + "," + "'" + name + "'," + "'" + sex + "')"
            try:
                self.cursor.execute(sql)
            except:
                print("insert failed.")
    
        def updateMysqlSN(self,name,sex):
            sql = "UPDATE " + self.table + " SET sex='" + sex + "'" + " WHERE name='" + name + "'"
            print("update sn:" + sql)
    
            try:
                self.cursor.execute(sql)
                self.conn.commit()
            except:
                self.conn.rollback()
    
    
        def closeMysql(self):
            self.cursor.close()
            self.conn.close()