按照自己的想法写了一个class 但是在类属性的使用上感觉很别扭，不知道这么写是不是合适 import pymysql import socket class DB: tableName = "py_test.ip_record" conn = None cursors = None def __init__(self): DB.conn = pymysql.connect( host="127.0.0.1", user="root", password="123456", database="py_test", cursorclass=pymysql.cursors.DictCursor ) DB.cursors = DB.conn.cursor() def __del__(self): DB.conn.close() def get_by_ip(self, ip): sql = f"select id,ip_addr from {DB.tableName} where ip_addr = '{ip}'" DB.cursors.execute(sql) result = DB.cursors.fetchall() return result def add_info(self, ip): sql = f"insert into {DB.tableName} set ip_addr = '{ip}'" DB.cursors.execute(sql) try: DB.conn.commit() return "add success" except: DB.conn.rollback() return "add error" # 获取本机ip def get_local_ip(): hostname = socket.gethostname() ip = socket.gethostbyname(hostname) return ip local_ip = get_local_ip() db = DB() add_res = db.add_info(local_ip) print(add_res) res = db.get_by_ip(local_ip) print(res)

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 ;

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)

import socket import pymysql def get_ip_address(): hostname = socket.gethostname() ip_address = socket.gethostbyname(hostname) return ip_address def store_ip_address(ip_address): db = pymysql.connect(host='localhost', user='root', password='admin', database='kkb', cursorclass=pymysql.cursors.DictCursor) with db: with db.cursor() as cu: cu.execute("CREATE TABLE IF NOT EXISTS ip_addresss(ip varchar(255))") cu.execute(f"INSERT INTO ip_addresss VALUES ('{ip_address}')") db.commit() ip_address = get_ip_address() store_ip_address(ip_address)

在 Python 中，你可以使用 `socket` 库来获取当前执行程序的电脑的 IP 地址，然后使用 `pymysql` 库将 IP 地址存储到 MySQL 数据库中。以下是一个示例： ```python import socket import pymysql # 获取本机 IP 地址 def get_ip_address(): hostname = socket.gethostname() ip_address = socket.gethostbyname(hostname) return ip_address # 将 IP 地址存储到 MySQL 数据库中 def store_ip_address(ip_address): # 连接到数据库（请替换为你的数据库信息） db = pymysql.connect("localhost", "username", "password", "database") cursor = db.cursor() # 创建表 cursor.execute("CREATE TABLE IF NOT EXISTS ip_addresses (ip VARCHAR(255))") # 插入 IP 地址 cursor.execute(f"INSERT INTO ip_addresses VALUES ('{ip_address}')") db.commit() db.close() ip_address = get_ip_address() store_ip_address(ip_address) ``` 在这个代码中，`get_ip_address` 函数用于获取本机的 IP 地址，`store_ip_address` 函数用于将 IP 地址存储到 MySQL 数据库中。你需要将数据库连接信息（如主机名、用户名、密码和数据库名）替换为你自己的信息。 请注意，这只是一个基本的示例，你可能需要根据实际情况调整代码，例如处理可能出现的异常，或者添加更多的数据库操作。 .

# pip3 install PyMqSQL 安装库 import pymysql # 连接 connect = pymysql.connect(host='localhost', user='root', passwd='ac', db='db', cursorclass=pymysql.cursors.DictCursor) with connect: # 查询 with connect.cursor() as cursor: sql = "select * from users" # 执行语句 cursor.execute(sql) result = cursor.fetchall() print(result) # 新增 # with connect.cursor() as cursor: # sql = "insert into users (email, password) values (%s, %s)" # cursor.execute(sql, ('lyy@qq.com', 'lyypw')) # connect.commit() # 修改 with connect.cursor() as cursor: sql = "update users set email = %s where id =%s" cursor.execute(sql, ["lyy22@qq.com", 3]) connect.commit() # 查询 with connect.cursor() as cursor: sql = "select * from users" # 执行语句 cursor.execute(sql) result = cursor.fetchall() print(result)

课后习题： 先获取ip地址，然后保存起来 写入sql的把ip地址写进入 获取ip，保存到ip_address中 import socket hostname = socket.gethostname() ip_address = socket.gethostbyname(hostname) # 写入sql with connection: with connection.cursor() as cursor: # 建立一条记录 sql = "INSERT INTO `users` (`email`, `password`, `ip`) VALUES (%s, %s, %s)" cursor.execute(sql, ('bianlin@alibaba-inc.com', 'bianlin', ip_address)) # connection 不能自动提交数据，必须手动提交 connection.commit() 读取： with connection: with connection.cursor() as cursor: # 读取记录 sql = "SELECT `id`, `password`, `ip` FROM `users` WHERE `email`=%s" cursor.execute(sql, ('bianlin@alibaba-inc.com',)) result = cursor.fetchone() print(result)

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()

一.习题练习（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'}

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)