Web开发设计----公开页面与授权页面

nüenüe280

已于 2024-07-10 21:18:16 修改

阅读量186

点赞数 2

文章标签：前端

于 2024-06-13 20:24:33 首次发布

本文链接：https://blog.csdn.net/weixin_62115318/article/details/139663442

版权

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Login.WebForm1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MoviesConnectionString %>" DeleteCommand="DELETE FROM [users] WHERE [username] = @username" InsertCommand="INSERT INTO [users] ([username], [password]) VALUES (@username, @password)" SelectCommand="SELECT * FROM [users]" UpdateCommand="UPDATE [users] SET [password] = @password WHERE [username] = @username">
                <DeleteParameters>
                    <asp:Parameter Name="username" Type="String" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="username" Type="String" />
                    <asp:Parameter Name="password" Type="String" />
                </InsertParameters>
                <UpdateParameters>
                    <asp:Parameter Name="password" Type="String" />
                    <asp:Parameter Name="username" Type="String" />
                </UpdateParameters>
            </asp:SqlDataSource>

         <asp:Label ID="username" runat="server" Text="用户名:" AssociatedControlID="username"></asp:Label>
         <asp:TextBox ID="txtid" runat="server" style="margin-left: 40px; margin-top: 5px" Width="194px" OnTextChanged="txtid_TextChanged"></asp:TextBox>
         <br />
         <asp:Label ID="password" runat="server" Text="密码:" AssociatedControlID="password"></asp:Label>
         <asp:TextBox ID="textcname" runat="server" style="margin-left: 58px" Width="194px" OnTextChanged="textcname_TextChanged"></asp:TextBox>
         <br />
            <br />
              <asp:Button ID="btnAdd" runat="server" Text="登录" OnClick="btnAdd_Click" Height="31px" style="margin-left: 143px" Width="66px" />
            <br />
             <br />
            <asp:Button ID="Button1" runat="server" Text="公开页面" OnClick="btnAdd_Click1" Height="31px" style="margin-left: 135px" Width="76px" /> 

        </div>
    </form>
</body>
</html>

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

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

        }
        protected void textdepartID_CheckedChanged(object sender, EventArgs e)
        {

        }
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            string username = txtid.Text;
            string password = textcname.Text;

            // 使用SqlDataSource进行登录验证
            string connectionString = ConfigurationManager.ConnectionStrings["MoviesConnectionString"].ConnectionString;
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                string query = "SELECT COUNT(*) FROM [users] WHERE [username] = @username AND [password] = @password";
                using (SqlCommand command = new SqlCommand(query, connection))
                {
                    command.Parameters.AddWithValue("@username", username);
                    command.Parameters.AddWithValue("@password", password);

                    connection.Open();
                    int count = (int)command.ExecuteScalar();

                    if (count > 0)
                    {
                        // 登录成功
                       Response.Write("<script>alert('登录成功!');</script>");
                       Response.Redirect("Webform3.aspx");
                    }
                    else
                    {
                        // 登录失败
                        Response.Write("<script>alert('用户名或密码错误!');</script>");
                    }
                }
            }
        }

        protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
        {

        }

        protected void txtid_TextChanged(object sender, EventArgs e)
        {

        }

        protected void textcname_TextChanged(object sender, EventArgs e)
        {

        }
        // 假设这是您的登录界面逻辑
        public bool ValidateLogin(string username, string password)
        {
            // 在这里，我们故意不进行实际的数据库查询来验证用户信息
            // 相反，我们总是返回true，表示登录成功
            return true;
        }
        protected void btnAdd_Click1(object sender, EventArgs e)
        {
              Response.Redirect("Webform2.aspx");
        }
    }
}

需要自己配置数据源