An accounting program that contains employee and employer information and records of relationships between them.
Login
| Homepage | Employer registration | Worker registration |
|---|---|---|
 |
 |
 |
| Search Box | Registration document |
|---|---|
 |
 |
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");
to run java -cp "src;libs/postgresql-42.7.3.jar" com.cbozan.main.Main
**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);