python操作資料庫 封裝類

來源:互聯網
上載者:User

標籤:host   int   ret   help   delete   size   cursor   param   ams   

# -*- coding:utf-8 -*-
# Author:Hy
# @Time :2018/2/1610:24
import pymysql


# 封裝類
class MysqlHelp(object):
# 構造
def __init__(self, host, user, passwd, db, port=3306):
self.host = host
self.user = user
self.port = port
self.passwd = passwd
self.db = db

# 建立串連
def open_coon(self):
self.coon = pymysql.connect(host=self.host, port=self.port, user=self.user, passwd=self.passwd, db=self.db)
self.cursor = self.coon.cursor()

# 關閉串連
def close(self):
self.cursor.close()
self.coon.cursor()

# 調用語句
def insert_delete_update(self, sql, params):
try:
self.open_coon()

self.cursor.execute(sql, params=[])
print("OK")
self.coon.commit()

self.close()

except Exception as erorr:
print(erorr)

# 查詢 接收全部的返回結果行

def select_fetchall(self, sql, params=[]):
try:
self.open_coon()

self.cursor.execute(sql, params)

results = self.cursor.fetchall()

self.coon.commit()

self.close()
return results

except Exception as erorr:
print(erorr)

python操作資料庫 封裝類

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.