"""
-- 创建名为address的数据库
create database address default charset utf8;
-- 切换到address数据库
use address;
-- 创建联系人表tb_contacter
create table tb_contacter
(
conid int auto_increment comment '编号',
conname varchar(31) not null comment '姓名',
contel varchar(15) default '' comment '电话',
conemail varchar(255) default'' comment '邮箱',
primary key (conid)
);
"""
import pymysql
INSERT_CONTACTER = """
insert into tb_contacter (conname, contel, conemail)
values (%s, %s, %s)
"""
DELETE_CONTACTER = """
delete from tb_contacter where conid=%s
"""
UPDATE_CONTACTER = """
update tb_contacter set conname=%s, contel=%s, conemail=%s
where conid=%s
"""
SELECT_CONTACTERS = """
select conid as id, conname as name, contel as tel, conemail as email
from tb_contacter limit %s offset %s
"""
SELECT_CONTACTERS_BY_NAME = """
select conid as id, conname as name, contel as tel, conemail as email
from tb_contacter where conname like %s
"""
COUNT_CONTACTERS = """
select count(conid) as total from tb_contacter
"""
class Contacter(object):
def __init__(self, id, name, tel, email):
self.id = id
self.name = name
self.tel = tel
self.email = email
def input_contacter_info():
name = input('姓名: ')
tel = input('手机: ')
email = input('邮箱: ')
return name, tel, email
def add_new_contacter(con):
name, tel, email = input_contacter_info()
try:
with con.cursor() as cursor:
if cursor.execute(INSERT_CONTACTER,
(name, tel, email)) == 1:
print('添加联系人成功!')
except pymysql.MySQLError as err:
print(err)
print('添加联系人失败!')
def delete_contacter(con, contacter):
try:
with con.cursor() as cursor:
if cursor.execute(DELETE_CONTACTER, (contacter.id, )) == 1:
print('联系人已经删除!')
except pymysql.MySQLError as err:
print(err)
print('删除联系人失败!')
def edit_contacter_info(con, contacter):
name, tel, email = input_contacter_info()
contacter.name = name or contacter.name
contacter.tel = tel or contacter.tel
contacter.email = email or contacter.email
try:
with con.cursor() as cursor:
if cursor.execute(UPDATE_CONTACTER,
(contacter.name, contacter.tel,
contacter.email, contacter.id)) == 1:
print('联系人信息已经更新!')
except pymysql.MySQLError as err:
print(err)
print('更新联系人信息失败!')
def show_contacter_detail(con, contacter):
print('姓名:', contacter.name)
print('手机号:', contacter.tel)
print('邮箱:', contacter.email)
choice = input('是否编辑联系人信息?(yes|no)')
if choice == 'yes':
edit_contacter_info(con, contacter)
else:
choice = input('是否删除联系人信息?(yes|no)')
if choice == 'yes':
delete_contacter(con, contacter)
def show_search_result(con, cursor):
contacters_list = []
for index, row in enumerate(cursor.fetchall()):
contacter = Contacter(**row)
contacters_list.append(contacter)
print('[%d]: %s' % (index, contacter.name))
if len(contacters_list) > 0:
choice = input('是否查看联系人详情?(yes|no)')
if choice.lower() == 'yes':
index = int(input('请输入编号: '))
if 0 <= index < cursor.rowcount:
show_contacter_detail(con, contacters_list[index])
def find_all_contacters(con):
page, size = 1, 5
try:
with con.cursor() as cursor:
cursor.execute(COUNT_CONTACTERS)
total = cursor.fetchone()['total']
while True:
cursor.execute(SELECT_CONTACTERS,
(size, (page - 1) * size))
show_search_result(con, cursor)
if page * size < total:
choice = input('继续查看下一页?(yes|no)')
if choice.lower() == 'yes':
page += 1
else:
break
else:
print('没有下一页记录!')
break
except pymysql.MySQLError as err:
print(err)
def find_contacters_by_name(con):
name = input('联系人姓名: ')
try:
with con.cursor() as cursor:
cursor.execute(SELECT_CONTACTERS_BY_NAME,
('%' + name + '%', ))
show_search_result(con, cursor)
except pymysql.MySQLError as err:
print(err)
def find_contacters(con):
while True:
print('1. 查看所有联系人')
print('2. 搜索联系人')
print('3. 退出查找')
choice = int(input('请输入: '))
if choice == 1:
find_all_contacters(con)
elif choice == 2:
find_contacters_by_name(con)
elif choice == 3:
break
def main():
con = pymysql.connect(host='120.77.222.217', port=3306,
user='root', passwd='123456',
db='address', charset='utf8',
autocommit=True,
cursorclass=pymysql.cursors.DictCursor)
while True:
print('=====通讯录=====')
print('1. 新建联系人')
print('2. 查找联系人')
print('3. 退出系统')
print('===============')
choice = int(input('请选择: '))
if choice == 1:
add_new_contacter(con)
elif choice == 2:
find_contacters(con)
elif choice == 3:
con.close()
print('谢谢使用, 再见!')
break
if __name__ == '__main__':
main()
没有合适的资源?快使用搜索试试~ 我知道了~
华中农业大学python-Day36-40.rar
共30个文件
png:14个
sql:11个
md:2个
需积分: 5 0 下载量 96 浏览量
2024-05-12
08:58:56
上传
评论
收藏 2.22MB RAR 举报
温馨提示
华中农业大学python-Day36-40.rar
资源推荐
资源详情
资源评论
收起资源包目录
python-Day36-40.rar (30个子文件)
Day36-40
关系型数据库MySQL.md 25KB
res
redis-aof.png 308KB
redis-slow-logs.png 314KB
redis-databases.png 53KB
redis-bind-and-port.png 281KB
redis-replication.png 277KB
redis-list.png 35KB
redis-zset.png 83KB
redis-rdb-1.png 226KB
redis-set.png 46KB
redis-data-types.png 67KB
redis-string.png 69KB
redis-rdb-3.png 203KB
redis-security.png 181KB
redis-hash.png 86KB
NoSQL入门.md 22KB
code
mooc_create_and_init.sql 2KB
shop_create_sql.sql 722B
学校选课系统.spf 16KB
人力资源管理.spf 37KB
srs_exercise_origin.sql 2KB
demo_create_and_init.sql 6KB
bank_create_and_init.sql 331B
HRS_create_and_init.sql 2KB
library_create_and_init.sql 2KB
dist.sql 114KB
SRS_create_and_init.sql 10KB
contact
main.py 6KB
sharebike_create_and_init.sql 2KB
booksys_create_and_init.sql 1KB
共 30 条
- 1
资源评论
流华追梦
- 粉丝: 4635
- 资源: 2155
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功