PythonÎļþ²Ù×÷
Îļþ²Ù×÷ÊdzÌÐòÉè¼ÆÖв»¿É»òȱµÄÖØÒª²¿·Ö¡£Pythonͨ¹ýÒ»¸öÄÚÖú¯ÊýopenÀ´´ò¿ªÎļþ¡£
open(filename,mode,buffer)
ÆäÖеÚÒ»¸ö²ÎÊýÊÇÒª´ò¿ªµÄÎļþµÄÎļþÃû£¬±ØÑ¡£»µÚ¶þ¸öÊÇ´ò¿ª·½Ê½£¬¿ÉÑ¡£»µÚÈý¸öΪ»º³åÇø£¬¿ÉÑ¡¡£Ä¬ÈÏÇé¿öÏÂÊÇÒÔ“¶Á”ģʽ´ò¿ªÎļþ¡£¸Ãº¯Êý·µ»ØµÄÊÇÁ÷ÀàÐͶÔÏó¡£
modeÓÐÈçϼ¸ÖÖ£º
* r£º¶Áģʽ£¨Ä¬ÈÏÖµ£©
* w£ºÐ´Ä£Ê½
* a£º×·¼Óдģʽ
* b£º¶þ½øÖÆÄ£Ê½
* t£ºÎı¾Ä£Ê½£¨Ä¬ÈÏÖµ£©
* +£º¸üÐÂÒÑÓÐÓ²ÅÌÎļþ£¨¶ÁºÍдģʽ£©
* U£ºÍ¨Óû»ÐÐģʽ£¨Universal new line mode£©
Èç¹ûµ½´ò¿ªµÄÎļþ²»´æÔÚ»òÕ߯äËûÎÊÌ⣬»áÅܳöIOErrorÒì³£¡£
³£ÓõÄÎļþ¶ÔÏóÊôÐÔ£º
* mode£ºÎļþ´ò¿ªÄ£Ê½
* name£º´ò¿ªµÄÎļþÃû³Æ
* closed£ºÎļþÊÇ·ñ¹Ø±Õ
³£ÓõÄÎļþ¶ÔÏó·½·¨ÓУº
* tell()£º»ñÈ¡ÔÚµ±Ç°ÎļþÖУ¬Ä¿Ç°Ëù´¦µÄλÖá£ÆðʼֵΪ0.
* seek(position,mode)£ºÔÚµ±Ç°ÎļþÖÐÒÆ¶¯¡£ÆäÖеÚÒ»¸ö²ÎÊýÊÇÒªÒÆ¶¯µÄ¾àÀ룬µÚ¶þ¸ö²ÎÊýÊÇģʽ£º0±íÊ¾ÒÆ¶¯¾ø¶ÔλÖã¬Ïà¶ÔÓÚÎļþÍ·¶øÑÔ£»1±íÊ¾ÒÆ¶¯Ïà¶ÔλÖ㬾͵±Ç°Î»ÖöøÑÔ£»2±íʾÏà¶ÔÓÚÎļþβµÄλÖá£
* read(max_byte_num)£º´ÓÎļþÖжÁÈ¡×Ö½Ú¡£max_byte_numberΪ¿ÉÑ¡²ÎÊý£¬±íʾ¶ÁÈ¡µÄ×î´ó×Ö½ÚÊý¡£Èç¹û²»Ñ¡£¬Ä¬ÈÏΪ¶ÁÈ¡µ½Îļþβ¡£¶ÁÈ¡ºó£¬µ±Ç°Î»ÖûᷢÉú±ä»¯£¬¼´Ôö¼Ó¶ÁÈ¡µÄ×Ö½ÚÊý¡£
* readline()£ºÒ»´Î¶ÁÈ¡ÎļþµÄÒ»ÐС£
* write(content)£ºÏòÎļþÖÐдÊý¾Ý¡£contentΪҪдÈëµÄÄÚÈÝ¡£
* close()£º¹Ø±ÕÎļþ
Ò»¸öÎļþ¶ÁдµÄÀý×Ó£º
view plaincopy to clipboardprint?
1. try:
2. f = open('d:/hello_python.txt','w')
3. f.write('hello my friend python!')
4. except IOError:
5. print('IOError')
6. fi
Ïà¹ØÎĵµ£º
http://www.itzn.cn/html/jiaoben/python-perl-VBA/200812/19-3283.html
×Ö·û´®ÊÇʹÓþ²Ì¬µÄ·½Ê½½øÐд洢£¬Ö»ÄܶÁ¶ø²»ÄÜÖ±½ÓÐÞ¸Ä×Ö·ûÄÚÈÝ¡£Ìرð½«Ò»¶Ñ¶Ô×Ö·û´®²¢ÔÚÒ»ÆðµÄʱºò£¬ËäÈ»¿ÉÒÔÖ±½ÓÏà¼Ó£¬Ìý˵ÕâÑùµÄËÙ¶ÈÆæÂý£¬Ö»ÓÐÓÃÆäËüº¯ÊýµÄ·½Ê½½øÐУ¬ºÃÔÚÒ²²»Ì«Âé·³¡£
±ÈÈçÓà print ','.join(datelist)
¾Í¿ÉÒÔ½«date ......
Ϊ³äʵ×Ô¼ºÄÇÆ½Ó¹µÄ֪ʶ¿â£¬´Ó½ñÌ쿪ʼ£¬Ñ§Ï°PythonÓïÑÔ¡£ Ì«¸ßÉîµÄ×ÊÁÏ¿´²»¶®£¬µ±Á˱¾×î¼òµ¥µÄPython¼òÃ÷½Ì³Ì£¬ÖÐÎİæchm¸ñʽµÄ¡£²»Ëµ·Ï»°ÁË£¬¿ªÊ¼½øÈëPythonµÄÊÀ½ç°É¡£ £¨Ò»£©°²×°Python дÕâÆªÎÄÕÂʱ£¬PythonµÄ×îа汾ÊÇ3.1£¬ÎÒϲ»¶ÓÃ×îÐµģ¬¾ÍÏÂÁËа汾µÄ¡£Ò»Â·NextÏÂÈ¥£¬ÎÒµÄC ......
ÀàÐÍ
·½·¨
×¢½â
Ìî³ä
center(width[, fillchar]) ,
ljust(width[, fillchar]),
rjust(width[, fillchar]),
zfill(width),
expandtabs([tabsize])
l
fillchar ²ÎÊýÖ¸¶¨ÁËÓÃÒÔÌî³äµÄ×Ö·û£¬Ä¬ÈÏΪ¿Õ¸ñ
l
¹Ë ......
Ê×ÏÈÒª¸ãÇå³þ£¬×Ö·û´®ÔÚPythonÄÚ²¿µÄ±íʾÊÇunicode±àÂ룬Òò´Ë£¬ÔÚ×ö±àÂëת»»Ê±£¬Í¨³£ÐèÒªÒÔunicode×÷ΪÖмä±àÂ룬¼´ÏȽ«ÆäËû±àÂëµÄ×Ö·û´®½âÂ루decode£©³Éunicode£¬ÔÙ´Óunicode±àÂ루encode£©³ÉÁíÒ»ÖÖ±àÂë¡£
decodeµÄ×÷ÓÃÊǽ«ÆäËû±àÂëµÄ×Ö·û´®×ª»»³Éunicode±àÂ룬Èçstr1.decode('gb2312')£¬±íʾ½«gb2312±àÂëµÄ×Ö·û´®×ª» ......
import pymssql
#connect database
conn=pymssql.connect(host="192.168.1.28",user="boomink",password="boomink",
database="boomink")
cur=conn.cursor()
print '========================================'
cur.execute("exec Orders_GetTest1 @Valu ......