How to use my code:

1. My code in Java SE, with following modules used:
2. JDBC for Postgresql connection
3. LDAP Class Libraries for Java (JLDAP)
4. This repo has 2 directories:

• src: contains all the source code
• libs: contains all external libraries used

3. Setting up in IDE:

• You can use any IDE for Java SE, import the source from the 'src' directory.
• Import all dependencies by adding all JARs from 'libs' directory.

4. Changes to be made:

• src/db/DbConfig.java: Change variables 'driverName', 'url', 'username' and 'password' according to your database specifications.
• src/utils/Config.java: Change variable 'LDAP_DUMP_FILE' as per your requirements.

5. You are ready now, you can build and run the project.

Uses:

1. Once the database is loaded we can run simple sql queries for the following:

• Find student information from their 'Roll No' or 'Name'
• Find all students in a particular department
• Find all faculty in a particular department
• Find all students from a particular batch (check the starting 2 digits of Roll No)
• Find all students based on under-graguate(UG) or dual-degree(DD) or post-graguate(PG) course.
• Combination of the above queries.

Disclaimer 1 : The following code will only run when connected to the IIT Bombay intranet (requires access to server ldap.iitb.ac.in)

Disclaimer 2 : Branch Change is not accounted for, in the data present on the ldap server. (Some students' data maybe incorrect)