usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingMySql.Data;usingMySql.Data.MySqlClient;//在MySQL中使用参数化SQL的例子///代码编写:周公///日期:2008-3-19///发表网址:///publicclassMySqlUtil{publicMySqlUtil(){}publicboolInsertAdmin(stringuserName,stringpassword,stringremark,stringmail,intdepartId,intpower){stringsql = "insert into S_Admin(UserName,Password,Remark,Mail,DepartId,Power)values(?UserName,?Password,?Remark,?Mail,?DepartId,?Power)";MySqlConnection connection =newMySqlConnection();connection.ConnectionString = "";//此处设置链接字符串MySqlCommand command =newMySqlCommand(sql, connection);command.Parameters.Add("?UserName", MySqlDbType.VarChar, 60).Value = userName;command.Parameters.Add("?Password", MySqlDbType.VarChar, 60).Value = password;command.Parameters.Add("?Remark", MySqlDbType.VarChar, 60).Value = remark;command.Parameters.Add("?Mail", MySqlDbType.VarChar, 60).Value = mail;command.Parameters.Add("?DepartId", MySqlDbType.Int32, 4).Value = departId;command.Parameters.Add("?Power", MySqlDbType.Int32, 4).Value = power;connection.Open();introwsAffected = command.ExecuteNonQuery();connection.Close();command.Dispose();returnrowsAffected > 0;}}
ado的mysql参数化_在ADO.NET中使用参数化SQL语句的大同小异
最新推荐文章于 2021-03-03 16:04:24 发布