极客时间-轻松学习，高效学习-极客邦

Matthew

2023-01-16 来自江苏

CREATE TABLE `ip_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip_addr` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;

1

Matthew

2023-01-16 来自江苏

import socket import pymysql # 创建 socket，获取 client_ip with socket.socket(socket.AF_INET, socket.SOCK_DGRAM) as s: s.connect(("8.8.8.8", 80)) client_ip = s.getsockname()[0] print(client_ip) # 连接数据库 connection = pymysql.connect(host='localhost', user='root', password='admin123', database='db', cursorclass=pymysql.cursors.DictCursor) with connection: # 插入纪录 with connection.cursor() as cursor: sql = "INSERT INTO ip_record (ip_addr) VALUES (%s)" try: cursor.execute(sql, str(client_ip)) connection.commit() print("Insert success!") except: connection.rollback() print("Insert fail!") # 读取纪录 with connection.cursor() as cursor: sql = "SELECT id, ip_addr FROM ip_record" cursor.execute(sql) # result = cursor.fetchone() result = cursor.fetchall() print(result) # 删除记录 with connection.cursor() as cursor: sql = "DELETE FROM ip_record WHERE ip_addr = %s" try: cursor.execute(sql, str(client_ip)) connection.commit() print("Delete success!") except: connection.rollback() print("Delete fail!") # 读取纪录 with connection.cursor() as cursor: sql = "SELECT id, ip_addr FROM ip_record" cursor.execute(sql) # result = cursor.fetchone() result = cursor.fetchall() print(result)

展开

1

Geek_Mike

2023-08-26 来自云南

import pymysql import socket ip_adress = socket.gethostbyname(socket.gethostname()) conn = pymysql.connect(host='localhost', user='root', password='123123123', database='db') # print(db) with conn: with conn.cursor() as cursor: sql = 'INSERT INTO info (ip_address) VALUES (%s)' cursor.execute(sql, (ip_adress)) conn.commit() with conn.cursor() as cursor: sql = 'SELECT ip_address FROM info' cursor.execute(sql) result = cursor.fetchone() print(result) conn.commit()

繁星不灭

2023-02-07 来自广东

一.习题练习（Linux版） 1.搭建数据库，创建表 #编译安装mysql数据库，依然使用db数据库，创建表 mysql> create table hostname_ip ( -> id int(11) not null auto_increment, -> hostname varchar(255) not null, -> ip varchar(255) not null, -> primary key (id) -> ); 2.linux环境 python服务器IP：10.100.36.29 mysql服务器IP：10.100.36.25 2.编写.py文件 import pymysql.cursors import socket #获取本地主机名和IP hostname=socket.gethostname() ip=socket.gethostbyname(hostname) #连接数据库 connection=pymysql.connect(host="10.100.36.25",user="root",password="rootroot",database="db",port=33600,cursorclass=pymysql.cursors.DictCursor) with connection: # 插入数据 with connection.cursor() as cursor: sql="INSERT INTO `hostname_ip` (`hostname`,`ip`) values (%s,%s)" cursor.execute(sql,(hostname,ip)) connection.commit() #查询结果 with connection.cursor() as cursor: sql = "SELECT * FROM `hostname_ip`" cursor.execute(sql) result = cursor.fetchone() print(result) 3.执行结果 {'id': 1, 'hostname': 'python01', 'ip': '10.100.36.29'}

展开

Cy23

2023-01-28 来自辽宁

import pymysql import socket ip_address = socket.gethostbyname(socket.gethostname()) print(f"IP_Address: {ip_address}") conn = pymysql.connect( host='localhost', user='root', password='', database='pydb', cursorclass=pymysql.cursors.DictCursor) with conn: with conn.cursor() as cursor: sql = "insert into `user_ips` (`ip`) values (%s)" cursor.execute(sql, (ip_address)) conn.commit() with conn.cursor() as cursor: sql = "select * from `user_ips`" cursor.execute(sql) result = cursor.fetchall() print(result)

PatrickL

2023-01-11 来自上海

import socket import pymysql IP = socket.gethostbyname(socket.gethostname()) print(IP) conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', password='1234', database='zero_basics_python') with conn: # 插入数据 with conn.cursor() as cursor: sql = 'INSERT INTO my_ip VALUES(%s);' try: cursor.execute(sql,IP) conn.commit() print('Sucess') except: conn.rollback() print('Fail') # 读取数据 with conn.cursor() as cursor: sql = 'SELECT IP FROM my_ip;' cursor.execute(sql) rst = cursor.fetchall() print(rst) # 删除数据 with conn.cursor() as cursor: sql = 'DELETE FROM my_ip WHERE IP = %s;' try: cursor.execute(sql,IP) conn.commit() print('Sucess') except: conn.rollback() print('Fail')

展开