index.py 这里只是假设一个模拟登陆

#-*-coding:utf-8-*-"""CreatedonSunNov2718:54:292016这是主程序文件@author:toby"""frommodel.userimportUserdefmain():username="tantianran1"user=User()result=user.Check_Username(username)ifnotresult:print'用户不存在，请重新登录'else:print'登录成功'if__name__=="__main__":main()

user.py

#-*-coding:utf-8-*-"""CreatedonSunNov2719:48:032016对数据库表的处理,py文件名和表名一一对应所以，在这里的user.py文件是对数据库表为user的处理@author:toby"""importsyssys.path.append("/home/toby/workspace/date20161128")fromutility.sql_helperimportMysqlHelperclassUser(object):def__init__(self):self.__helper=MysqlHelper()defGet_data_by_id(self,ids):sql="select*fromuserwhereid=%s"params=(ids,)returnself.__helper.Get_One_Data(sql,params)defCheck_Username(self,name):sql="select*fromuserwherename=%s"params=(name,)returnself.__helper.Get_One_Data(sql,params)'''a=User()printa.Check_Username('tantianran')'''

sql_helper.py

#-*-coding:utf-8-*-"""CreatedonSunNov2718:57:442016数据处理层，处理数据的最底层，例如增删改查的功能@author:toby"""importMySQLdbclassMysqlHelper(object):def__init__(self):hosts,users,password,dbname='127.0.0.1','root','1qaz#EDC','test_db'self.conn=MySQLdb.connect(host=hosts,user=users,passwd=password,db=dbname)self.cur=self.conn.cursor(MySQLdb.cursors.DictCursor)defGet_Dict_data(self,sql,params):self.cur.execute(sql,params)data=self.cur.fetchall()#fetchall()获取所有数据self.cur.close()self.conn.close()returndatadefGet_One_Data(self,sql,params):self.cur.execute(sql,params)data=self.cur.fetchone()#fetchone()是获取一条数据self.cur.close()self.conn.close()returndata