اتصال به دیتابیس MSSQL در برنامه‌های NextJS

npm install mssql

DB_USER=sa
DB_PASS=6fdZJSt5LCXcVIZa0mgMLOS6
DB_HOST=bromo.liara.cloud
DB_PORT=33951
DB_NAME=testDB

import sql from 'mssql';

const mssqlConfig = {
  user: process.env.DB_USER,
  password: process.env.DB_PASS,
  server: process.env.DB_HOST,
  port: parseInt(process.env.DB_PORT, 10),
  database: process.env.DB_NAME,
  options: {
    trustServerCertificate: true, 
  },
};

export async function connectToMSSQL() {
  const pool = await sql.connect(mssqlConfig);
  return pool;
}

import { connectToMSSQL } from '@/lib/mssql';

export default async function handler(req, res) {
  const pool = await connectToMSSQL();
  pool.close();

  res.status(200).json({ message: 'Connected to MSSQL successfully' });
}

import { useEffect, useState } from 'react';

export default function Home() {
  const [data, setData] = useState(null);
  const [error, setError] = useState(null);

  useEffect(() => {
    async function fetchData() {
      try {
        const res = await fetch('/api/mssql');
        const result = await res.json();
        setData(result);
      } catch (err) {
        setError(err);
      }
    }

    fetchData();
  }, []);

  return (
    <div>
      <h1>Database Connection Test</h1>
      {error ? (
        <p>Error: {error.message}</p>
      ) : data ? (
        <pre>{JSON.stringify(data, null, 2)}</pre>
      ) : (
        <p>Loading...</p>
      )}
    </div>
  );
}