• 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>
    

      

    1、登录页面Login.aspx
    ① 页面加载 ,如果存在用户cookie,那么将cookie中的内容还原到用户名和密码上,
    将存在的session全部删除

    ② 点击登录按钮,数据库验证用户名 和 密码 ,通过后保存cookie,session,然后跳转到主页面Index.aspx

    2、主页面使用Menu控件作为菜单导航

    3、使用页面导航菜单Menu导航到图片上传页面ImageUpload.aspx,session如果不存在或已经过期则跳转到登录页面,将图片上传文件上传到的网站路径image文件夹下,上传成功后,图片在页面上用image控件显示出来。
    图片信息需要保存到数据库

    4、使用页面导航菜单Menu导航到 在线人数统计页面Online.aspx ,session如果不存在或已经过期则跳转到登录页面,在Online.aspx 中显示一下当前在线人数

  • 相关阅读:
    c#剪切板操作
    eclipse mvn build error tips
    Redis Tips
    IntilliJ Idea 使用中的问题与解决方案
    mongo
    python
    SQL Relative
    sybase update
    run current vim file
    git
  • 原文地址:https://www.cnblogs.com/mengluo/p/6026687.html
Copyright © 2020-2023  润新知