PythonÁ¬½ÓMySQL
°æȨÉùÃ÷
£º×ªÔØʱÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂÔʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷
http://mobile2008.blogbus.com/logs/28725962.html
°²×°ºÃÖ®ºó£¬Ä£¿éÃû×Ö½Ð×öMySQLdb £¬ÔÚWindowºÍLinux»·¾³Ï¶¼¿ÉÒÔʹÓã¬ÊÔÑéÁËÒ»ÏÂͦºÃÓã¬
²»¹ýÓÖ·¢ÏÖÁË·³È˵ÄÂÒÂéÎÊÌ⣬×îºóÓÃÁ˼¸¸ö°ì·¨£¬½â¾öÁË£¡
ÎÒÓÃÁËÏÂÃ漸¸ö´ëÊ©£¬±£Ö¤MySQLµÄÊä³öûÓÐÂÒÂ飺
1 PythonÎļþÉèÖñàÂë utf-8 £¨ÎļþÇ°Ãæ¼ÓÉÏ #encoding=utf-8)
2 MySQLÊý¾Ý¿âcharset=utf-8
3 PythonÁ¬½ÓMySQLÊǼÓÉϲÎÊý charset=utf8
4 ÉèÖÃPythonµÄĬÈϱàÂëΪ utf-8 (sys.setdefaultencoding(utf-8)
mysql_test.py
#
encoding=utf-8
import
sys
import
MySQLdb
reload(sys)
sys.setdefaultencoding(
'
utf-8
'
)
db
=
MySQLdb.connect(user
=
'
root
'
,charset
=
'
utf8
'
)
cur
=
db.cursor()
cur.execute(
'
use mydb
'
)
cur.execute(
'
select * from mytb limit 100
'
)
f
=
file(
"
/home/user/work/tem.txt
"
,
'
w
'
)
for
i
in
cur.fetchall():
f.write(str(i))
f.write(
"
"
)
f.close()
cur.close()
ÉÏÃæÊÇlinuxÉϵĽű¾,windowsÏÂÔËÐÐÕý³£!
×¢£ºMySQLµÄÅäÖÃÎļþÉèÖÃÒ²±ØÐëÅäÖóÉutf8
ÉèÖà MySQL µÄ my.cnf Îļþ£¬ÔÚ [client]/[mysqld]²¿·Ö¶¼ÉèÖÃĬÈϵÄ×Ö·û¼¯£¨Í¨³£ÔÚ/etc/mysql/my.cnf)£º
[client]
default-character-set = utf8
[mysqld]
default-character-set = utf8
£££££££££££££££££££££££££££££££££££££££££££££
#!/usr/bin/env python
# -*-coding:UTF-8-*-#ÕâÒ»¾ä¸æËßpythonÓÃUTF-8±àÂë
#=========================================================================
#
# NAME: Python MySQL test
#
# AUTHOR: benyur
# DATE : 2004-12-28
#
# COMMENT: ÕâÊÇÒ»¸öpythonÁ¬½ÓmysqlµÄÀý×Ó
#
#=========================================================================
"""
***** This is a MySQL test *****
select:
conn=
Ïà¹ØÎĵµ£º
×÷Õߣºtaowen, billrice
http://www.cnblogs.com/taowen/articles/11239.html
Lesson 1 ×¼±¸ºÃѧϰPythonµÄ»·¾³
ÏÂÔصĵØÖ·ÊÇ£º
www.python.org
ΪÁË´ó¼ÒµÄ·½±ã£¬ÎÒÔÚУÄÚ×÷ÁËcopy£º
http://10.1.204.2/tool/compiler&IDE/Python-2.3.2-1.exe
linux°æ±¾µÄÎҾͲ»ËµÁË£¬ÒòΪÈç¹ûÄãÄܹ»Ê¹ÓÃlinux²¢°²×°ºÃ˵Ã÷Äã¿ÉÒÔ ......
×î½üÒªÓõ½´®¿ÚͨѶ£¬¼òµ¥Ò×ÓõÄPythonÓÖ°ïÉÏæÁË£¬¶à¿÷ÁËÅÓ´óµÄµÚÈý·½×ÊÔ´~~~ £º£©
pySerial
Overview
This module encapsulates the access for the serial port. It provides
backends for Python running on Windows, Linux, BSD (possibly any POSIX
compliant system), Jython and IronPython (.NET and M ......
SleekEngine
Ëæ׿ÆËã»úÓ²¼þµÄ¿ìËÙ·¢Õ¹£¬10ÄêÇ°ÒòΪËÙ¶ÈÎÊÌâ¶ø±»Ú¸²¡µÄJavaÏÖÔÚ³ÉÁ˼ÆËã»úÁ÷ÑÔÓïÑÔÖеÄÀϴ󣬵«ÊÇËüÈ´ÈÔ±»ÈÏΪ¸´ÔÓ±¿ÖØ£¬½ü¼¸ÄêÀ´¶¯Ì¬Óï
ÑÔÈ´ÓкóÀ´¸ÏÉϵÄÇ÷ÊÆ£¬ÕÆÎÕÒ»ÃŶ¯Ì¬ÓïÑÔ³ÉÁ˳ÌÐòÔ±ÐèÒª¿¼ÂǵÄÊÂÒË¡£ ½üÆÚ½Ó´¥Á˼¸ÖÖÁ÷ÐеĶ¯Ì¬ÓïÑÔPython, Ruby,
Groovy£¬ËüÃÇÏà±È¾²Ì¬ÓïÑÔJava/C++À´Ëµ£¬´óÎ ......
pythonÖеıàÂë
ÔÎÄ£ºhttp://users.ir-lab.org/~liulong/blog/archives/001962.html
¼ÆËã»úÒÔ0,1¶þ½øÖÆλÀ´´æ´¢ÐÅÏ¢,ËùÒÔ×Ö·ûÔÚ¼ÆËã»úÖеıíʾҲÊǶþ½øÖÆλ,ÄÇÿ¸ö×Ö·ûËù¶ÔÓ¦µÄ¶þ½øÖÆλÊÇʲô,ÔÚ¿ªÊ¼µÄ¼ÆËã»úÖÐÒòΪֻ¿¼ÂÇÓ¢Óï, ËùÒÔ²»³¬¹ý256¸ö×Ö·û,¼´ÓÃÒ»¸ö×Ö½Ú(8bit)¾Í×ã¿ÉÒÔ±íʾËùÓеÄ×Ö·û,Õâ¸ö¶ÔÓ¦¹Øϵ¾ÍÊǶÔ×Ö·ûµ ......