StringBuilder 拼接sql 使用 ArrayList传入参数
StringBuilder sb = New StringBuffer();
ArrayList arry = New ArryList();
String str ="";
("insert into table(termNo,teacherName) values ( '{0} ', '{1} ' )") ;
();
(());
strsql = ((), ());
public int UpdateABook(Books book)
{
StringBuilder sql = new StringBuilder();
("update Books set [Title]=@title");
(",[Author]=@author,[PublisherId]=@publisherId");
(",[PublishDate]=@publishDate,[ISBN]=@iSBN,[WordsCount]=@wordsCount");
(",[UnitPrice]=@unitPrice,[ContentDescription]=@ContentDes,[AurhorDescription]=@autorDes");
(",[EditorComment]=@editComm,[TOC]=@tOC,[CategoryId]=@cateId,[Clicks]=@clicks ");
(" where Id=@bookId");
SqlParameter[] param = new SqlParameter[]{
new SqlParameter("@bookId",book .Id),
new SqlParameter("@title",book .Title ),
new SqlParameter("@author",),
new SqlParameter("@publisherId",),
new SqlParameter("@publishDate",book .PublishDate),
new SqlParameter("@iSBN",),
new SqlParameter("@wordsCount",),
new SqlParameter("@unitPrice",),
new SqlParameter("@ContentDes",),
new SqlParameter("@autorDes",),
new SqlParameter("@editComm",),
new SqlParameter("@tOC",),
new SqlParameter("@cateId",),
new SqlParameter("@clicks",)
};