PYTHON学习总结

import sys
reload(sys)
sys.setdefaultencoding('utf-8')

import sys
sys.setdefaultencoding('utf-8')

#coding:utf-8

pip install MySQL-python
pip install xlrd
pip install xlwt

#格式化操作符右操作数可以是任何东西，如字符串变量，元组或字典等
print "user'name is %s" %"tianya"
print "username:%s password:%s" %("tianya","")
mydict = {"username":"tianya","password":""}
print "username:%(username)s password:%(password)s" %mydict

from string import Templates = Template("hello $x")
print s.substitute(x="world")
s = Template("username:${username}&&password:${password}")
mydict = {"username":"tianya","password":""}
print s.substitute(mydict)

def fun(x,y,z=3, *pospar, **keypar):
print x,y,z
print pospar
print keyparfun(1,2,3,4,5,key1=10,key2=20)输出：
1 2 3
(4, 5)
{'key2': 20, 'key1': 10}fun(1,2)
输出：
1 2 3
()
{}

class Person:
def __init__(self,name = "zhangsan"):
self.name = name def __del__(self):
print "__del__()" def say(self):
print self.namep = Person()
p.say()
p2 = Person("lisi")
p2.say()
del p

class User:
def __init__(self,name = "tianya"):
self.name = name def __del__(self):
del self.name def __len__(self):
return len(self.name) def __getitem__(self,key):
return eval("self."+key) def __str__(self):
return "user.name:"+self.name def __lt__(self,other):
return self.name < other.nameuser = User()
print len(user)
print user["name"]
print useruser2 = User("feng")
if user > user2:
print user.name + ">" + user2.name
else:
print user.name + "<" + user2.namedel user,user2

def __init__( self ):
passdef __del__( self ):
pass

f = file("test.txt","w")
mylist = [1,2,3,4]
f.write(repr(mylist))
f.close()f = file("test.txt")
while True:
line = f.readline()
if len(line) == 0:
break
print line
f.close()import cPickle
f = file("test002.txt","w")
cPickle.dump(mylist,f)
f.close()
del mylist
f = file("test002.txt")
newlist = cPickle.load(f)
print newlist

yum install python-devel

apt-get install libmysqlclient-dev

import time
import MySQLdbtry:
conn=MySQLdb.connect(host='211.152.53.103',user='root',passwd='',port=)
cur=conn.cursor()
cur.execute('drop database if exists python')
cur.execute('create database if not exists python')
conn.select_db('python')
cur.execute('create table test(id int,info varchar(20))') for i in range():
value=[i,'test:'+str(i)]
cur.execute('insert into test values(%s,%s)',value)
conn.commit()
time.sleep() sql ="select * from test";
cur.execute(sql)
data = cur.fetchall()
if data:
for row in data:
print row[],row[]
cur.close()
conn.close()except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[], e.args[])

import xlrd
import sys
from tkinter import *
from tkinter import filedialogdef openexcel():
filename = filedialog.askopenfilename(initialdir = 'c:/')
if filename:
data = xlrd.open_workbook(filename) #获取sheet名称，留为生成lua表的主键
sheet_name = data.sheet_names()[0] table = data.sheet_by_name(sheet_name) #总行数和总列数
row_count = table.nrows
col_count = table.ncols #有效行数，判断依据：如果第一列向下有一个单元格内容为空，则视为结束
valid_row_count = 0
for item in table.col_values(0):
if item:
valid_row_count = valid_row_count+1
else:
break #有效列数，判断依据：标题行如果有一个单元格内容为空，则视为结束
valid_col_count = 0
for item in table.row_values(0):
if item.strip():
valid_col_count = valid_col_count+1
else:
break #print(row_count)
#print(valid_row_count)
#print(col_count)
#print(valid_col_count) rows = table.nrows cols = table.ncols #get title_row:
title_row = table.row_values(0)
valid_title_list = []
for colindex in range(valid_col_count):
if title_row[colindex].find("(") > 0:
valid_title_list.append(title_row[colindex][0:title_row[colindex].find('(')])
else:
valid_title_list.append(title_row[colindex]) #print(valid_title_list)
lua = sheet_name + "=\n"
luadata = "{\n" #get data to lua
for rowindex in range(1,valid_row_count):
row = table.row_values(rowindex)
if row:
luarow = "{"
for colindex in range(0,valid_col_count):
if isinstance(row[colindex],str):
luarow = luarow + valid_title_list[colindex] + " = \"" + row[colindex].replace("\n"," ") +"\","
else:
luarow = luarow + valid_title_list[colindex] + " = " + str(row[colindex]).replace("\n"," ") +","
luadata = luadata + "\t" + str(luarow) + "},\n" lua = lua + luadata + "}"
print(lua)
f = open(sheet_name + ".lua","w")
f.write(lua)
f.close()root = Tk()
b1 = Button(root,text='open file',width=30,height=5,command=openexcel)
b1.pack()
root.mainloop()

import xlrd
import logging
import MySQLdb
import jsondata = xlrd.open_workbook("data.xls")
sheet_name = data.sheet_names()[0]
table = data.sheet_by_name("sql")
row_count = table.nrows
col_count = table.ncols
logging.warning(row_count)
logging.warning(col_count)i = 0
conn=MySQLdb.connect(host='100.112.113.114',user='test',passwd='1u12Z2Sfhs2',port=3306)
cur=conn.cursor()
conn.select_db('gamedb_901001')
for rowindex in range(1,row_count):
i = i+1
logging.warning(i)
row = table.row_values(rowindex)
mydict = dict()
if str(row[1]) == '':
mydict['platformStr'] = "PLATFORM_TYEP_ERATING"
else:
mydict['platformStr'] = "PLATFORM_TYEP_91"
mydict['eRoleID'] = int(row[5])
mydict['eratingID'] = int(row[3])
mydict['name'] = str(row[2]) userid = int(row[7]) sql = "update p_user set oneEratingUserData='%s' where id = %s" %(json.dumps(mydict),userid)
cur.execute(sql)cur.close()
conn.close()

from ctypes import *
msvcrt=CDLL('msvcrt.dll') #msvcrt =cdll.msvcrt #以cdll的方式加载msvcrt 或者写作： msvcrt =cdll.LoadLibrary("msvcrt.dll")
msvcrt.printf('a=%d,b=%d,a+b=%d',1,2,1+2) windll.user32.MessageBoxA(0, "great", 'hello world', 0)

//User.cpp:
class User
{
public:
int id;
int age;
};extern "C"{
User user;
int id = user.id;
}gcc User.cpp -o libUser.so -shared -fPIC//test.py:
from ctypes import *h = CDLL('./libUser.so')
h.user.id = 3
print h.user.id

#!/usr/bin/python
import socket
import struct
import binascii
import jsondef send(protocol, msg):
ip = '127.0.0.1'
port = ''
sock = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
try:
sock.connect((ip,int(port)))
except Exception:
return "%s:%s connect error!" %(ip,port)
buffer = struct.pack("IIII",protocol,len(json.dumps(msg)),binascii.crc32(json.dumps(msg)),1) sock.send(buffer)
sock.send(json.dumps(msg))
head = sock.recv(16)
msg_body_size = struct.unpack("IIII",head)[1] response = str()
block = str()
while len(response)<msg_body_size:
block = sock.recv(1024)
response += block
sock.close()
return response

wget https://raw.github.com/pypa/pip/master/contrib/get-pip.py &&#或：easy_install pip &&
python get-pip.py &&
pip install simplejson &&
pip install pexpect

cmd2 = pexpect.spawn('scp GamePlist.zip %s@%s:/usr/local/apache2/htdocs/sailing/protocol/GamePlist.zip' %(username,host))
cmd2.expect('password:',timeout=5)
logging.warning(cmd2)
cmd2.sendline(password)
cmd2.sendline('\r')

#!/usr/bin/python
#coding:utf-8
import smtplib
from email.MIMEMultipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.image import MIMEImagemailto_list=['123456789@qq.com']
mail_host="smtp.163.com" #设置服务器
mail_user="123456789@163.com" #用户名
mail_pass="" #口令
mail_name = "发件人名称（随便写）"
mail_postfix="163.com" #发件箱的后缀def send_mail(to_list,sub,content):
me= mail_name+"<"+mail_user+"@"+mail_postfix+">" msg = MIMEMultipart('related')
msg['Subject'] = sub
msg['From'] = me
msg['To'] = ";".join(to_list) content = MIMEText(content,_subtype='html',_charset='gb2312')
msg.attach(content) image = MIMEImage(open('test2.jpg','rb').read())
image.add_header('Content-ID', '<image1>')
msg.attach(image) attach_file = MIMEText(open('Resource.rar').read(),'base64','gb2312')
attach_file["Content-Type"] = 'application/octet-stream'
attach_file["Content-Disposition"] = 'attachment; filename="Resource.rar"'
msg.attach(attach_file) try:
server = smtplib.SMTP()
server.connect(mail_host)
server.login(mail_user,mail_pass)
server.sendmail(me, to_list,msg.as_string())
server.close()
return True
except Exception, e:
print str(e)
print 'error'
return Falseif __name__ == '__main__':
#send_mail(mailto_list,u"测试邮件标题",u"<b><font color='red'>测试邮件正文。</font></b>")
send_mail(mailto_list,u"测试邮件标题333",u"<font color='red'>这是红色的邮件正文。</font><br /><br />下面是一张图片:<br /><img src='cid:image1'>...")
#send_mail(mailto_list,u"测试邮件标题",u"<font color='red'>测试邮件正文。</font>")