ASPNET程序设计图书馆管理系统.doc

泉州师范学院ASP.NET程序设计图书馆管理系统学 号： 111303048 姓 名： 刘佳 学 院： 数计学院 专 业： 信息管理与信息系统 班 级： 11级 成 绩： 71 背景与目的 ASP.NET课程设计是本学期的一本很重要的专业课，本次课程设计就是为了检测本学期对这本书的掌握情况。本次课程设计也将作为期末考评。2 开发环境与开发工具 网站开发环境：Microsoft Visual Studio 2008集成开发环境。 网站开发语言：C#。 数据库：Microsoft Visual Studio 2008内置数据库。 开发环境运行平台：Windows xp。3 主要功能 主要实现了简单的登录功能、注册功能和基本的增删查改的功能。4 设计与实现4.1 数据库设计与实现 表1 管理员表表2 读者信息表表3图书信息表表4借还表表54.2 系统设计与实现4.2.1构建网站配置文件、全局文件。 配置文件关键代码：4.2.2读者页面设计代码public partial class _Default : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if(!IsPostBack) this.Get_Connection(); protected void Get_Connection() string s_conn = System.Configuration.ConfigurationManager.AppSettingsconn.ToString(); SqlConnection conn = new SqlConnection(s_conn); string sql = select * from BookInfo,Reader,lendinfo where reader.readerid =lendinfo.rid and bookinfo.id=lendinfo.bid and readerid=+Sessionreaderid.ToString()+; SqlDataAdapter adp = new SqlDataAdapter(sql, conn); DataSet ds = new DataSet(); adp.Fill(ds); DataView dv = ds.Tables0.DefaultView; /dv.Sort = ViewStatesort.ToString() + + ViewStatedire.ToString(); this.GridView1.DataSource = ds; this.GridView1.DataBind(); protected void bindReader() string s_conn = System.Configuration.ConfigurationManager.AppSettingsconn.ToString(); SqlConnection conn = new SqlConnection(s_conn); string BookID = TextBox1.Text.ToString(); string bookSql = select * from bookinfo where ID= + BookID + ; SqlDataAdapter adp = new SqlDataAdapter(bookSql, conn); DataSet ds = new DataSet(); adp.Fill(ds); this.GridView2.DataSource = ds; this.GridView2.DataBind(); protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) this.bindReader(); protected void GridView2_RowUpdated(object sender, GridViewUpdatedEventArgs e) public void bind() string s_conn = System.Configuration.ConfigurationManager.AppSettingsconn.ToString(); SqlConnection conn = new SqlConnection(s_conn); string sqlstr = select * from BookInfo; SqlDataAdapter myda = new SqlDataAdapter(sqlstr, conn); DataSet myds = new DataSet(); conn.Open(); myda.Fill(myds, BookInfo); GridView1.DataSource = myds; GridView1.DataKeyNames = new string id ; GridView1.DataBind(); conn.Close(); 4.2.3借还管理页面设计代码public partial class LendReturn : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) this.BindGriview(); protected void BindGriview() string s_conn = System.Configuration.ConfigurationManager.AppSettingsconn.ToString(); SqlConnection conn = new SqlConnection(s_conn); string sql = select * from lendinfo; SqlDataAdapter adp = new SqlDataAdapter(sql, conn); DataSet ds = new DataSet(); adp.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) string lendinfo = this.GridView1.DataKeyse.RowIndex.Value.ToString(); string delete_sql = delete from lendinfo where bid= + lendinfo + ; /string delete_sql = delete from bookinfo where id= + bookinfo + ; string s_conn = System.Configuration.ConfigurationManager.AppSettingsconn.ToString(); SqlConnection conn = new SqlConnection(s_conn); SqlCommand cmd = new SqlCommand(delete_sql, conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); this.bind(); protected void Button1_Click(object sender, EventArgs e) string BID = this.TextBox1.Text.Trim(); string RID = this.TextBox2.Text.Trim(); string lenddate = System.DateTime.Now.ToString(); string returndate = System.DateTime.Now.AddDays(10).ToString(); string s_conn = System.Configuration.ConfigurationManager.AppSettingsconn.ToString(); string sql = insert into Lendinfo(BID,RID,lenddate,returndate) values( + BID + , + RID + , + lenddate + , + returndate + ); SqlConnection conn = new SqlConnection(s_conn); SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); this.bind(); Response.Write(借阅成功); this.bind(); public void bind() string s_conn = System.Configuration.ConfigurationManager.AppSettingsconn.ToString(); SqlConnection conn = new SqlConnection(s_conn); string sqlstr = select * from lendinfo; SqlDataAdapter myda = new SqlDataAdapter(sqlstr, conn); DataSet myds = new DataSet(); conn.Open(); myda.Fill(myds, lendinfo); GridView1.DataSource = myds; GridView1.DataKeyNames = new string BID ; GridView1.DataBind(); conn.Close(); protected void Button2_Click(object sender, EventArgs e) Response.Redirect(manager.a