最近喜欢喜欢上了webapi模板。ajax请求数据,webap输出json,angular将数据绑定DOM,简单明了,简直是小前端的福音。实在忍不住,装上vs,连上数据库,成功输出数据。
visual studio2013 新建webapi
解决方案,右键管理NuGet程序包,MySql.Data MySql.Data.Entity
然后配置文件(web.config)添加链接字符串。
添加MySql辅助类,mysqlHelper
name和下文的System.Configuration.ConfigurationManager.AppSettings相同
/This connectionString forthe 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 framework
private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());
已经可以使用mysql
var strConn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["MySQLConnString"].ConnectionString;
MySqlCommand cmd= newMySqlCommand();using (MySqlConnection conn = newMySqlConnection(strConn))
{
conn.Open();
}
感谢海洋教我。
执行select语句
var strConn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["MySQLConnString"].ConnectionString;
MySqlCommand cmd= newMySqlCommand();using (MySqlConnection conn = newMySqlConnection(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
原文:http://www.cnblogs.com/cumt/p/4815455.html