mssql 数据库连接方法封装

```rust use mssqlquick::{ msrun_vec, mscount, msdel, msfind, msget, msset, mssetmany, msupdate, msupdatemany, EncryptionLevel, MssqlQuick, MssqlQuickSet, };

const MSSQLURL: &str = "server=tcp:localhost,1433;user=SA;password=ji83laFidia32FAEE534DFa;database=devdb;IntegratedSecurity=true;TrustServerCertificate=true";

let mut client = MssqlQuick::new(MSSQL_URL, EncryptionLevel::NotSupported) .await .unwrap() .client; ```

mssql sql执行

| 运行sql | 说明 | | ---- | ---- | | msrunvec | 执行sql,返回vec类型数据,无数据则返回vec![] |

```rust let id: u64 = msrunvec(&mut client, sql).unwrap();

// 执行 sql 语句 let data: Vec = msrunvec(&mut conn, sql).unwrap(); ```

sql快捷生成

| sql快捷生成方法 | 说明 | | ---- | ---- | | mscount | 返回计数的sql | | msdel | 删除一条数据的sql | | msfind | 查寻数据的sql | | msget | 查寻一条数据的sql | | msset | 新增一条数据的sql | | mssetmany | 批量新增数据的sql | | msupdate | 更新一条数据的sql | | msupdatemany | 批量更新数据的sql | | 自定义 | 可以直接写自己的sql语句 |

以下内容,则为常用sql的快捷方法 ```rust

// 新增一条数据 msrunvec(&mut client, msset!("fortest", { "content": "ADFaadf", "uid": 9, "info": if let Some(a) = oneinfo {a} else {"null"}, })).await.unwrap();

// 删除一条数据 msrunvec(&mut client, msdel!("for_test", 50)).await.unwrap();

// 更新一条数据 msrunvec(&mut client, msupdate!("for_test", 56, { "content": "更新后的内容,一一一一" })).await.unwrap();

// 批量 新增数据 mssetmany!("fortest", vec![ Item {uid: 1, content: "批量更新00adf"}, Item {uid: 2, content: "2342341"}, Item {uid: 3, content: "mmmmm"}, ]) msrun_vec(&mut client, msql).await.unwrap();

// 批量 更新数据 let sql = msupdatemany!("fortest", "uid", vec![ Item {uid: 1, content: "批量更新00adf"}, Item {uid: 2, content: "2342341"}, ]) msrun_vec(&mut client, sql).await.unwrap();

// 获取一条数据 let sql1 = msget!("for_test", 33, "id, content as cc");

[derive(Serialize, Deserialize, Debug)]

struct Feedback { id: u64, cc: String } let resget: Vec = msrun_vec(&mut client, sql1).await.unwrap();

// 查寻数据 let sqlf = msfind!("fortest", { p0: ["uid", ">", 330], r: "p0", select: "*", }); let resfind: Vec = msrunvec(&mut client, sqlf).await.unwrap();

// 获取计数 let rescount: Vec = msrunvec(&mut client, mscount!("fortest", {})).await.unwrap();

// 自定义查寻 let list: Vec = msrunvec(&mut client, "select distinct typev3 from dishes".toowned()).await.unwrap();

```