操作mysql

1、建立连接
2、创建游标
3、执行sql
4、获取数据
5、关闭数据库
# coding:utf8
import sys
import os
curPath = os.path.abspath(os.path.dirname(__file__))
rootPath = os.path.split(curPath)[0]
sys.path.append(rootPath)
import pymysql
from config.readConfig import ReadConfig
rc = ReadConfig()

class MyDb:
    global host, user, passwd, port, database
    host = rc.get_database('host')
    port = rc.get_database('port')
    user = rc.get_database('user')
    passwd = rc.get_database('passwd')
    database = rc.get_database('database')

    def __init__(self):
        self.db = None
        self.cur = None

    def get_conn(self):
        try:
            #创建连接
            self.conn = pymysql.connect(host,user,passwd,database,use_unicode=True, charset="utf8")
            #创建cur,操作游标
            self.cur = self.conn.cursor()
            print("连接数据库成功")
        except ConnectionError as ex:
            print(ex)
    def excuteSql(self,sql):
        self.get_conn()
        #sql = sql.decode('utf8')
        #print(sql)
        self.cur.execute(sql)
        self.conn.commit()
        return self.cur

    def get_all(self,cur):
        value = cur.fetchall()
        return value

    def get_one(self, cursor):
        value = cursor.fetchone()
        return value[0]

    def closeDB(self):
        self.conn.close()
        print("数据库关闭！")
if __name__ == '__main__':
    db = MyDb()
    sql = "select schemaname from sys_workspace where name = '0-备LTE测试'"
    cur = db.excuteSql(sql)
    x = db.get_one(cur)
    print(x)
    db.closeDB()

转载于:https://www.cnblogs.com/thcnww/p/8650614.html