The project aims at digitalizing the process of entry-exit at Ashoka using HID.
Languages: Core logic is in Java and jsp. Front end relies on HTML,CSS and JavaScript.
###Module dependencies jsp-api
mysql-connector-java-5.0.8-bin
servlet-api
Apache poi 3.9
org.json
DataBase.java:
Contains function to perform select, insert, update with transaction support. close() is necessary for making transaction to commit
Validator.java
Contains functions to check if the input is valid date and time. Also contain function to test if the date out is less than or equal to date in.
controller.jsp
Receives input from html forms. Used for giving permission to one time permission users. Checks as per date out if the permission to go out on a particular day exists, if exists then updates the time out, date in and time in, else inserts the permission in the table. Outputs String 'success' if insert operation was successful, 'updated' for the update operation and 'failed' for neither of the two, and other form processing.
Excel.java Responsible from reading form mysql database and write into excel file
c444661e8ab5af64686d6c1a170f5e3356220606