employer-worker-registration-system's Introduction

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);

Recommend Projects