Employee Management

program for employee management created by java language and MySQL database.

• Selete data
• Update data
• Insert data
• Delete data

---

ER diagram

---

relation model

---

structure table

use employeeManagement;

create table Employee(

EID varchar(25) not null,
firstName varchar(25),
lastName varchar(25),
jobTitle varchar(15),
city varchar(25),
BOD date,
phone varchar(10) unique,
email varchar(25) unique,
primary key(EID)

);

---

The program interface

---

Notes:

• you need add mysql-connector-java to project
• you must have:
  • port
  • database name
  • user name
  • password