python-网络安全编程第四天（数据库编程&网络编程）

             1 db_connection = pymysql.connect(
 2     host=‘127.0.0.1‘,
 3     user=‘xxxx‘,
 4     password=‘xxxx‘,
 5     database=‘python2test‘,
 6     charset=‘utf8‘ 7)
 8 cursor=db.cursor()
 9 cursor.execute("SELECT VERSION()")
10 data=cursor.fetchone()
11print(data)
12 db.close()

             1
            import
             pymysql

             2
             3 db = pymysql.connect(
 4     host=‘127.0.0.1‘,
 5     port=3306,
 6     user=‘root‘,
 7     passwd=‘xiaohua‘,
 8     db=‘test‘ 9    )
1011 cursor=db.cursor()
12 cursor.execute("SELECT VERSION()")
13 sql="""CREATE TABLE XIAOHUA (
14         FIRST_NAME  CHAR(20) NOT NULL,
15         LAST_NAME  CHAR(20),
16         AGE INT,  
17         SEX CHAR(1),
18         INCOME FLOAT )"""19cursor.execute(sql)
20 db.close()

             1
            #
            !/usr/bin/python
             2
            #
             -*- coding: UTF-8 -*-
             3
            #
             文件名：server.py
             4
             5
            import socket               # 导入 socket 模块 6 7 s = socket.socket()         # 创建 socket 对象 8 host = ‘192.168.233.132‘ 9 port = 12345                # 设置端口10 s.bind((host, port))        # 绑定端口1112 s.listen(5)                 # 等待客户端连接13while True:
14     c,addr = s.accept()     # 建立客户端连接15print‘连接地址：‘, addr
16     c.send(‘欢迎访问菜鸟教程！‘)
17     c.close()                # 关闭连接

             1
            #
            !/usr/bin/python
             2
             3
            import socket               # 导入 socket 模块 4 s = socket.socket()         # 创建 socket 对象 5 host = ‘192.168.233.132‘# 获取本地主机名 6 port = 12343                # 设置端口号 7 8s.connect((host, port))
 9print s.recv(1024)
10s.close()
11