标题：python使用mysqldb插入mysql乱码问题

-------------------------------------------------------------------------------------------------------------------------------

时间：2012/11/20 0:27:26

-------------------------------------------------------------------------------------------------------------------------------

内容：

首先py文件用#-*- coding:utf-8 -*-

然后conn文件中指定

(user='root',passwd='111111',db='schools',charset='utf8')
就可以了

本地的电脑用set names gb2312

#-*- coding:utf-8 -*-
import re
import MySQLdb
from urllib2 import urlopen
from urllib2 import quote
from bs4 import BeautifulSoup
key0="上海"
key=quote(key0)
url = "http://www.baidu.com/s?wd=%s" %key
'''Get url information'''

text = urlopen(url).read()
soup = BeautifulSoup(text)
#h3=soup.find_all("table",attrs={"cellpadding":0,"cellspacing":0})
url=soup.find_all("span","g")
urls=soup.find_all("table",attrs={"mu":re.compile("http")})
h3t=soup.find_all("h3")
for h33 in urls:
    print h33.get("mu")
for h33 in url:
    print h33.get_text()
for h33 in h3t:
    print h33.get_text()

首先py文件用#-*- coding:utf-8 -*-

然后conn文件中指定

(user='root',passwd='111111',db='schools',charset='utf8')
就可以了

本地的电脑用set names gb2312

#-*- coding:utf-8 -*-
import re
import MySQLdb
from urllib2 import urlopen
from urllib2 import quote
from bs4 import BeautifulSoup
key0="上海"
key=quote(key0)
url = "http://www.baidu.com/s?wd=%s" %key
'''Get url information'''

text = urlopen(url).read()
soup = BeautifulSoup(text)
#h3=soup.find_all("table",attrs={"cellpadding":0,"cellspacing":0})
url=soup.find_all("span","g")
urls=soup.find_all("table",attrs={"mu":re.compile("http")})
h3t=soup.find_all("h3")
for h33 in urls:
    print h33.get("mu")
for h33 in url:
    print h33.get_text()
for h33 in h3t:
    print h33.get_text()