C#实现对任一张表的数据进行增,删,改,查要求,运用Webservice,体现出三层架构
1.下面是M层的,其他层的自己写
using System.Data.SqlClient;
public class data
{
private SqlConnection conn;//定义一个数据库连接
private SqlCommand com;//定义执行命令
public data()
{
//在配置文件中设置
conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.AppSettings["connString"].ToString();
}
//打开数据库
public void open()
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
}
//关闭数据库
public void close()
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
//执行数据库操作,返回DataSet
public void getDataSet(string proc,SqlParameter[] parm,out DataSet ds)
{
com = getCommand(proc,parm);
SqlDataAdapter sda = new SqlDataAdapter(com);
ds = new DataSet();
sda.Fill(ds);
}
//返回SqlCommadn
public SqlCommand getCommand(string proc, SqlParameter[] parm)
{
SqlCommand com = new SqlCommand();
com.Connection = conn;
com.CommandType = CommandType.StoredProcedure;
com.CommandText = proc;
foreach (SqlParameter p in parm)
{
com.Parameters.Add(p);
}
return com;
}
//返回DataReader
public SqlDataReader getDataReader(string proc, SqlParameter[] parm)
{
com = getCommand(proc, parm);
return com.ExecuteReader();
}
//执行数据库操作,返回void
public void ExecuteCommand(string proc, SqlParameter[] parm)
{
com = getCommand(proc, parm);
open();
com.ExecuteNonQuery();
close();
}
}
using System.Data.SqlClient;
public class data
{
private SqlConnection conn;//定义一个数据库连接
private SqlCommand com;//定义执行命令
public data()
{
//在配置文件中设置
conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.AppSettings["connString"].ToString();
}
//打开数据库
public void open()
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
}
//关闭数据库
public void close()
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
//执行数据库操作,返回DataSet
public void getDataSet(string proc,SqlParameter[] parm,out DataSet ds)
{
com = getCommand(proc,parm);
SqlDataAdapter sda = new SqlDataAdapter(com);
ds = new DataSet();
sda.Fill(ds);
}
//返回SqlCommadn
public SqlCommand getCommand(string proc, SqlParameter[] parm)
{
SqlCommand com = new SqlCommand();
com.Connection = conn;
com.CommandType = CommandType.StoredProcedure;
com.CommandText = proc;
foreach (SqlParameter p in parm)
{
com.Parameters.Add(p);
}
return com;
}
//返回DataReader
public SqlDataReader getDataReader(string proc, SqlParameter[] parm)
{
com = getCommand(proc, parm);
return com.ExecuteReader();
}
//执行数据库操作,返回void
public void ExecuteCommand(string proc, SqlParameter[] parm)
{
com = getCommand(proc, parm);
open();
com.ExecuteNonQuery();
close();
}
}
【C#实现对任一张表的数据进行增,删,改,查要求,运用Webservice,体现出三层架构】相关文章
1. C#实现对任一张表的数据进行增,删,改,查要求,运用Webservice,体现出三层架构
2. 请解释一下webService? 如何用.net实现webService
3. WebSphere面试题:在WebSphere里面如何部署一个应用
4. 名词解释WEB SERVICE,SOAP,UDDI,WSDL,JAXP,JAXM;JSWDL开发包的介绍。
6. 如何在C# winform中异步调用web services
7. 软件测试LoadRunner面试题:If web server, database and Network are all fine where could be the problem?
8. 介绍一下.NET构架下remoting和webservice
9. 说出你对remoting 和webservice的理解和应用
10. What\'s the difference between Debug and Trace class? (Debug类与Trace类有什么区别)
本文来源:https://www.mianshiwenti.com/a13017.html
进入下载页面
﹝C#实现对任一张表的数据进行增,删,改,查要求,运用Webservice,体现出三层架构﹞相关内容
- 什么是WEB控件?使用WEB控件有哪些优势?
- Weblogic和WebSphere不同特点
- What\'s the difference between an interface and abstract class? (接口与抽象类有什么区别)
- 软件测试LoadRunner面试题:How did you find web server related issues?
- 简述 Application,session,cookie,cache,viewState 的概念,以及相互之间的区别
- Web Service面试题:如何搭建Axis2的开发环境
- 什么是Web Service?
- 如何反序的迭代一个序列?how do I iterate over a sequence in reverse order
- 我的applet原先好好的, 一放到web server就会有问题,为什么?
- 如何打开WebSphere远程debug