连接方法1
#_*_coding:gb2312 _*_
import os
import sys
import MySQLdb
def getdata():
print("getdate")
try:
print("run")
conn = MySQLdb.connect(host='192.168.1.99', user='root', passwd='k123!', db='test', port=3306, charset='utf8')
try:
#cur = conn.cursor()
#sql = "insert into tbl(id,name,pass) values(1,'中文','kling')"
#conn.exceute(sql)
print("运行成功")
#cur.execute(sql)
#allPerson = cur.fetchall()
finally:
#cur.close()
conn.close()
except Exception,e :
print("数据库错误",e)
return
if __name__=='__main__':
getdata()
print(raw_input())
连接方法2
#coding:utf-8
'''
使用utf-8编码
使用adodbapi连接mysql数据库
Created on 2012-9-13
@author: lren
'''
import sys
import MySQLdb
class conmysql:
'''
连接mysql数据库
'''
def __init__(self):
self.connstr="Driver={MySQL ODBC 3.51 Driver};Server=192.168.1.90;Port=3306;Database=xbookv1;user id=root;password=l123!;"
#显示
self.conn=MySQLdb.connect(host='192.168.1.90', user='root', passwd='l123!', db='xbookv1', port=3306, charset='utf8')
def connected(self):
return True
def query(self):
cur=self.conn.cursor()
sql="select * from book limit 10"
cur.execute(sql)
print((u"查询到共%s结果")%cur.rowcount)
#显示列名
#for d in cur.description:
# print("%d,%s",d[0],d[1])
#返回结果集
rets=cur.fetchall()
for rec in rets:
print(("%s,%s")%(rec[0],rec[1]))
#print 'repr() of next row is...'
#print(repr(cur.next()))
if __name__ == '__main__':
#print(u"系统版本:"+sys.version)
#print(u"中文中国")
con=conmysql()
print(con.connstr)
con.query()
input("input char exit")