employer-worker-registration-system

An accounting program that contains employee and employer information and records of relationships between them.

---

Screenshot

Login

Homepage	Employer registration	Worker registration

Search Box	Registration document

---

Requirements

Postgresql is used in this program. You can find the necessary jar file for postgresql java connection here:

https://jdbc.postgresql.org/download.html

Or you can use a different database but for this to work, change:

DriverManager.getConnection("jdbc:database://host:port/database-name", "user-name", "password");

for postgresql:

DriverManager.getConnection("jdbc:postgresql://localhost:5432/db", "postgres", "password");

---

And finally, in order not to get a database error, you should add the following tables to the database:

CREATE TABLE admin(id smallserial primary key not null, username varchar, password varchar);
CREATE TABLE employer(employer_id serial primary key not null, name varchar not null, surname varchar not null, business varchar, phonenumber varchar);
CREATE TABLE employer(employer_id serial primary key not null, name varchar not null, surname varchar not null, business varchar, phonenumber varchar);
CREATE TABLE worker(worker_id serial primary key not null, name varchar not null, surname varchar not null, phone_number varchar);
CREATE TABLE worker_record(worker_record_id serial primary key not null, worker_id integer references worker(worker_id), employer_id integer references employer(employer_id), date varchar(10) not null, wage smallint not null);
CREATE TABLE employer_record(employer_record_id serial primary key not null, employer_id integer references employer(employer_id), date varchar(10) not null, note varchar(255), number_worker smallint not null, wage smallint not null);
CREATE TABLE worker_payment(worker_payment_id serial primary key not null, worker_id integer references worker(worker_id), employer_id integer references employer(employer_id), date varchar(10), not null, paid integer not null);
CREATE TABLE employer_payment(employer_payment_id serial primary key not null, employer_id integer references employer(employer_id), date varchar(10) not null, paid integer not null);