python自己做电子词典_python实现电子词典

本文实例为大家分享了python实现电子词典的具体代码，供大家参考，具体内容如下

服务端

#!/usr/bin/env python3

from __future__ import unicode_literals

# coding=utf-8

from socket import *

import os

import pymysql

import time

import sys

import signal

DICT_TEXT = "./dict.txt"

HOST = '0.0.0.0'

PORT = 8000

ADDR = (HOST, PORT)

# 主控制流程

def main():

# 连接数据库

db = pymysql.connect\

('localhost', 'root', '123456', 'dict')

# 创建流式套接字

s = socket()

s.setsockopt(SOL_SOCKET, SO_REUSEADDR, 1)

s.bind(ADDR)

s.listen(5)

# 或略子进程退出

signal.signal(signal.SIGCHLD, signal.SIG_IGN)

while True:

try:

c, addr = s.accept()

print("Connect from", addr)

except KeyboardInterrupt:

s.close()

sys.exit("服务器退出")

except Exception as e:

print(e)

continue

# 创建子进程处理客户端请求

pid = os.fork()

if pid == 0:

s.close()

do_child(c, db)

else:

c.close()

def do_child(c, db):

# 循环接收请求

while True:

data = c.recv(128).decode()

print("Request:", data)

if (not data) or data[0] == 'E':

c.close()

sys.exit(0)

elif data[0] == 'R':

do_register(c, db, data)

elif data[0] == "L":

do_login(c, db, data)

elif data[0] == 'Q':

do_query(c, db, data)

elif data[0] == 'H':

do_history(c, db, data)

def do_register(c, db, data):

l = data.split(' ')

name = l[1]

passwd = l[2]

cursor = db.cursor()

sql = \

"select * from user where name='%s'" % name

cursor.execute(sql)

r = cursor.fetchone()

if r != None:

c.send(b'EXISTS')

return

sql = "insert into user (name,passwd)\

values ('%s','%s')" % (name, passwd)

try:

cursor.execute(sql)

db.commit()

c.send(b'OK')

except:

db.rollback()

c.send(b'FALL')

return

else:

print("%s注册成功" % name)

def do_login(c, db, data):

l = data.split(' ')

name = l[1]

passwd = l[2]

cursor = db.cursor()

sql = "select * from user where \

name='%s' and passwd='%s'" % (name, passwd)

cursor.execute(sql)

r = cursor.fetchone()

if r == None:

c.send('用户名或密码不正确'.encode())

else:

c.send(b'OK')

def do_query(c, db, data):

l = data.split(' ')

name = l[1]

word = l[2]

cursor = db.cursor()

def insert_history():

tm = time.ctime()

sql = "insert into hist (name,word,time)\

values ('%s','%s','%s')" % (name, word, tm)

try:

cursor.execute(sql)

db.commit()

except:

db.rollback()

return

try:

f = open(DICT_TEXT, 'rb')

except:

c.send("500 服务端异常".encode())

return

while True:

line = f.readline().decode()

w = line.split(' ')[0]

if (not line) or w > word:

c.send("没找到该单词".encode())

break

elif w == word:

c.send(b'OK')

time.sleep(0.1)

c.send(line.encode())

insert_history()

break

f.close()

def do_history(c, db, data):

name = data.split(' ')[1]

cursor = db.cursor()

try:

sql = "select * from hist \

where name='%s'" % name

cursor.execute(sql)

r = cursor.fetchall()

if not r:

c.send('没有历史记录'.encode())

return

else:

c.send(b'OK')

except:

c.send("数据库查询错误".encode())

return

n = 0

for i in r:

n += 1

# 最多显示10条

if n > 10:

break

time.sleep(0.1)

msg = "%s %s %s" % (i[1], i[2], i[3])

c.send(msg.encode())

time.sleep(0.1)

c.send(b'##')

if __name__ == "__main__":

main()

客户端

#!/usr/bin/env python3

#coding=utf-8

from socket import *

import sys

import getpass

def main():

if len(sys.argv) < 3:

print("argv is error")

return

HOST = sys.argv[1]

PORT = int(sys.argv[2])

ADDR = (HOST,PORT)

s = socket()

s.connect(ADDR)

while True:

print('''\n

===========Welcome=========

--1.注册 2.登录 3.退出--

===========================

''')

try:

cmd = int(input("输入选项>>"))

except Exception:

print("输入命令错误")

continue

if cmd not in [1,2,3]:

print("对不起，没有该命令")

sys.stdin.flush() #清除输入

continue

elif cmd == 1:

name = do_register(s)

if name != 1:

print("注册成功,直接登录！")

login(s,name)

else:

print("注册失败！")

elif cmd == 2:

name = do_login(s)

if name != 1:

print("登录成功！")

login(s,name)

else:

print("登录失败！")

elif cmd == 3:

s.send(b"E")

sys.exit("谢谢使用")

def do_register(s):

while True:

name = input("用户名:")

passwd = getpass.getpass("密 码:")

passwd1 = getpass.getpass("确认密码:")

if (' ' in name) or (' ' in passwd):

print("用户名密码不允许空格")

continue

if passwd != passwd1:

print("两次密码不一致")

continue

msg = "R {} {}".format(name,passwd)

#发送请求

s.send(msg.encode())

#接收回复

data = s.recv(128).decode()

if data == "OK":

return name

elif data == 'EXISTS':

print("该用户已存在")

return 1

else:

return 1

def do_login(s):

name = input("用户名:")

passwd = getpass.getpass("密 码:")

msg = "L {} {}".format(name,passwd)

s.send(msg.encode())

data = s.recv(128).decode()

if data == 'OK':

return name

else:

print(data)

return 1

def login(s,name):

while True:

print('''\n

===========查询界面============

1.查词 2.历史记录 3.注销

=============================

''')

try:

cmd = int(input("输入选项>>"))

except Exception:

print("命令错误")

continue

if cmd not in [1,2,3]:

print("对不起，没有该命令")

sys.stdin.flush() #清除输入

continue

elif cmd == 1:

do_query(s,name)

elif cmd == 2:

do_history(s,name)

elif cmd == 3:

return

def do_query(s,name):

while True:

word = input("单词:")

if word == "##":

break

msg = "Q {} {}".format(name,word)

s.send(msg.encode())

data = s.recv(128).decode()

if data == 'OK':

data = s.recv(2048).decode()

print(data)

else:

print(data)

def do_history(s,name):

msg = "H {}".format(name)

s.send(msg.encode())

data = s.recv(128).decode()

if data == 'OK':

while True:

data = s.recv(1024).decode()

if data == "##":

break

print(data)

else:

print(data)

if __name__ == "__main__":

main()

插入字典

import pymysql

import re

f = open('dict.txt')

db = pymysql.connect\

('localhost','root','123456','dict')

cursor = db.cursor()

for line in f:

try:

l = re.split("[ ]+",line)

except:

pass

sql = "insert into words (word,interpret)\

values ('%s','%s')"%(l[0],' '.join(l[1:]))

try:

cursor.execute(sql)

db.commit()

except:

db.rollback()

f.close()

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持脚本之家。