最近学习python,记录下自己写学习python的代码和心得,自己写了一个使用pythonMySQL的查询语句和做的一个db_config.py 配置信息。
1、db_config.py 配置文件
1#/usr/bin/python23classmysql_config():4'''def __init__(self,name):5#PRint 'aaaa'6self.name = name7print name8'''9defget_config(self,name):10self.name =name11config ={12'testdb':{13'host':'192.168.6.6',14'user':'php2',15'passwd':'123456',16'db':'testdb',17'port':3307,18},19}20returnconfig[name]
2、自己封装的mysql 连接class db_mysql 先练练手。
1#/uer/bin/python23importMySQLdb;4fromdb_configimportmysql_config5m_config =mysql_config()6classdb_mysql():7def__init__(self):8print'class:db_mysql -import -true'910defconnect(self,name):11#self.sql = sql12self.name =name13try:14#self.config = m_config.abc(name)15config =m_config.get_config(name)16db = MySQLdb.connect(**config)17cursor =db.cursor()18#cursor.execute(sql)19exceptMySQLdb.connector.Error as err:20print("Something went wrong: {}".format(err))21returncursor2223defexecute(self,cursor,sql):24cursor.execute(sql)25returncursor2627deffetchall(self,cursor):28data =cursor.fetchall()29returndata3031deffetchone(self,cursor):32returncursor.fetchone()
3、测试能否获取到数据。。。。。。。
1#/usr/bin/python/23frommysqlimportdb_mysql4mysql_obj =db_mysql()56sql ="SELECT * FROM test WHERE `p_id` = '1000' LIMIT 10";7cursor_connect = mysql_obj.connect('testdb')8cursor_execute =mysql_obj.execute(cursor_connect,sql)9data =mysql_obj.fetchall(cursor_execute)1011printdata;