mini微博

【实例简介】

改良版迷你微博

【核心代码】

USE [WeiBoDb]
GO
/****** Object:  Table [dbo].[Z_MESSAGE]    Script Date: 2015/4/21 10:39:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Z_MESSAGE](
[msg_id] [int] IDENTITY(1,1) NOT NULL,
[user_id] [int] NOT NULL,
[msg_content] [nvarchar](140) NOT NULL,
[reply_count] [int] NOT NULL,
[post_time] [datetime] NOT NULL,
 CONSTRAINT [PK_Z_MESSAGE] PRIMARY KEY CLUSTERED 
(
[msg_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Z_REPLY]    Script Date: 2015/4/21 10:39:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Z_REPLY](
[reply_id] [int] IDENTITY(1,1) NOT NULL,
[msg_id] [int] NOT NULL,
[reply_user_id] [int] NOT NULL,
[src_user_id] [int] NOT NULL,
[reply_content] [nvarchar](140) NULL,
[reply_time] [datetime] NOT NULL,
 CONSTRAINT [PK_Z_REPLY] PRIMARY KEY CLUSTERED 
(
[reply_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Z_USER]    Script Date: 2015/4/21 10:39:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Z_USER](
[user_id] [int] IDENTITY(1,1) NOT NULL,
[user_name] [nvarchar](50) NOT NULL,
[user_login] [varchar](50) NOT NULL,
[user_password] [varchar](20) NOT NULL,
[user_sex] [varchar](2) NOT NULL,
[user_photo] [image] NULL,
[user_email] [varchar](32) NULL,
[regist_time] [datetime] NOT NULL,
[user_address] [nvarchar](64) NULL,
[user_birthday] [datetime] NULL,
[user_telephone] [varchar](16) NULL,
[home_url] [varchar](20) NOT NULL,
[user_info] [nvarchar](64) NULL,
 CONSTRAINT [PK_Z_USER] PRIMARY KEY CLUSTERED 
(
[user_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING ON
GO
/****** Object:  Table [dbo].[Z_USER_FUN]    Script Date: 2015/4/21 10:39:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Z_USER_FUN](
[fun_id] [int] IDENTITY(1,1) NOT NULL,
[user_id] [int] NOT NULL,
[fun_user_id] [int] NOT NULL,
 CONSTRAINT [PK_Z_USER_FUN] PRIMARY KEY CLUSTERED 
(
[fun_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Z_MESSAGE] ADD  CONSTRAINT [DF_Z_MESSAGE_post_time]  DEFAULT (getdate()) FOR [post_time]
GO
ALTER TABLE [dbo].[Z_REPLY] ADD  CONSTRAINT [DF_Z_REPLY_reply_time]  DEFAULT (getdate()) FOR [reply_time]
GO
ALTER TABLE [dbo].[Z_USER] ADD  CONSTRAINT [DF_Z_USER_regist_time]  DEFAULT (getdate()) FOR [regist_time]
GO
ALTER TABLE [dbo].[Z_REPLY]  WITH CHECK ADD  CONSTRAINT [FK_Z_REPLY_Z_MESSAGE] FOREIGN KEY([msg_id])
REFERENCES [dbo].[Z_MESSAGE] ([msg_id])
GO
ALTER TABLE [dbo].[Z_REPLY] CHECK CONSTRAINT [FK_Z_REPLY_Z_MESSAGE]
GO
ALTER TABLE [dbo].[Z_USER_FUN]  WITH CHECK ADD  CONSTRAINT [FK_Z_USER_FUN_Z_USER] FOREIGN KEY([user_id])
REFERENCES [dbo].[Z_USER] ([user_id])
GO
ALTER TABLE [dbo].[Z_USER_FUN] CHECK CONSTRAINT [FK_Z_USER_FUN_Z_USER]
GO
ALTER TABLE [dbo].[Z_USER_FUN]  WITH CHECK ADD  CONSTRAINT [FK_Z_USER_FUN_Z_USER1] FOREIGN KEY([fun_user_id])
REFERENCES [dbo].[Z_USER] ([user_id])
GO
ALTER TABLE [dbo].[Z_USER_FUN] CHECK CONSTRAINT [FK_Z_USER_FUN_Z_USER1]
GO

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Security.Cryptography;

public partial class MasterPage : System.Web.UI.MasterPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["user_login"] == null)//如果用户没有登录
        {//显示Panel1，隐藏Panel2            
            Panel1.Visible = true;
            Panel2.Visible = false;
        }
        else
        {//登录成功隐藏Panel1，显示Panel2            
            Panel1.Visible = false;
            Panel2.Visible = true;
        }
    }
    protected void btnLogin_Click(object sender, EventArgs e)
    {
        Zuser user = new Zuser();
        MD5CryptoServiceProvider MD5CSP = new MD5CryptoServiceProvider();//MD5加密
        byte[] MD5Source = System.Text.Encoding.UTF8.GetBytes(userPwd.Text);
        byte[] MD5Out = MD5CSP.ComputeHash(MD5Source);//加密后的密码
        if (user.login(userLogin.Text, userPwd.Text))//Convert.ToBase64String(MD5Out)))
        {
            //设置Session;
            Session["user_login"] = userLogin.Text;
            Session["user_id"] = user.user_id;
            Session["user_name"] = user.user_name;
            Session["user"] = user;
            Panel2.Visible = true;
            Panel1.Visible = false;
            Response.Redirect(Request.Path "?" Request.QueryString);
        }
        else
        {
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "warning", "alert(\"" user.errorMsg "\");", true);
        }
    }
}