sql 添加数据返回添加Id
string insertSql = "Insert into b_treatise(userId,treatiseTitle,publicationName,publishDate,author,attachment,FundingNum,ImpactFactor,ReferenceNum) values "
+ "('" + userId + "','" + treatiseTitle + "','" + publicationName + "','" + publishDate.ToString() + "','" + author + "','" + attachment + "','" + FundingNum + "','" + ImpactFactor + "','" + ReferenceNum + "');select last_insert_id() as id";
+ "('" + userId + "','" + treatiseTitle + "','" + publicationName + "','" + publishDate.ToString() + "','" + author + "','" + attachment + "','" + FundingNum + "','" + ImpactFactor + "','" + ReferenceNum + "');select last_insert_id() as id";
select last_insert_id() as id