ConnectionDB.java

 package database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ConnectionDB
{
 
 public static Connection getConnection()
 {
  Connection conn = null;
  String url="jdbc:sqlserver://localhost:1433;databaseName=Medicine";
  try
  {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   conn = DriverManager.getConnection(url,"sa","sa");
  }
  catch (ClassNotFoundException e)
  {
   e.printStackTrace();
  }
  catch
  (SQLException e)
  {
   e.printStackTrace();
  }
  return conn;
 }

}