.NET+SQL SERVER 2000图书管理系统流程图+功能图+ER+全套设计论文 第7页

IF UPDATE(userid)

  BEGIN

     DECLARE @user_id as int

     DECLARE @old_user_id as int

     SELECT @ user_id =userid inserted

     SELECT @ old_user_id = userid deleted

Update LENDINFO

SET LENDINFO. userid =@ user_id

WHERE LENDINFO. userid =@ old_user_id

END

五、 使用ER/STUDIO完成数据库设计

优、 代码实现

6.1 “图书管理系统”的功能模块图

系统主界面：

Imports System.Data.SqlClient

Imports System.IO

Public Class searchN

    Inherits System.Web.UI.Page

    Private connectingstring As String

    Private myConn As SqlConnection

    Private ds As DataSet

    Private myAdapter As SqlDataAdapter

    Protected WithEvents HyperLink1 As System.Web.UI.WebControls.HyperLink

    Protected WithEvents radiobutton1 As System.Web.UI.WebControls.RadioButton

    Protected WithEvents dropdownlist1 As System.Web.UI.WebControls.DropDownList

    Protected WithEvents button1 As System.Web.UI.WebControls.Button

    Private myCmd As SqlCommand

    Public Sub Open()

        myConn.Open()

    End Sub

    Public Sub Close()

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ... 下一页  >>