oreig
keyreaderidrefere
cessystem_readersreaderidgo8管理员表建立createtablesystem_Admi
istratoradmi
istratoridvarchar9primarykeyadmi
istrator
amevarchar9
ot
ulladmi
istratorpasswordvarchar12
ot
ulladmi
istratorpermissio
varchar10go
1628
f9超级管理员表建立createtablesystem_super_Admi
istratorsuperadmi
istratoridvarchar9primarykey
superadmi
istrator
amevarchar9
ot
ullsuperadmi
istratorpasswordvarchar12
ot
ullsuperadmi
istratorpermissio
varchar10
go10索引的创建uselibrarysystemgocreatei
dexbookstyle_i
dex_styleo
book_stylebookstylecreatei
dexborrow_record_i
dex_readerido
borrow_recordreaderidcreatei
dexreader_fee_i
dex_readerido
reader_feereaderidcreatei
dexretur
_record_i
dex_readerido
retur
_recordreaderidcreatei
dexsystem_books_i
dex_book
ameo
system_booksbook
amecreatei
dexsystem_books_i
dex_style
oo
system_booksbookstyle
ocreatei
dexsystem_books_i
dex_bookauthoro
system_booksbookauthor
45数据初始化
（1）将书籍类别加入表book_style中i
serti
tobook_stylebookstyle
obookstylevalues1人文艺术类i
serti
tobook_stylebookstyle
obookstylevalues2自然科学类i
serti
tobook_stylebookstyle
obookstylevalues3社会科学类i
serti
tobook_stylebookstyle
obookstylevalues4图片艺术类i
serti
tobook_stylebookstyle
obookstylevalues5政治经济类i
serti
tobook_stylebookstyle
obookstylevalues6工程技术类i
serti
tobook_stylebookstyle
obookstylevalues7语言技能类（2）将已有的图书加入system_books表中定义相同的作者出版社的书本编号不一样i
serti
tosystem_booksbookidbook
amebookstyle
obookauthorbookpubbookpubdateisborrowedvalues00125415152计算机组成原理6王爱英清华大学出版社20010103200311151
booki
date
i
serti
tosystem_booksbookidbook
amebookstyle
obookauthorbookpubbookpubdatebooki
dateisborrowedvalues00125415153计算机组成原理6王爱英清华大学出版社20010103200311151
i
serti
tosystem_booksbookidbook
amebookstyle
obookauthorbookpubbookpubdatebooki
dateisborrowedvalues00456456数据库原理6萨师煊高等教育出版社20070702200709151
i
serti
tosystem_booksbookidbook
amebookstyle
obookauthorbookpubbookpubdateisborrowedvalues12215121C程序设计6谭浩强清华大学出版社20020402200403141
booki
date
i
serti
tosystem_booksbookidbook
amebookstyle
obookauthorbookpubbookpubdatebooki
date
1728
fisborrowedvalues9787308020558计算机体系结构6石教英浙江大学出版社20041003200611151
i
serti
tosystem_booksbookidbook
amebookstyle
obookauthorbookpubbookpubdatebookir
