Projects:
Project Descriptions:
1- JMysql
Abstract:
In recent years digitalization of manuscript are going to increase in our country, and most of informations and data are migrating to database systems which facilitate fast and easy accessing, transparency, safety and a lot more.
Jmysql is a mysql database with a Java front end application which will implement this system in IT center of Herat university, Afghanistan.
This center is providing IT facility for all university members after registration procedure. The application is going to store all necessary information about each members, it has registration, search, edit, remove and ID card print functionalities.
Introduction:
In Herat university there is an Information Technology Center with name of ITCH, every student of any faculty could register there and use its facilities, but before having an account, each student should be registered some how, so this center has a registration form what include all personal information, and the students who want enter to this center and have an account, then they should fill the registration form so they can have an account.
The students will fill on the papers and it wouldn’t be a safe, durable and transparent, in future we need to store these information digitally (Data base system).
For this, a person has the responsibility to take the filled form from students and enter information to data base system, this database need a GUI interface that is look like the form, means this interface should has all the details which are in the registration form. The form
has simple information like name, father name, University ID, ITCH ID, registered date, and all the necessary information plus some simple inoformation.
After registration procedure, this center (ITCH) gives an ID card for each registered student which include necessary information with her/his photo, our system has ability to take primary information from registration form and put them in ID card, then by pressing print card button card will be printed.
After the GUI form filled out then the responsible person press a button then these information will store in our data base. We will talk more about other functionalities of system in next section.
The GUI interface which will implemented by Java programming language has a connection with Mysql database server.
The name of project is JMysql (Java and Mysql).
List of Functionalities:
1- Add entry2- Search entry
3- Edit entry
4- Remove entry
5- Print card
1- Add entry:
In registration form, there are some primary/important fields (P/IF) that have to be implemented. All P/IF of a registration form must be implement before submit. If any P/IF miss to fill, after clicking on submit button you will get an error. After filling all fields of a registration form (Correctly) by clicking the submit button it saves all registration form's content into a database.
2- Search entry:
Search function gives this facility to find an entry by its primary information like: ID, Name, Father Name, Last Name, Mobile Number or E-mail address.
3- Edit entry:
First must search and select an entry form database then choose edit option. Edit function facilitate to edit any fields of an entry. After editing any field by choosing save option, the new information will overwrite on old one.
4- Remove entry:
Also at first must search and select an entry or some entries from database then choose remove option. Remove function it is possible to remove an entry.
5- Print card:
When registration form saved, resposible person can print a ITCH ID card. there is a prepared template in system which all nessecary information goes there.