通过输入书名,查找book_id,book_id为自动增加。defbor():book_name=raw_input('请输入要借的书名:')ifbook_name.strip()=='':printu'书名不能为空'returnbor()else:sql='''selectbo...
通过输入书名,查找book_id,book_id为自动增加。
def bor():
book_name=raw_input('请输入要借的书名:')
if book_name.strip()=='':
print u'书名不能为空'
return bor()
else :
sql=''' select book_id from Book where book_name='%s' '''%book_name
cur.execute(sql)
book=cur.fetchall()
book1=book[0][0]
a='%d' %book1
print a
a='a'
if a.isdigit():
b=int(a)
else:
b='123'
print b
#print "".join(book[0])
if book :
account=raw_input('请输入账号:')
if account.strip()=='':
print '账号不能为空!!!'
else :
sqll="select user_id from User where account='%s'"%account
cur.execute(sqll)
acc=cur.fetchall()
acc1=acc[0][0]
b='%d'%acc1
print b
if acc1:
#borrow_date='20200303'
sqlll='''insert into Borrow(book_id,user_id)
values(?,?)''' , (a,b)
cur.execute(sqlll)
con.commit()
cur.execute('select* from Borrow')
print cur.fetchall()
print '借书成功!!!'
else:
print u'不存在%s这个账号!!!'%account
else:
print u'不存在%s这本书!!!'%book_name
天提示的错误为:
operation parameter must be str or unicode
展开