webservice mysql配置_将REST WebService连接到MySQL数据库

我想创建一个连接到MySQL数据库的REST WebService。但我被困在了一个点上,真的不知道如何走得更远。

这是我的代码:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using SimpleRESTServer.Models;

using MySql.Data;

namespace SimpleRESTServer

{

public class PersonPersistance

{

private MySql.Data.MySqlClient.MySqlConnection conn;

public PersonPersistance()

{

string myConnectionString;

myConnectionString = "server=127.0.0.1;uid=Local Instance MySQL80; pwd=;database=employeedb";

try

{

conn = new MySql.Data.MySqlClient.MySqlConnection();

conn.ConnectionString = myConnectionString;

conn.Open();

}

catch (MySql.Data.MySqlClient.MySqlException ex)

{

}

}

public long savePerson(Person personToSave)

{

String sqlString = " INSERT INTO tblpersonnel (FirstName, LastName) VALUES ('"+ personToSave.FirstName + "','" + personToSave.LastName + "')";}

MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn);

cmd.ExecuteNonQuery();

long id = cmd.LastInsertedId;

return id;

}

}

我听了这个家伙的教程:

https://youtu.be/LpySuvYPMZQ

我希望有人能帮助我。

提前谢谢你的帮助!