WebService数据库操作

来源：互联网发布：java三年简历编辑：程序博客网时间：2024/05/16 23:48

using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
public Service () {

        //如果使用设计的组件，请取消注释以下行
        //InitializeComponent();
    }
    //数据库链接字符串
    string ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
    [WebMethod]
    public string HelloWorld() {
        return "Hello World";
    }
    [WebMethod]
    /// <summary>
    /// 返回数据集
    /// </summary>
    /// <param name="strSql"></param>
    /// <returns></returns>
    public DataSet returnData(string strSql)
    {
        using (SqlConnection conn = new SqlConnection(ConnectionString))
        {
            //创建一个数据集
            DataSet ds = new DataSet();
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
          // conn.Open();
            //创建sqldataadapter对象
             SqlDataAdapter adp = new SqlDataAdapter(strSql, conn);

           adp.Fill(ds, "table");
           //adp.Dispose();
           return ds;
        }

    }

    [WebMethod]
    /// <summary>
    /// 返回数据表
    /// </summary>
    /// <param name="strSql"></param>
    /// <returns></returns>
    public DataTable returnDataTable(string strSql)
    {
        DataTable dt = new DataTable();
        DataSet ds = returnData(strSql);

        if (ds != null && ds.Tables["table"].Rows.Count != 0)
        {
            dt = ds.Tables["table"];
        }
        return dt;
    }
    [WebMethod]
    /// <summary>
    /// 执行数据库语句
    /// </summary>
    /// <param name="strSql"></param>
    public void ExecuteSql(string strSql)
    {
        using (SqlConnection conn = new SqlConnection(ConnectionString))
        {
             if (conn.State != ConnectionState.Open)
              {
                conn.Open();
              }
                SqlCommand cmd = new SqlCommand(strSql, conn);
                cmd.ExecuteNonQuery();
                //conn.Close();

        }

    }

    [WebMethod]
    /// <summary>
    /// 返回一个数据
    /// </summary>
    /// <param name="strSql"></param>
    /// <returns></returns>
    public string ExecuteScalar(string strSql)
    {
        string tmp = "";
        using (SqlConnection conn = new SqlConnection(ConnectionString))
        {
            if (conn.State != ConnectionState.Open)
             {
               conn.Open();
             }
            SqlCommand cmd = new SqlCommand(strSql, conn);
            tmp = cmd.ExecuteScalar().ToString();
            return tmp;
        }
    }
    [WebMethod]
    /// <summary>
    /// 判断数据是否存在
    /// </summary>
    /// <param name="strSql"></param>
    /// <returns></returns>
    public bool HasData(string strSql)
    {
        using (SqlConnection conn = new SqlConnection(ConnectionString))
        {
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            SqlCommand cmd = new SqlCommand(strSql, conn);
            SqlDataReader dr = cmd.ExecuteReader();
            bool flag = dr.Read();
            conn.Close();
            return flag;
        }
      }

}