Jquery Ajax案例

最新推荐文章于 2024-03-13 07:00:00 发布

ptspzy

最新推荐文章于 2024-03-13 07:00:00 发布

阅读量537

点赞数

分类专栏： asp-net 文章标签： asp-net jquery ajax ado-net

本文链接：https://blog.csdn.net/ptspzy/article/details/46771883

版权

asp-net 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

$(function () {
        $.ajax({
            type: "POST",//提交方法
            url: "Hotel.ashx",//后台处理文件地址
            datatype: "json",//返回数据类型
            async: false,
            data: {//提交数据
                "method": "NearHotel", "cityNum": cityNum
            },
            success: function (data) {
                var json = eval('(' + data + ')');
                var htmlStr = "";
                for (var j = 0; j < json.length; j++) {
                    htmlStr += parseInt(json[j].Price) + '元';
                }
                $("#Hspot" + i + " tr").html(htmlStr);
            },
            error: function () {
                //alert("ajax有错！");
            }
        });
    });

一般处理文件.ashx代码：

public class createPlan : IHttpHandler {

    public void ProcessRequest (HttpContext context) {
        context.Response.ContentType = "text/plain";
        string returnStr = chooseStr(context);
        context.Response.Write(returnStr);
    }
    public static string chooseStr(HttpContext context)
    {
        string str = context.Request.Form["method"];
        switch (str)
        {
            case "createPlan":
                return CreatePlan.createPlan(context);
            case "popupInfo":
                return CreatePlan.popupInfo(context);
            case "popupCityInfo":
                return CreatePlan.popupCityInfo(context);
            case "NearInfo":
                return CreatePlan.NearInfo(context);
            case "UpdateHeat":
                return CreatePlan.UpdateHeat(context);
        }
        return ("服务没有找到方法" + str);
    }
    public bool IsReusable {
        get {
            return false;
        }
    }

}

类CreatePlan.cs代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;

/// <summary>
/// CreatePlan 的摘要说明
/// </summary>
public class CreatePlan
{
    public CreatePlan()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }
    /*更新热点热度*/
    public static string UpdateHeat(HttpContext context)
    {
        string cityname = context.Request["name"];
        string sql = "UPDATE TourNav SET Heat = Heat + 1 WHERE Name = '" + cityname + "'";
        int i = SqlDb.ExecuteUpdateSql(sql);
        return "";
    }

    /*将表转化为json串*/
    public static string GetTableToJson(DataTable dt)
    {
        string str = "[";
        int rows = 0;
        int rowscount = dt.Rows.Count;
        while (rows < rowscount)
        {
            str += "{";
            int cols = 0;
            int colscount = dt.Columns.Count;
            while (cols < colscount)
            {
                string str3 = str;
                str = str3 + "\"" + dt.Columns[cols].ColumnName + "\":\"" + ((dt.Rows[rows][cols] != DBNull.Value) ? dt.Rows[rows][cols].ToString().Trim().Replace(@"\r", "") : "") + "\",";
                cols++;
            }
            str = str.Substring(0, str.Length - 1) + "},";
            rows++;
        }
        str = str.Substring(0, str.Length - 1) + "]";
        if (dt.Rows.Count > 0)
        {
            return str;
        }
        return string.Empty;
    }
}

SqlDB.cs代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;

/// <summary>
///SqlDb 的摘要说明
/// </summary>
public class SqlDb
{
    private static string CONNECTION_STRING = @"Data Source=你的ip地址; Initial Catalog=DBname;Integrated Security=false;User ID=sa;Password=sa;";
    public SqlDb()
    {
        //
        //TODO: 在此处添加构造函数逻辑
        //
    }
    public static DataSet ExecuteSelectSql(string strSql)
    {
        SqlConnection conn = new SqlConnection(CONNECTION_STRING);
        SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
        DataSet ds = new DataSet();
        try
        {
            da.Fill(ds);
            return ds;
        }
        catch (Exception ex)
        {
            throw new Exception("执行SQL出现错误：\r\n" + strSql + "\r\n" + ex.ToString());
        }
        finally
        {
            conn.Close();
        }
    }
    public static int ExecuteUpdateSql(string strSql)
    {

        SqlConnection conn = new SqlConnection(CONNECTION_STRING);
        SqlCommand comm = new SqlCommand();
        comm.Connection = conn;
        comm.CommandType = CommandType.Text;
        comm.CommandText = strSql;
        int ret = -1;
        try
        {
            conn.Open();
            ret = comm.ExecuteNonQuery();

            return ret;
        }
        catch (Exception ex)
        {
            throw new Exception("执行SQL出现错误：\r\n" + strSql + "\r\n" + ex.ToString());
        }
        finally
        {
            conn.Close();
        }

        //throw new NotImplementedException();
    }
    public static int ExecuteInsertSql(string strSql)
    {
        int ret = -1;
        SqlConnection conn = new SqlConnection(CONNECTION_STRING);
        SqlCommand comm = new SqlCommand();
        comm.Connection = conn;
        comm.CommandType = CommandType.Text;
        comm.CommandText = strSql;
        try
        {
            conn.Open();
            ret = comm.ExecuteNonQuery();
            return ret;
        }
        catch (Exception ex)
        {
            throw new Exception("执行sql出现错误:\r\n" + strSql + "\r\n" + ex.ToString());
        }
        finally
        {
            conn.Close();
        }
    }
}

SqlDbHelper.cs

/// <summary>
/// 此处有两个数据库连接
/// CONNECTION_STRING连接YN库，对应ExecuteSelectSql、ExecuteNonQuerySql两个方法
/// CONNECTION_STRING1连接CYZN库，对应ExecuteSelectSql1、ExecuteNonQuerySql1两个方法
/// 使用时注意！！！！
/// </summary>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;

/// <summary>
/// SqlDbHelper 的摘要说明
/// </summary>
public class SqlDbHelper
{
    public SqlDbHelper()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }
    private static string CONNECTION_STRING = @"Data Source=172.17.130.225; Initial Catalog=YN;Integrated Security=false;User ID=sa;Password=sa;";
    /// <summary>
    /// 执行返回数据集的查询sql语句
    /// </summary>
    /// <param name = strsql >sql语句</param>
    /// <param name = pars>参数数组</param>
    /// <returns>查询数据集</returns>
    public static DataSet ExecuteSelectSql(string strSql, params SqlParameter[] pars) 
    {
        DataSet ds = new DataSet();
        SqlConnection conn = new SqlConnection(CONNECTION_STRING);
        SqlCommand comm = new SqlCommand(strSql, conn);
        try
        {
            try
            {
                comm.Parameters.AddRange(pars);
                conn.Open();
                SqlDataAdapter da = new SqlDataAdapter(comm);
                da.Fill(ds);
            }
            catch (SqlException exception)
            {
                throw new Exception(exception.Message);
            }
            return ds;
        }
        finally
        {
            comm.Dispose();
            conn.Close();
            conn.Dispose();
        }
    }
    /// <summary>
    /// 执行仅要求返回影响行数的sql语句
    /// </summary>
    /// <param name = strsql >sql语句</param>
    /// <param name = pars>参数数组</param>
    /// <returns>影响行数</returns>
    public static int ExecuteNonQuerySql(string strSql, params SqlParameter[] pars)
    {
        int ret = -1;
        SqlConnection conn = new SqlConnection(CONNECTION_STRING);
        SqlCommand comm = new SqlCommand(strSql, conn);
        try
        {
            try
            {
                comm.Parameters.AddRange(pars);
                conn.Open();
                ret = comm.ExecuteNonQuery();
            }
            catch (SqlException exception)
            {
                throw new Exception(exception.Message);
            }
            return ret;
        }
        finally
        {
            comm.Dispose();
            conn.Close();
            conn.Dispose();
        }
    }  
    private static string CONNECTION_STRING = @"Data Source=知己ip; Initial Catalog=DBname;Integrated Security=false;User ID=sa;Password=sa;";
    /// <summary>
    /// 执行返回数据集的查询sql语句
    /// </summary>
    /// <param name = strsql >sql语句</param>
    /// <param name = pars>参数数组</param>
    /// <returns>查询数据集</returns>
    public static DataSet ExecuteSelectSql1(string strSql, params SqlParameter[] pars)
    {
        DataSet ds = new DataSet();
        SqlConnection conn = new SqlConnection(CONNECTION_STRING1);
        SqlCommand comm = new SqlCommand(strSql, conn);
        try
        {
            try
            {
                comm.Parameters.AddRange(pars);
                conn.Open();
                SqlDataAdapter da = new SqlDataAdapter(comm);
                da.Fill(ds);
            }
            catch (SqlException exception)
            {
                throw new Exception(exception.Message);
            }
            return ds;
        }
        finally
        {
            comm.Dispose();
            conn.Close();
            conn.Dispose();
        }
    }
    /// <summary>
    /// 执行仅要求返回影响行数的sql语句
    /// </summary>
    /// <param name = strsql >sql语句</param>
    /// <param name = pars>参数数组</param>
    /// <returns>影响行数</returns>
    public static int ExecuteNonQuerySql1(string strSql, params SqlParameter[] pars)
    {
        int ret = -1;
        SqlConnection conn = new SqlConnection(CONNECTION_STRING);
        SqlCommand comm = new SqlCommand(strSql, conn);
        try
        {
            try
            {
                comm.Parameters.AddRange(pars);
                conn.Open();
                ret = comm.ExecuteNonQuery();
            }
            catch (SqlException exception)
            {
                throw new Exception(exception.Message);
            }
            return ret;
        }
        finally
        {
            comm.Dispose();
            conn.Close();
            conn.Dispose();
        }
    }
}