python mysql连接函数

def mysqlConnectionSql(sql,value):
	try:
	        conn=MySQLdb.connect(host='127.0.0.1',user='webuser',passwd='yzkj2014',db='cad',port=33070)
		cur=conn.cursor()
		cur.execute(sql,value)
		conn.commit()
		cur.close()
		conn.close()
		print "[Mysql Success] {0},{1}".format(sql,nowString())
	except MySQLdb.Error,e:
		print "[Mysql Error] {0}: {1}".format(e.args[0], e.args[1])
	finally:
		print "[Mysql end] {0},{1}".format(sql,nowString())　　

def nowString():
	return '{0:%Y-%m-%d %H:%M:%S}'.format(datetime.datetime.now())

　　

转载于:https://www.cnblogs.com/songqingbo/p/5729293.html