webservice 连接mysql_WebService实现数据库操作

1.数据库连接：

[WebMethod]public string InsertPoint(stringdata)

{//解决跨域问题//Context.Response.AddHeader("Access-Control-Allow-Origin", "*");

string database = "Data Source=.;Initial Catalog=test;Persist Security Info=True;User ID=sa;Password=password1633";//string data = HttpContext.Current.Request["data"];

try{if (data.Equals("") || data == null)

{return "data is null";

}else{

OverlaysPoint opoint= JsonConvert.DeserializeObject(data);// 将接收的参数data实例化为一个对象(方便操作)，注意该类的变量名要和json的key值对应/*foreach (Data_Opoint dtpoint in opoint.overlays)

{

sql = "insert into Map_Overlays(wf_pictureid,wf_picturename,wf_railid,wf_name,wf_location,wf_createtime,wf_pid,wf_lng,wf_lat) values(‘" + "123456789" + "‘,‘" + opoint.picturename + "‘,‘