#1. ini 配置文件 config.ini
[database]
dservername = 127.0.0.1
userid = root
dpwd = 123456
database = MMember
[link]
url = www.baidu.com
version = 2017.06.01.10.10
e-mail = 192495360@qq.com
#db.py文件代码:
#-*-coding:utf-8-*-
import MySQLdb
import demo_ini
#2.数据库操作类
class DB:
conn=None;#这里的None相当于其它语言的NULL
def __init__(self):#构造函数
self.conn=MySQLdb.connect(host= demo_ini.readConfigFile('database','DServerName'),
user= demo_ini.readConfigFile('database','UserId'),
passwd=demo_ini.readConfigFile('database','DPwd'),
db=demo_ini.readConfigFile('database','Database'),)
#数据库连接,localhost python不认,必须127.0.0.1
def getsinglesBySql(self,sql):
cursor=self.conn.cursor();
result=cursor.fetchmany(cursor.execute(sql))
self.conn.commit()
return result
def getBySql(self,sql,*param):
cursor=self.conn.cursor();#初始化游标
result=cursor.fetchmany(cursor.execute(sql,param))
self.conn.commit()#提交上面的sql语句到数据库执行
return result
def getBySql_result_unique(self,sql,*param):
cursor=self.conn.cursor();#初始化游标
result=cursor.fetchmany(cursor.execute(sql,param))
self.conn.commit()#提交上面的sql语句到数据库执行
return result[0][0];
def setBySql(self,sql,*param):
cursor=self.conn.cursor()#初始化游标
cursor.execute(sql,param)
self.conn.commit()#提交上面的sql语句到数据库执行
def __del__(self):#析构函数
self.conn.close()#关闭数据库连接
#3.数据操作实例py文件:
# -*- coding: UTF-8 -*-
import DB
import datetime
from decimal import Decimal
db = DB.DB()
a = input("请输入会员卡号:".decode("UTF-8").encode("GBK"))
#print a
info = db.getsinglesBySql("select * from t_m_member where vch_memberno like %s order by vch_memberno" %(a))
if len(info)==0:
print "没有你要查询的结果".decode("UTF-8").encode("GBK")
for i in range(0,len(info)):
# print tuple(info[i])
# print info[i]
tranData =[x.strftime('%Y-%m-%d %H:%M:%S') if isinstance(x,datetime.datetime) else float(x) if isinstance(x,Decimal)else (str(x)).decode("UTF-8").encode("GBK") for x in info[i]]
print tranData