首页 > 代码库 > python-mysql,socket
python-mysql,socket
一、python-mysql环境准备:
windows版本:
1、安装Mysql
2、安装Python操作mysql的模块,http://www.codegood.com/archives/129
3、安装mysql图形界面
4、验证:import MySQLdb成功
linux版本:
1、安装Mysql
参考:http://jingyan.baidu.com/article/a378c9609eb652b3282830fd.html
注意:./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/mysql
2、安装Python操作mysql的模块,MySQL-python-1.2.5.tar.gz
3、验证:import MySQLdb成功
武沛齐博客:http://www.cnblogs.com/wupeiqi/articles/4938499.html
二、python-mysql-API
mysql:http://www.cnblogs.com/wupeiqi/articles/5095821.html
1、查询数据
>>> import MySQLdb
>>>
>>> conn = MySQLdb.connect(host=‘127.0.0.1‘,user=‘root‘,passwd=‘root‘,db=‘swconfig‘)
>>> cur = conn.cursor()
>>> reCount=cur.execute(‘select * from devinfors‘)
>>> reCount=cur.execute(‘select * from devinfors‘)
>>> data=http://www.mamicode.com/cur.fetchall()
>>> print data
((1L, ‘BF50SW19-B3‘, ‘80.97.35.19‘, ‘101‘, ‘102‘, ‘BF50SW20-B3‘, ‘80.97.35.20‘, ‘101‘, ‘102‘, ‘B3‘, ‘11D‘, ‘A3‘, ‘07‘, 0L), (2L, ‘BF50SW03-B5‘, ‘80.97.3.19‘, ‘107‘, ‘108‘, ‘BF50SW04-B5‘, ‘80.97.3.20‘, ‘107‘, ‘108‘, ‘B3‘, ‘21F‘, ‘B2‘, ‘04‘, 0L), (3L, ‘BF50SW21-B3‘, ‘80.97.35.21‘, ‘103‘, ‘104‘, ‘BF50SW22-B3‘, ‘80.97.35.22‘, ‘103‘, ‘104‘, ‘B3‘, ‘21B‘, ‘C4‘, ‘01‘, 0L), (7L, ‘BF50SW19-B3‘, ‘80.97.35.19‘, ‘105‘, ‘106‘, ‘BF50SW20-B3‘, ‘80.97.35.20‘, ‘105‘, ‘106‘, ‘B3‘, ‘11D‘, ‘A3‘, ‘07‘, 0L), (9L, ‘BF50SW21-B3‘, ‘80.97.35.21‘, ‘107‘, ‘108‘, ‘BF50SW22-B3‘, ‘80.97.35.22‘, ‘107‘, ‘108‘, ‘B3‘, ‘21A‘, ‘D2‘, ‘07‘, 0L), (10L, ‘BF50SW21-B3‘, ‘80.97.35.21‘, ‘109‘, ‘110‘, ‘BF50SW22-B3‘, ‘80.97.35.22‘, ‘109‘, ‘110‘, ‘B3‘, ‘21A‘, ‘D2‘, ‘07‘, 0L))
>>> print reCount
6
>>> cur.close()
>>> conn.close()
2、插入数据
>>> conn = MySQLdb.connect(host=‘127.0.0.1‘,user=‘root‘,passwd=‘root‘,db=‘swconfig‘)
>>> cur=conn.cursor()
>>> sql="insert into vlaninfos values(1,%s,%s,%s)"
>>> params=("80.2.238.0","802","B3")
>>> reCount=cur.execute(sql,params)
>>> conn.commit()
3、修改数据
>>> sql="update vlaninfos set vlan=%s,vlanid=%s where id=1"
>>> params=("80.4.238.0","800")
>>> reCount=cur.execute(sql,params)
>>> conn.commit()
4、删除数据
>>> sql="delete from vlaninfos where id=%s"
>>> params=(1,)
>>> reCount=cur.execute(sql,params)
>>> conn.commit()
三、socket
http://www.cnblogs.com/wupeiqi/articles/5040823.html
[root@localhost demo]# cat server.py
#!/usr/bin/python27
#coding:utf-8
import socket
s=socket.socket()
ip_port=(‘127.0.0.1‘,8888)
s.bind(ip_port)
s.listen(5)
while True:
conn,address=s.accept()
conn.send(‘hello.‘)
flag=True
while flag:
data=http://www.mamicode.com/conn.recv(1024)
print data
if data=http://www.mamicode.com/=‘exit‘:
flag=False
conn.send(‘welcome to python socket‘)
conn.close()
[root@localhost demo]# cat client.py
#!/usr/bin/python27
#coding:utf-8
import socket
client=socket.socket()
ip_port=(‘127.0.0.1‘,8888)
client.connect(ip_port)
while True:
data=http://www.mamicode.com/client.recv(1024)
print data
input_str=raw_input(‘clent:‘)
client.send(input_str)
if input_str==‘exit‘:
break
[root@localhost demo]#
python-mysql,socket