Databases Programming Challenges 3, Personnel Database Creator Write an applicat
ID: 3548854 • Letter: D
Question
Databases
Programming Challenges
3, 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, named 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.
4, Employee Inserter
Write a GUI application that allows the user to add new employee to the Personnel database you created in Programming Challenges 3.
pls add comments
Explanation / Answer
Personnel Database Creator:-
create database Personnel:
use Personnel;
create table Employee(employeeID number(10)primary key,position varchar2(20),payrate double(2,3));
insert into employee values(1,'software',90$);
insert into employee values(2,'Pl',150$);
insert into employee values(3,'Advisor',70$);
insert into employee values(4,'BDM',100$);
insert into employee values(5,'Trainee',50$);
Employee Inserter : --
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
public class RetailGUI extends JFrame
{
// The following variables will reference the
// custom panel objects.
private DepartmentPanel department;
private ItemPanel item;
private PricePanel price;
private TitlePanel title; // To display a greeting
// The following variables will reference objects
// needed to add Next and Exit buttons.
private JPanel buttonPanel; // To hold the buttons
private JButton nextButton,
printButton,
exitButton; // To exit the application
/**
* Constructor
*/
public RetailGUI()
{
// Display a title.
super("Retail Calculator");
setSize(600, 250);
// Specify an action for the close button.
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setLocationRelativeTo(null);
// Create a BorderLayout manager for
// the content pane.
setLayout(new BorderLayout());
// Create the custom panels.
title = new TitlePanel();
department = new DepartmentPanel();
item = new ItemPanel();
price = new PricePanel();
// Call the buildButtonPanel method to
// create the button panel.
buildButtonPanel();
// Add the components to the content pane.
add(title, BorderLayout.NORTH);
add(department, BorderLayout.WEST);
add(item, BorderLayout.CENTER);
add(price, BorderLayout.EAST);
add(buttonPanel, BorderLayout.SOUTH);
// Pack the contents of the window and display it.
//pack();
setVisible(true);
}
/**
* The buildButtonPanel method builds the button panel.
*/
private void buildButtonPanel()
{
// Create a panel for the buttons.
buttonPanel = new JPanel();
// Create the buttons.
nextButton = new JButton("Next");
printButton = new JButton("Print");
exitButton = new JButton("Exit");
// Register the action listeners.
nextButton.addActionListener(new RetailGUI.NextButtonListener());
printButton.addActionListener(new RetailGUI.PrintButtonListener());
exitButton.addActionListener(new RetailGUI.ExitButtonListener());
// Add the buttons to the button panel.
buttonPanel.add(nextButton);
buttonPanel.add(printButton);
buttonPanel.add(exitButton);
}
/**
* Private inner class that handles the event when
* the user clicks the Next button.
*/
private class NextButtonListener implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
String departmentName,
finalItem;
float priceField,
discountField,
newPrice;
ArrayList DepartmentList = new ArrayList();
ArrayList ItemList = new ArrayList();
ArrayList PriceList = new ArrayList();
ArrayList DiscountList = new ArrayList();
ArrayList NewPriceList = new ArrayList();
departmentName = department.getDepartmentName();
finalItem = item.getItemName();
priceField = price.getPriceField();
discountField = price.getDiscountField();
newPrice = priceField - (priceField * (discountField/100));
DepartmentList.add(departmentName);
System.out.print(DepartmentList);
JOptionPane.showMessageDialog(null,"Department: " + departmentName + " " +
"Item Name: " + finalItem + " " +
"Orginal Price: $" + priceField + " " +
"Discount: " + discountField + "%" + " " +
"New Price: $" + newPrice + " ");
}
}
private class PrintButtonListener implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
}
}
private class ExitButtonListener implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
// Exit the application.
System.exit(0);
}
}
}
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.