accessdbhelper写法.docx
- 文档编号:12681633
- 上传时间:2023-04-21
- 格式:DOCX
- 页数:13
- 大小:16.04KB
accessdbhelper写法.docx
《accessdbhelper写法.docx》由会员分享,可在线阅读,更多相关《accessdbhelper写法.docx(13页珍藏版)》请在冰豆网上搜索。
accessdbhelper写法
publicclassDBAccess/*DBAccess*/
{
stringconStr;
OleDbConnectionconnection;
System.Data.OleDb.OleDbCommandcommand;
System.Data.OleDb.OleDbDataAdapterdataAdapter;
System.Data.OleDb.OleDbDataReaderdataReader;
publicDBAccess/*DBAccess*/()
{
this.conStr=ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
}
publicDBAccess/*DBAccess*/(stringconstr)
{
this.conStr=ConfigurationManager.ConnectionStrings[constr].ConnectionString;
}
法兰厂家
弯头厂家
螺旋管
///
///执行sql语句
///
///
///
publicboolRunSql(stringsql)
{
try
{
connection=newSystem.Data.OleDb.OleDbConnection(conStr);
connection.Open();
command=newSystem.Data.OleDb.OleDbCommand(sql,connection);
intcount=command.ExecuteNonQuery();
connection.Close();
if(count>0)
{
returntrue;
}
elsereturnfalse;
}
catch(Exceptionex)
{
returnfalse;
}
}
///
///简单删除方法
///
///
///
///
publicbooldel(intid,Typetype)
{
stringsql=string.Format("deletefrom{0}whereid={1}",type.Name,id);
returnthis.RunSql(sql);
}
///
///执行带参数的sql语句
///
///
///
///
///
publicboolRunSql(stringsql,System.Data.OleDb.OleDbParameter[]parameters,refstringerror)
{
try
{
connection=newSystem.Data.OleDb.OleDbConnection(conStr);
connection.Open();
command=newSystem.Data.OleDb.OleDbCommand();
command.CommandText=sql;
command.Connection=connection;
command.Parameters.AddRange(parameters);
intcount=command.ExecuteNonQuery();
connection.Close();
if(count>0)
{
returntrue;
}
elsereturnfalse;
}
catch(Exceptionex)
{
error=ex.Message;
Console.WriteLine(ex.Message);
returnfalse;
}
网络机柜
地面防腐
}
///
///通用单表查询方法
///
///
///
///
publicDataTableSelect(stringsql,stringtableName)
{
connection=newSystem.Data.OleDb.OleDbConnection(conStr);
dataAdapter=newSystem.Data.OleDb.OleDbDataAdapter(sql,connection);
DataSetdataSet=newDataSet();
dataAdapter.Fill(dataSet,tableName);
foreach(DataRowrowindataSet.Tables[0].Rows)
{
Console.WriteLine("{0},{1}",row[0],row[1]);
}
returndataSet.Tables[tableName];
}
///
///通用查询方法
///
///
///
///
///
publicList
{
Typetype=typeof(T);
connection=newSystem.Data.OleDb.OleDbConnection(conStr);
connection.Open();
command=newSystem.Data.OleDb.OleDbCommand();
command.CommandTimeout=180;
command.CommandText=sql;
command.Connection=connection;
command.Parameters.AddRange(parameters);
dataReader=command.ExecuteReader();
List
string[]fields=newstring[dataReader.FieldCount];
for(inti=0;i { fields[i]=dataReader.GetName(i); } while(dataReader.Read()) { PropertyInfo[]pros=type.GetProperties(); Objectobj=Activator.CreateInstance(type); foreach(stringstrinfields) { foreach(PropertyInfopropertyinpros) { if(str.ToLower()==property.Name.ToLower()) { if(! Convert.IsDBNull(dataReader[str])) { property.SetValue(obj,dataReader[str],null); } Console.WriteLine(property.GetValue(obj,null)); break; } } } list.Add(((T)obj)); } dataReader.Close(); connection.Close(); if(list.Count==0) { returnnull; } returnlist; } /// ///通用查询方法 /// /// /// /// publicList { Typetype=typeof(T); connection=newSystem.Data.OleDb.OleDbConnection(conStr); connection.Open(); command=newSystem.Data.OleDb.OleDbCommand(sql,connection); dataReader=command.ExecuteReader(); List string[]fields=newstring[dataReader.FieldCount]; for(inti=0;i { fields[i]=dataReader.GetName(i); } while(dataReader.Read()) { PropertyInfo[]pros=type.GetProperties(); Objectobj=Activator.CreateInstance(type); foreach(stringstrinfields) { foreach(PropertyInfopropertyinpros) { if(str.ToLower()==property.Name.ToLower()) { if(! Convert.IsDBNull(dataReader[str])) { property.SetValue(obj,dataReader[str],null); } Console.WriteLine(property.GetValue(obj,null)); break; } } } list.Add(((T)obj)); } dataReader.Close(); connection.Close(); if(list.Count==0) { returnnull; } returnlist; } /// ///通用添加方法 /// /// /// /// publicboolCurrencyAdd(List { for(intj=0;j { identity[j]=identity[j].ToLower(); } Typetype=obj.GetType(); PropertyInfo[]propertyInfos=type.GetProperties(); List stringcolName=string.Empty; stringval=string.Empty; foreach(PropertyInfoproinpropertyInfos) { objectproValue=type.InvokeMember(pro.Name,BindingFlags.GetProperty,null,obj,null); //System.Console.WriteLine(proValue.ToString()); stringname=pro.Name; stringf=name.Substring(0,1).ToLower(); name=f+name.Substring (1); if(! identity.Contains(pro.Name.ToLower())) { if(proValue! =null) { colName+="["+name+"],"; val+="@"+name+","; if(proValue.GetType()==typeof(DateTime)) { System.Data.OleDb.OleDbParameteraaa=newOleDbParameter("@"+name,System.Data.OleDb.OleDbType.Date); aaa.Value=proValue; parameterList.Add(aaa); } else { parameterList.Add(newSystem.Data.OleDb.OleDbParameter("@"+name,proValue)); } } } } System.Data.OleDb.OleDbParameter[]sqlParameters=newSystem.Data.OleDb.OleDbParameter[parameterList.Count]; parameterList.CopyTo(sqlParameters); colName=colName.Substring(0,colName.Length-1); val=val.Substring(0,val.Length-1); stringsql="insertinto["+type.Name+"]("+colName+")values("+val+")"; stringabc=""; returnthis.RunSql(sql,sqlParameters,refabc); } /// ///通用添加方法 /// /// /// /// publicboolCurrencyAdd(List { for(intj=0;j { identity[j]=identity[j].ToLower(); } Typetype=obj.GetType(); PropertyInfo[]propertyInfos=type.GetProperties(); List stringcolName=string.Empty; stringval=string.Empty; foreach(PropertyInfoproinpropertyInfos) { objectproValue=type.InvokeMember(pro.Name,BindingFlags.GetProperty,null,obj,null); //System.Console.WriteLine(proValue.ToString()); stringname=pro.Name; stringf=name.Substring(0,1).ToLower(); name=f+name.Substring (1); if(! identity.Contains(pro.Name.ToLower())) { if(proValue! =null) { colName+="["+name+"],"; val+="@"+name+","; if(proValue.GetType()==typeof(DateTime)) { System.Data.OleDb.OleDbParameteraaa=newOleDbParameter("@"+name,System.Data.OleDb.OleDbType.Date); aaa.Value=proValue; parameterList.Add(aaa); } else { parameterList.Add(newSystem.Data.OleDb.OleDbParameter("@"+name,proValue)); } } } } System.Data.OleDb.OleDbParameter[]sqlParameters=newSystem.Data.OleDb.OleDbParameter[parameterList.Count]; parameterList.CopyTo(sqlParameters); colName=colName.Substring(0,colName.Length-1); val=val.Substring(0,val.Length-1); stringsql="insertinto["+type.Name+"]("+colName+")values("+val+")"; stringabc=""; returnthis.RunSql(sql,sqlParameters,referror); } }
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- accessdbhelper 写法