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:15  zyip  阅读(155)  评论(0编辑  收藏  举报