Login.aspxusing 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(""); }}
图片上传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(""); } 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(""); } else { Response.Write(""); } } }}
在线统计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#" %>
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 中显示一下当前在线人数