【正文】 ect) If = Then () End If Fill(sqlstr) Dim dv As DataView = (0).DefaultView = SortExp = dv () End Sub Private Sub BindDBGrid() Dim sqlstr As String = select * from BookInfo,LendInfo where = and UserID=39。pwd=123456。登陸失?。。?！39。pwd=123456。 + uid + 39。/script) (javascript:=39。 + + 39。 If GetRowsNum(sqlstr) = 0 Then Return False Else Return True End If End Function Public Sub BindDBGrd(ByVal sqlstr As String, ByVal myDBGrd As DataGrid) If = Then () End If Fill(sqlstr) = (0).DefaultView () End Sub Public Sub BindDBGrd(ByVal sqlstr As String, ByVal myDBGrd As DataGrid, ByVal SortExp As Object) If = Then () End If Fill(sqlstr) Dim dv As DataView = (0).DefaultView = SortExp = dv () End Sub Private Sub BindGrid() If Not Session(sqlstr) Is Nothing Then Dim sqlstr As String = CType(Session(sqlstr), String) BindDBGrd(sqlstr, ResultGrid) Session(sqlstr) = sqlstr End If End Sub Private Sub button1_Click(ByVal sender As , ByVal e As ) Handles Dim sign As String = If = True Then sign = % End If Dim sqlstr As String = select * from BookInfo where 1=1 sqlstr += and + + like 39。CREATE TRIGGER BookidChangeON BOOKINFOAFTER UPDATEASIF UPDATE(bookid) BEGIN DECLARE book_id as int DECLARE old_book_id as int SELECT book_id=bookid inserted SELECT old_book_id =bookid deletedUpdate LENDINFOSET = book_idWHERE LENDINFO. bookid = old_book_idENDCREATE TRIGGER UserIdChangesON USERSAFTER UPDATEASIF UPDATE(userid) BEGIN DECLARE user_id as int DECLARE old_user_id as int SELECT user_id =userid inserted SELECT old_user_id = userid deletedUpdate LENDINFOSET LENDINFO. userid = user_idWHERE LENDINFO. userid = old_user_idEND五、 使用ER/STUDIO完成數(shù)據(jù)庫(kù)設(shè)計(jì)六、 代碼實(shí)現(xiàn) “圖書(shū)管理系統(tǒng)”的功能模塊圖系統(tǒng)主界面：Imports Imports Public Class searchN Inherits Private connectingstring As String Private myConn As SqlConnection Private ds As DataSet Private myAdapter As SqlDataAdapter Protected WithEvents HyperLink1 As Protected WithEvents radiobutton1 As Protected WithEvents dropdownlist1 As Protected WithEvents button1 As Private myCmd As SqlCommand Public Sub Open() () End Sub Public Sub Close() () End Sub Public Sub Fill(ByVal sqlstr As String) myAdapter = New SqlDataAdapter(sqlstr, myConn) ds = New DataSet (ds) End Sub Private Sub Page_Load(ByVal sender As , ByVal e As ) Handles 39。CREATE TABLE users ( userid int(4) NOT NULL UNIQUE , username char(10) , pass char(10) , char(50) , phone char(10) , address varchar(50) , BookNum int(4) )。3． 借閱信息表（LENDINFO）：ID、用戶ID、圖書(shū)ID、借閱時(shí)間、歸還時(shí)間、歸還與否。t little, this text introduced under the Visual the environment adoption from top to bottom total programming, from the detailed process that bottom but up applied development develop this system, bring up to realize the basic target that share of management, resources of library information, from the step that but the push head into the arithmetic figure of the library, and shows the system construction design and function design, from the books of store in warehouse to register the search to view, books that issue from library card to angle of borrow , bee a the whole automation the management the mode, and proceeds careful explain from the software engineering science .Key words：library management system, angle of borrow, ASP, Access 目錄 摘要 .......................................................................................................................I Abstract ..............................................................................................................II 目錄 .....................................................................................................................III 前言 ......................................................................................................................1一、 設(shè)計(jì)的目的和內(nèi)容 ......1二、 系統(tǒng)需求分析 1三、 系統(tǒng)總體設(shè)計(jì) 1 總體功能結(jié)構(gòu)圖 1 系統(tǒng)流程圖 2四、 數(shù)據(jù)庫(kù)設(shè)計(jì) 3 需求分析及數(shù)據(jù)字典 3 概念設(shè)計(jì) 4 邏輯設(shè)計(jì) 5 物理設(shè)計(jì) 6 SQL語(yǔ)句的實(shí)現(xiàn) 6 創(chuàng)建視圖 7 創(chuàng)建存儲(chǔ)過(guò)程 8 創(chuàng)建觸發(fā)器 9五、 使用ER/STUDIO完成數(shù)據(jù)庫(kù)設(shè)計(jì) 10六、 代碼實(shí)現(xiàn) 11 “圖書(shū)管理系統(tǒng)”的功能模塊圖 11 插入功能的實(shí)現(xiàn) 11 11 查詢功能的實(shí)現(xiàn) 11 總結(jié) 30 前言 隨著電子計(jì)算機(jī)和通信技術(shù)的發(fā)展，人類已經(jīng)逐漸地進(jìn)入信息化社會(huì)。成都理工大學(xué)工程技術(shù)學(xué)院畢業(yè)論文