python sock + mysql
981 ワード
server.py
client.py
mysqlプラグインのダウンロード
https://pypi.python.org/pypi/MySQL-python/1.2.5
操作MYQL
http://www.cnblogs.com/rollenholt/archive/2012/05/29/2524327.html
if __name__ == '__main__':
import socket
sock = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
sock.bind(('localhost', 8001))
sock.listen(2000)
while True:
connection,address = sock.accept()
buf = connection.recv(1024)
if buf != '':
print buf
connection.send('yes')
connection.close()
client.py
if __name__ == '__main__':
import socket
sock = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
sock.connect(('localhost', 8001))
sock.send('+RESP:GTTOW,0F0100,135790246811220,,,10,1,1,4.3,92,70.0,121.354335,31.222073,20090214213254,0460,0000,18d8,6141,00,2000.0,20090214093254,11f0$')
print sock.recv(1024)
sock.close()
mysqlプラグインのダウンロード
https://pypi.python.org/pypi/MySQL-python/1.2.5
操作MYQL
http://www.cnblogs.com/rollenholt/archive/2012/05/29/2524327.html