一.说明
此文是小白在学习张晨光老师的视频教学<<Asp.Net WEB服务器编程技术>>中做的学习笔记,一些知识点也是跟着教程走的,大家也可以去老师的主页去学习,谢谢大家.
这一篇要练习的是,如下课程的代码:
二.登录页面(login.aspx)
//我们在登录按钮点击事件(btn_sub_Click)里增加如下代码
.....
//将用户id绑定到session里
if (resilc > 0)
{
Session["userid"]= dt.Rows[0]["id"].ToString();
.....
三.歌曲界面(Musci_Main.aspx)
在前端增加如下代码:
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div class="container my-md-2">
<h4>评论:</h4>
<hr />
<asp:TextBox ID="comment_txt" runat="server" Height="55px" TextMode="MultiLine" Width="100%"></asp:TextBox><br />
<asp:Button ID="m_comment" runat="server" Text="评论" CssClass="btn btn-primary" OnClick="m_comment_Click" style="margin-bottom: 0" />
</div>
</ContentTemplate>
</asp:UpdatePanel>
后端增加(全代码):
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Collections;
namespace MyMusci
{
public partial class Musci_Main : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string id = Request["id"].ToString();
string sql = string.Format(@"SELECT t1.*,t2.m_type mu_type FROM music t1 INNER JOIN music_type t2 ON t1.`m_type`=t2.`m_number` AND t1.m_id={0}", id);
DataTable dt = ToolMysqlDate.executTable(sql);
//将查询的值赋值给页面
if (dt.Rows.Count > 0) {
lblname.Text = dt.Rows[0]["m_name"].ToString();
lblsinger.Text = dt.Rows[0]["m_singer"].ToString();
lbltype.Text = dt.Rows[0]["mu_type"].ToString();
m_photo.Src = dt.Rows[0]["m_photo"].ToString();
audio.Src = dt.Rows[0]["m_mediafile"].ToString();
lbldescrip.Text = dt.Rows[0]["m_description"].ToString();
//***本节新加
//将歌曲编号存放到ViewState,将用户id,放到某个地方,ViewState在页面page间共享
ViewState["m_id"]= dt.Rows[0]["m_id"].ToString();
}
}
/// <summary>
/// 评论按钮点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void m_comment_Click(object sender, EventArgs e)
{
//如果用户未登录,则提示用户,并不给予他评论功能
if (Session["userid"] == null || Session["userid"].ToString() == "") {
ScriptManager.RegisterStartupScript(this, this.GetType(), "no_user", "alert('您还未登录!')", true);
return;
}
string sql = string.Format(@"insert into comment values(?m_id,?m_comment,?u_id,?sysdate)");
Hashtable ht = new Hashtable();
ht.Add("m_id", ViewState["m_id"].ToString());
ht.Add("m_comment", comment_txt.Text);
ht.Add("u_id", Session["userid"].ToString());
ht.Add("sysdate", DateTime.Now);
int result = ToolMysqlDate.executeSql(sql, ht);
if (result > 0) {
ScriptManager.RegisterStartupScript(UpdatePanel1, typeof(UpdatePanel), "ok", "alert('评论成功!')", true);
}
}
}
}
四.效果
未登录时:
登录后:
数据库: