ASP。net 测验

Login.aspx

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using DBHelper;

using MySql.Data.MySqlClient;

public partial class Login : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            HttpCookie hc = null;

            if (Request.Cookies["LoginCookie"] != null)

            {

                hc = Request.Cookies["LoginCookie"];

                this.TextBox1.Text = hc["username"];

                this.TextBox2.Text = hc["password"];

                Session.RemoveAll();

            }

        }

    }

    protected void Button2_Click(object sender, EventArgs e)

    {

        string username = this.TextBox1.Text;

        string password = this.TextBox2.Text;

        string sql = "select id,name,password from login where name=@username and password=@password";

        MySqlParameter p1 = new MySqlParameter("@username", username);

        MySqlParameter p2 = new MySqlParameter("@password", password);

        MySqlParameter[] pa = new MySqlParameter[] { p1, p2 };

        MySqlDataReader dr = SqlHelper.ExecuteReaderText(sql, pa);

        while (dr.Read())

        {

            //cookie

            HttpCookie hc = new HttpCookie("LoginCookie");

            hc["id"] = dr[0].ToString();

            hc["username"] = dr[1].ToString();

            hc["password"] = dr[2].ToString();

            hc.Expires = DateTime.Now.AddDays(1);

            Response.Cookies.Add(hc);

            //session

            LoginSession Lseiion = new LoginSession();

            Lseiion.id = dr[0].ToString();

            Lseiion.name = dr[1].ToString();

            Session["LoginSession"] = Lseiion;

            Response.Redirect("Default.aspx");

        }

        Response.Write("<script>alert('密码错误');location.href='Login.aspx'</script>");

    }

}

图片上传

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.IO;

using MySql.Data.MySqlClient;

using DBHelper;

public partial class ImageUpload : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            if (Session["LoginSession"] == null)

            {

                Response.Redirect("Login.aspx");

            }

        }

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        string FileName = FileUpload1.PostedFile.FileName;

        string File_Abbr = Server.MapPath("images/");//路径

        string extion = Path.GetExtension(FileName);//格式

        if (extion != ".jpg")

        {

            Response.Write("<script>alert('您上传的格式不正确')</script>");

        }

        else

        {

            if (!Directory.Exists(File_Abbr))

            {

                Directory.CreateDirectory(File_Abbr);

            }

            string NameTime = DateTime.Now.Ticks.ToString() + extion;

            FileUpload1.SaveAs(File_Abbr + NameTime);

            string sql = "insert into img(imgpath)values(@paths)";

            MySqlParameter[] pa = new MySqlParameter[] { new MySqlParameter("@paths", File_Abbr + NameTime) };

            int i = SqlHelper.ExecteNonQueryText(sql, pa);

            if (i > 0)

            {

                this.Image1.ImageUrl = @"./images/" + NameTime;

                Session["IsSubmit"] = true;

                Response.Write("<script>alert('文件上传成功')</script>");

            }

            else

            {

                Response.Write("<script>alert('文件上传失败')</script>");

            }

        }

    }

}

在线统计

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class Online : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            if (Session["LoginSession"] == null)

            {

                Response.Redirect("Login.aspx");

            }

        }

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        Response.Write("当前在线人数为:" + Application["count"]);

    }

}

应用配置

<%@ Application Language="C#" %>

<script runat="server">

    void Application_Start(object sender, EventArgs e)

    {

        //在应用程序启动时运行的代码

        Application["count"] = 0;

    }

    void Application_End(object sender, EventArgs e)

    {

        //在应用程序关闭时运行的代码

    }

    void Application_Error(object sender, EventArgs e)

    {

        //在出现未处理的错误时运行的代码

    }

    void Session_Start(object sender, EventArgs e)

    {

        //在新会话启动时运行的代码

        Application.Lock();

        Application["count"] = (int)Application["count"] + 1;

        Application.UnLock();

    }

    void Session_End(object sender, EventArgs e)

    {

        //在会话结束时运行的代码。

        // 注意: 只有在 Web.config 文件中的 sessionstate 模式设置为

        // InProc 时，才会引发 Session_End 事件。如果会话模式

        //设置为 StateServer 或 SQLServer，则不会引发该事件。

        Application.Lock();

        Application["count"] = (int)Application["count"] -1;

        Application.UnLock();

    }

</script>

<?xml version="1.0"?>

<!--

  有关如何配置 ASP.NET 应用程序的详细信息，请访问

  http://go.microsoft.com/fwlink/?LinkId=169433

  -->

<configuration>

  <appSettings>

    <add key="con" value="Server=localhost;Database=cjp;Uid=root;Pwd=;charset=utf8;allow zero datetime=true"/>

  </appSettings>

  <system.web>

    <compilation debug="true" targetFramework="4.0"/>

    <customErrors mode="On" defaultRedirect="GenericErrorPage.htm">

      <error statusCode="403" redirect="403.htm" />

      <error statusCode="404" redirect="404.htm" />

    </customErrors>

    <sessionState timeout="300"  mode="InProc" />

  </system.web>

</configuration>