StringBuilder 拼接sql 使用 ArrayList传入参数
StringBuilder sb = New StringBuffer();
ArrayList arry = New ArryList();
String str ="";
sb.Append("insert into table(termNo,teacherName) values ( '{0} ', '{1} ' )") ;
arry.Add(dpterm.SelectedItem.Text.ToString);
arry.Add(txtName.Text.Trim());
strsql = String.Format(sb.ToString(), arry.ToArray());
public int UpdateABook(Books book)
{
StringBuilder sql = new StringBuilder();
sql.Append("update Books set [Title]=@title");
sql.Append(",[Author]=@author,[PublisherId]=@publisherId");
sql.Append(",[PublishDate]=@publishDate,[ISBN]=@iSBN,[WordsCount]=@wordsCount");
sql.Append(",[UnitPrice]=@unitPrice,[ContentDescription]=@ContentDes,[AurhorDescription]=@autorDes");
sql.Append(",[EditorComment]=@editComm,[TOC]=@tOC,[CategoryId]=@cateId,[Clicks]=@clicks ");
sql.Append (" where Id=@bookId");
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@bookId",book .Id),
new SqlParameter("@title",book .Title ),
new SqlParameter("@author",book.Author),
new SqlParameter("@publisherId",book.Publisher.Id),
new SqlParameter("@publishDate",book .PublishDate),
new SqlParameter("@iSBN",book.ISBN),
new SqlParameter("@wordsCount",book.WordCount),
new SqlParameter("@unitPrice",book.UnitPrice),
new SqlParameter("@ContentDes",book.ContentDescription),
new SqlParameter("@autorDes",book.AurhorDescription),
new SqlParameter("@editComm",book.EditorComment),
new SqlParameter("@tOC",book.TOC),
new SqlParameter("@cateId",book.Category.Id),
new SqlParameter("@clicks",book.Clicks)
};
利用StringBuilder拼接字符串
最新推荐文章于 2024-04-18 09:44:36 发布