ASP.NET Core 6.0 的最小 web API

vokxchh

已于 2022-03-30 19:19:18 修改

阅读量1.1k

点赞数

文章标签： c#

于 2022-03-30 19:16:06 首次发布

本文链接：https://blog.csdn.net/vokxchh/article/details/123854226

版权

using MySql.Data.MySqlClient;
using System.Data;

using System.Text;
var MyAllowSpecificOrigins = "_myAllowSpecificOrigins";
var builder = WebApplication.CreateBuilder(args);
builder.Services.AddCors(options =>
{
    options.AddPolicy(name: MyAllowSpecificOrigins,
                      builder =>
                      {
                          builder.SetIsOriginAllowed(_=>true).AllowAnyHeader().AllowAnyMethod().AllowCredentials();
                      });
});

var app = builder.Build();

app.UseCors(MyAllowSpecificOrigins);
app.UseStaticFiles();
//string sn = "502584157";
app.MapGet("/api", (string sn) =>
{
  
    if (sn.Length < 7) {  return "need length > 7"; }
    string sql = "";
    string constr = "server=localhost;UserId=root;password=;Database=";
    MySqlConnection mCon = new MySqlConnection(constr);
    mCon.Open();
    MySqlDataAdapter mycmd = new MySqlDataAdapter(sql, mCon);
    mycmd.SelectCommand.ExecuteNonQuery();

    DataTable MyDT = new DataTable();

    mycmd.Fill(MyDT);

    mCon.Close();
 
    StringBuilder sb = new StringBuilder();
    sb.Clear(); 
    for (int i = 0; i < MyDT.Rows.Count; i++)
    {
        sb.Append(MyDT.Rows[i]["data"].ToString() + "/r/n");
    }
     
    return sb.ToString();
});
//app.MapGet("/", () => "Hello World!");

app.Run();