employer-worker-registration-system
An accounting program that contains employee and employer information and records of relationships between them.
v1 branch
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:
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 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);
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);