图书馆管理系统(用c#做系统-根据.net所学内容-软件是vs).doc

1.登录界面：
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
string Name = TextBox1.Text;
string Pwd = TextBox2.Text;
if (Name== "admin" && Pwd== "123")
{
Response.Redirect("mainpage.aspx");
}

}

2.图书信息添加：
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection sqlCon = new SqlConnection();
sqlCon.ConnectionString = "Data Source=XP-201209212054\\SQLEXPRESS;Initial Catalog=LibraryM;Integrated Security=True";
sqlCon.Open();
string bkId = this.TextBox1.Text;
string bkName = this.TextBox2.Text;
string bkType = this.DropDownList1.Text;
string writer = this.TextBox3.Text;
string storage = this.TextBox4.Text;
string s = "insert into bookInfo(bookId,bookName,bookType,writer,storage) values('" + bkId + "','" + bkName + "','" + bkType + "','" + writer + "'," + storage + ")";
SqlCommand com = new SqlCommand(s, sqlCon);
int i = com.ExecuteNonQuery();
Response.Redirect("bookInformation.aspx");
protected void Button2_Click(object sender, EventArgs e)
{
this.TextBox1.Text = "";
this.TextBox2.Text = "";
this.DropDownList1.Text = "";
this.TextBox3.Text = "";
}

3.图书归还：ＣＳＳ样式：
body{margin:0px; padding:0px; text-align:center; background-color:#CCFFFF;}

#page{margin-left:auto; margin-right:auto; width:778px;}
#left{margin:0px; padding:0px; }
#left ul{margin:0px; list-style:none;}
#left ul li{font-family:Arial, Helvetica, sans-serif; float:left; width:140px; height:30px;}
#head{width:778px;margin-left:auto; margin-right:auto;}
#text{width:778px;marginleft:auto; margin-right:auto; line-height:130%;}

4.读书信息添加：
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=XP-201209212054\\SQLEXPRESS;Initial Catalog=LibraryM;Integrated Security=True";
con.Open();
string s = "insert into readInfo(ID ,name, Dpartment,class) values('" + this.TextBox1.Text + "','" + this.TextBox2.Text + "','" + this.DropDownList1.Text + "','" + this.TextBox3.Text + "')";
SqlCommand com = new SqlCommand(s, con);
int j = com.ExecuteNonQuery();
Response.Redirect("readerInformation.aspx");

}

protected void Button2_Click(object sender, EventArgs e)
{
this.TextBox1.Text = "";
this.TextBox2.Text = "";
this.DropDownList1.Text = "";
this.TextBox3.Text = "";
}

1.登陆界面和首页两个界面：

2.图书信息添加：