如何在ASP.NET和SQL Server数据库中使用jQuery星级评级插件

using System;
using System.Web.UI;

public partial class _Default : Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        // 引入jQuery和jQuery Raty插件
        Page.ClientScript.RegisterClientScriptInclude("jquery", "https://code.jquery.com/jquery-3.6.0.min.js");
        Page.ClientScript.RegisterClientScriptInclude("raty", "https://cdnjs.cloudflare.com/ajax/libs/raty/2.7.0/jquery.raty.min.js");
    }
}

<div id="rating"></div><script>
    $(function() {
        // 初始化评分控件
        $('#rating').raty({
            score: 0, // 初始分数
            number: 5, // 星星数量
            click: function(score, evt) {
                // 处理评分数据的代码
            }
        });
    });
</script>

protected void Page_Load(object sender, EventArgs e)
{
    // 引入jQuery和jQuery Raty插件
    Page.ClientScript.RegisterClientScriptInclude("jquery", "https://code.jquery.com/jquery-3.6.0.min.js");
    Page.ClientScript.RegisterClientScriptInclude("raty", "https://cdnjs.cloudflare.com/ajax/libs/raty/2.7.0/jquery.raty.min.js");

    // 处理评分数据的代码
    Page.ClientScript.RegisterStartupScript(this.GetType(), "raty", "$(function() { $('#rating').raty({ score: 0, number: 5, click: function(score, evt) { $.ajax({ url: 'save_rating.ashx', type: 'POST', data: { score: score }, success: function(response) { alert('评分已保存！'); } }); } }); });", true);
}

using System;
using System.Data.SqlClient;
using System.Web;

public class SaveRatingHandler : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        // 获取评分数据
        int score = int.Parse(context.Request.Form["score"]);

        // 连接到SQL Server数据库
        string connectionString = "Data Source=localhost;Initial Catalog=mydatabase;User ID=myusername;Password=mypassword";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            // 插入评分数据
            string sql = "INSERT INTO ratings (score) VALUES (@score)";
            using (SqlCommand command = new SqlCommand(sql, connection))
            {
                command.Parameters.AddWithValue("@score", score);
                connection.Open();
                command.ExecuteNonQuery();
            }
        }

        // 返回成功消息
        context.Response.ContentType = "text/plain";
        context.Response.Write("评分已保存！");
    }

    public bool IsReusable
    {
        get { return false; }
    }
}