# !/usr/bin/env python
#编码:utf8
import MySQLdb
def mysqlconnet ():,,,,
,,,试一试:,,,,,,,,
,,,,,,,conn =, MySQLdb.connect(主机=?27.0.0.1"用户=皌est", passwd=皌est", db=皌est01",端口=3306,charset=皍tf8")
,,,,,,,cur =, conn.cursor ()
,,,except 例外,e:
,,,,,,,print “033年\ [31 m % s \ [0 m", % 033 e
,,,return ,康涅狄格州,坏蛋
def select ():,,,,,,,,
,,,康涅狄格州,坏蛋=mysqlconnet ()
,,,sql =,“select *,得到machineinfo;“,,,, #执行sql语的句
,,,试一试:
,,,,,,,cur.execute (sql),,,,,,,,,,,
,,,,,,,结果=cur.fetchall ()
,,,,,,,for line 拷贝列表(结果):
,,,,,,,,,,,print 线[0],[1]
,,,except 例外,e:
,,,,,,,print “033年\ [31 m % s \ [0 m", % 033 e
,,,cur.close ()
,,,conn.close ()
if __name__ ==, & # 39; __main__ # 39;:
,,,选择()
