你的位置:首页 > ASP.net教程

[ASP.net教程]vs2013 C# webapi Mysql新手,求各位大神指导


最近喜欢喜欢上了webapi模板。ajax请求数据,webap输出json,angular将数据绑定DOM,简单明了,简直是小前端的福音。实在忍不住,装上vs,连上数据库,成功输出数据。

visual studio2013 新建webapi

解决方案,右键管理NuGet程序包,MySql.Data  MySql.Data.Entity

然后配置文件(web.config)添加链接字符串。

<connectionStrings><!--<add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-MvcApplication1-20150910132908;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-MvcApplication1-20150910132908.mdf" />--><add name="MySQLConnString" connectionString="Server=localhost;Port=3306;Database=products;Uid=root;Pwd=" providerName="MySql.Data.MySqlClient" /></connectionStrings>

 


  

添加MySql辅助类,mysqlHelper

name和下文的System.Configuration.ConfigurationManager.AppSettings相同

/This connectionString for the local testpublic static readonly string connectionStringManager = System.Configuration.ConfigurationManager.AppSettings["MySQLConnString"];//ConfigurationManager.ConnectionStrings["MySQLConnString"].ConnectionString;//hashtable to store the parameter information, the hash table can store any type of argument//Here the hashtable is static types of static variables, since it is static, that is a definition of global use.//All parameters are using this hash table, how to ensure that others in the change does not affect their time to read it//Before ,the method can use the lock method to lock the table, does not allow others to modify.when it has readed then unlocked table.//Now .NET provides a HashTable's Synchronized methods to achieve the same function, no need to manually lock, completed directly by the system frameworkprivate static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());

 

已经可以使用mysql

var strConn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["MySQLConnString"].ConnectionString;MySqlCommand cmd = new MySqlCommand();using (MySqlConnection conn = new MySqlConnection(strConn)){conn.Open();}

感谢海洋教我。

执行select语句

var strConn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["MySQLConnString"].ConnectionString;MySqlCommand cmd = new MySqlCommand();using (MySqlConnection conn = new MySqlConnection(strConn)){conn.Open();MySqlCommand mycmd = new MySqlCommand("insert into product(name,price) values('小王','11')", conn);MySqlCommand objCmd = new MySqlCommand("select * from `product` ", conn);MySqlDataReader r = objCmd.ExecuteReader();int i = 0;while (r.Read()){try{products[i].Id = r.GetInt32(0);products[i].Name = r.GetString(2);products[i].Price = r.GetInt32(1);i++;}catch{}}conn.Close();}

发布

新建配置文件

ok

引用请注明http://www.cumt.top/blog/?p=107