loginer.aspx.cs

功能齐全的图书管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
using System.Data.SqlClient;

public partial class Loginer : System.Web.UI.Page
{
    SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }

    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        image1.Visible = false;
        GridView1.Visible = false;
        Panel1.Visible = false;
        Panel2.Visible = false;
        
        Response.Write("<table width=100% top=2px>");
        SqlCommand myCmd = new SqlCommand("select * from book where book_id='" + TextBox1.Text + "'", myConnection);
        myConnection.Open();
        SqlDataReader read = myCmd.ExecuteReader();
        while (read.Read())
        {
            Response.Write("<tr height=50><td bgcolor=eeeeee><div align=center><font style='FONT-SIZE: 15px' color=red>" + read[1].ToString() + "</font></div></td></tr>" + 
                            "<tr height=30><td><font style='FONT-SIZE: 12px'>" + "图书编号：" + read[0].ToString() + "</font></td></tr>" +
                            "<tr height=30><td><font style='FONT-SIZE: 12px'>" + "作者：" + read[2].ToString() + "</font></td></tr>" + 
                            "<tr><td bgcolor=f8f8f8><font style='FONT-SIZE: 12px'>" + "出版社：" + read[3].ToString() + "</font></td></tr>" +
                            "<tr><td bgcolor=f8f8f8><font style='FONT-SIZE: 12px'>" + "出版日期：" + read[4].ToString() + "</font></td></tr>");

        }
        Response.Write("</table>");
        TextBox1.Text = "";
        myConnection.Close();        
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        image1.Visible = false;
        GridView1.Visible = false;
        Panel1.Visible = false;
        Panel2.Visible = false;

        Response.Write("<table width=100% top=2px>");
        SqlCommand myCmd = new SqlCommand("select * from book where book_name='" + TextBox2.Text + "'", myConnection);
        myConnection.Open();
        SqlDataReader read = myCmd.ExecuteReader();
        while (read.Read())
        {
            Response.Write("<tr height=50><td bgcolor=eeeeee><div align=center><font style='FONT-SIZE: 15px' color=red>" + read[1].ToString() + "</font></div></td></tr>" +
                            "<tr height=30><td><font style='FONT-SIZE: 12px'>" + "图书编号：" + read[0].ToString() + "</font></td></tr>" +
                            "<tr height=30><td><font style='FONT-SIZE: 12px'>" + "作者：" + read[2].ToString() + "</font></td></tr>" +
                            "<tr><td bgcolor=f8f8f8><font style='FONT-SIZE: 12px'>" + "出版社：" + read[3].ToString() + "</font></td></tr>" +
                            "<tr><td bgcolor=f8f8f8><font style='FONT-SIZE: 12px'>" + "出版日期：" + read[4].ToString() + "</font></td></tr>");

        }
        Response.Write("</table>");
        TextBox2.Text = "";
        myConnection.Close();
    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {
        image1.Visible = false;
        GridView1.Visible = false;
        Panel1.Visible = false;
        Panel2.Visible = false;

        Response.Write("<table width=100% top=2px>");
        SqlCommand myCmd = new SqlCommand("select * from book where book_author='" + TextBox3.Text + "'", myConnection);
        myConnection.Open();
        SqlDataReader read = myCmd.ExecuteReader();
        while (read.Read())
        {
            Response.Write("<tr height=50><td bgcolor=eeeeee><div align=center><font style='FONT-SIZE: 15px' color=red>" + read[1].ToString() + "</font></div></td></tr>" +
                            "<tr height=30><td><font style='FONT-SIZE: 12px'>" + "图书编号：" + read[0].ToString() + "</font></td></tr>" +
                            "<tr height=30><td><font style='FONT-SIZE: 12px'>" + "作者：" + read[2].ToString() + "</font></td></tr>" +
                            "<tr><td bgcolor=f8f8f8><font style='FONT-SIZE: 12px'>" + "出版社：" + read[3].ToString() + "</font></td></tr>" +
                            "<tr><td bgcolor=f8f8f8><font style='FONT-SIZE: 12px'>" + "出版日期：" + read[4].ToString() + "</font></td></tr>");

        }
        Response.Write("</table>");
        TextBox3.Text = "";
        myConnection.Close();
    }
    protected void LinkButton4_Click(object sender, EventArgs e)
    {
        image1.Visible = false;
        GridView1.Visible = false;
        Panel1.Visible = false;
        Panel2.Visible = false;

        Response.Write("<table width=100% top=2px>");
        SqlCommand myCmd = new SqlCommand("select * from book where book_public='" + TextBox4.Text + "'", myConnection);
        myConnection.Open();
        SqlDataReader read = myCmd.ExecuteReader();
        while (read.Read())
        {
            Response.Write("<tr height=50><td bgcolor=eeeeee><div align=center><font style='FONT-SIZE: 15px' color=red>" + read[1].ToString() + "</font></div></td></tr>" +
                            "<tr height=30><td><font style='FONT-SIZE: 12px'>" + "图书编号：" + read[0].ToString() + "</font></td></tr>" +
                            "<tr height=30><td><font style='FONT-SIZE: 12px'>" + "作者：" + read[2].ToString() + "</font></td></tr>" +
                            "<tr><td bgcolor=f8f8f8><font style='FONT-SIZE: 12px'>" + "出版社：" + read[3].ToString() + "</font></td></tr>" +
                            "<tr><td bgcolor=f8f8f8><font style='FONT-SIZE: 12px'>" + "出版日期：" + read[4].ToString() + "</font></td></tr>");

        }
        Response.Write("</table>");
        TextBox4.Text = "";
        myConnection.Close();
    }
}