nodejs 执行sql

import sql from 'mssql'


async function query(sqlTxt:string){
  let  config = "Server=localhost,1433;Database=db1;User Id=sa;Password=sa;Trusted_Connection=True;TrustServerCertificate=True;'"
  let conn = await sql.connect(config)
  const result = await conn.query(sqlTxt)
  return result
}

 

posted @ 2022-12-20 11:14  zyip  阅读(167)  评论(0)    收藏  举报