I need help with these JAVA programs 6. Personnel Database Creator Write an appl
ID: 3683189 • Letter: I
Question
I need help with these JAVA programs
6. Personnel Database Creator
Write an application that creates a database named Personnel. The database should have a table named Employee with columns for employee ID, name, position, and hourly pay rate. The employee ID should be the primary key. Insert at least five sample rows of data into the Employee table.
7. Employee Inserter
Write a GUI application that allows the user to add new employees to the Personnel database you created in Programming Challenge 6
8. Employee Updater
Write a GUI application tat allows the user to look up an employee in the personnel database you entered in programming Challenge 6. The user should be able to change any of the employee's information except employee ID, which is the primary key.
Explanation / Answer
6.
7.
package com.tutorialspoint.eclipselink.entity;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
public class Employee
{
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int eid;
public Employee(int eid, String ename)
{
super( );
this.eid = eid;
this.ename = ename;
}
public Employee( )
{
super();
}
public int getEid( )
{
return eid;
}
public void setEid(int eid)
{
this.eid = eid;
}
public String getEname( )
{
return ename;
}
public void setEname(String ename)
{
this.ename = ename;
}
8.