Initial commit for School Database Connectivity
So, guys I have connected this project with the School Database, I haven't touched the code done by you instead I have created two new classes i.e. dbConnections and helper placed in the Helper folder. There are some pre-requisites for it which are as follows:
-Install FortiClient and get remote access using your username and password.
-Install SQL Server as this code is listening to TCP/IP Port 1433 (or search for it if you don't want to install the SQL Server)
-First, try to run the project as it is but if don't succeed then try:
- I also added "mssql-jdbc-12.8.1.jre8.jar" to my project for the SQL connectivity this could be done as follows:
- Download "Microsoft JDBC Driver for SQL Server" from "https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16"
- Extract the folder on your local machine
- Right-click on your project in Eclipse.
- Select Build Path → Configure Build Path.
- Confirm that the SQL JDBC driver is added to your Classpath.