python: 資料庫操作

來源:互聯網
上載者:User

#!/usr/bin/python
# -*- coding: utf-8 -*-

  • 添加標頭檔

import MySQLdb as mdb
import sys,time, datetime

class OperateDbTool(object):

  • 串連資料庫

@staticmethod
def ConnectToDb(host_info):
con = None
host_info_list = host_info.split(',')
if len(host_info_list) == 5:
con = mdb.connect(host=host_info_list[0].strip(), port=int(host_info_list[1].strip()), \
user=host_info_list[2].strip(),\
passwd=host_info_list[3].strip(), db=host_info_list[4].strip())
return con

  • 執行查詢操作

@staticmethod
def ExecutiveDb(con, sql):
rt = None
if con != None:
try:
cur = con.cursor()
cur.execute(sql)
data = cur.fetchone()
#print "data: ", data
return data
except mdb.Error, e:
#print "mdb error: %d: %s" % (e.args[0], e.args[1])
pass
finally:
if con:
con.close()

  • 調用

@staticmethod
def CheckBuyofferRunning(host_info):
con = OperateDbTool.ConnectToDb(host_info)
sql = 'SELECT * FROM table_name WHERE e_info)'
data = OperateDbTool.ExecutiveDb(con, sql)

相關文章

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

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

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