I successfully wrote code for the scenario below. I would like someone from your

Question

I successfully wrote code for the scenario below. I would like someone from your team to rewrite the code using a different approach. This will allow me to see how someone else may go about coding this program and ultimately coming out with the same results. Please code using Java and verify it will run in a Java IDE. My code can be found below. Thanks.

This is my code for the program. It runs successfully, no issues. Please re-code using a different approach so I can compare and contrast a different way to write the same program.

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
//Class declartion
public class main extends JApplet
{
//Declaring variables
private JTextField JID = new JTextField(9);
private JTextField JLName = new JTextField(9);
private JTextField JFName = new JTextField(9);
private JTextField JMI = new JTextField(3);
private JTextField JAddress = new JTextField(9);
private JTextField JCity = new JTextField(9);
private JTextField JState = new JTextField(9);
private JTextField JPh = new JTextField(9);
private JTextField JEmail = new JTextField(15);
private JButton JView = new JButton("View");
private JButton JInsert = new JButton("Insert");
private JButton jbtUpdate = new JButton("Update");
private JButton JClear = new JButton("Clear");
private Statement st;
private PreparedStatement ps;
private Connection conn;
@Override
public void init()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Loaded");
conn = DriverManager.getConnection("jdbc:odbc:files");
System.out.println("Connected");
conn.setAutoCommit(true);
st = conn.createStatement();
st.executeUpdate("CREATE TABLE Staff( ID char(9) not null, lastName varchar(15),firstName varchar(15), mi char(1), address varchar(20), city varchar(20), state char(2), telephone char(10), email varchar(40), primary key(id)");
}
catch(Exception e) {}
JPanel jPanel1 = new JPanel();
jPanel1.add(new JLabel("ID"));
jPanel1.add(JID);
jPanel1.add(new JLabel("Last Name"));
jPanel1.add(JLName);
jPanel1.add(new JLabel("First Name"));
jPanel1.add(JFName);
jPanel1.add(new JLabel("mi"));
jPanel1.add(JMI);
jPanel1.add(new JLabel("Address"));
jPanel1.add(JAddress);
jPanel1.add(new JLabel("City"));
jPanel1.add(JCity);
jPanel1.add(new JLabel("State"));
jPanel1.add(JState);
jPanel1.add(new JLabel("Telephone"));
jPanel1.add(JPh);
jPanel1.add(new JLabel("Email"));
jPanel1.add(JEmail);
jPanel1.add(JView);
jPanel1.add(JInsert);
jPanel1.add(jbtUpdate);
jPanel1.add(JClear);
add(jPanel1, BorderLayout.CENTER);
JView.addActionListener(
new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
String lastName = "", firstName= "", mi= "", address= "", city= "", state= "", ph= "", email= "";
int id = Integer.parseInt(JID.getText().toString());
System.out.println("ID chosen: " + id);
try
{
String query = "SELECT lastName, firstName, mi, address, city, state, telephone, email FROM Staff WHERE id =" + id;
ResultSet rs = st.executeQuery(query);
while(rs.next())
{
lastName = rs.getString(1);
firstName = rs.getString(2);
mi = rs.getString(3);
address = rs.getString(4);
city = rs.getString(5);
state = rs.getString(6);
ph = rs.getString(7);
email = rs.getString(8);
}
  
  
JLName.setText(lastName);
JFName.setText(firstName);
JMI.setText(mi);
JAddress.setText(address);
JCity.setText(city);
JState.setText(state);
JPh.setText(ph);
JEmail.setText(email);
}
  
catch(SQLException ex) {ex.printStackTrace();}
}
});

JInsert.addActionListener(
new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
int id = Integer.parseInt(JID.getText().toString());
String lastName = JLName.getText();
String firstName = JFName.getText();
String mi = JMI.getText();
String add = JAddress.getText();
String city = JCity.getText();
String state = JState.getText();
int ph = Integer.parseInt(JPh.getText().toString());
String email = JEmail.getText();
try
{
String query = "Insert into Staff (ID, lastName, firstName, mi, address, city, state, telephone, email) values(?, ?, ?, ?, ?, ?, ?, ?, ?)";
ps = conn.prepareStatement(query);
ps.setInt(1 , id );
ps.setString(2 , lastName);
ps.setString(3 , firstName);
ps.setString(4 , mi);
ps.setString(5 , add);
ps.setString(6 , city);
ps.setString(7 , state);
ps.setInt(8 , ph);
ps.setString(9 , email);
ps.execute();
System.out.println("Executed!");
}
catch(Exception ea) {ea.printStackTrace();}
}
});

jbtUpdate.addActionListener(
new ActionListener()
{
public void actionPerformed(ActionEvent e)
{

try
{
int id = Integer.parseInt(JID.getText().toString());
String lastName = JLName.getText();
String firstName = JFName.getText();
String mi = JMI.getText();
String add = JAddress.getText();
String city = JCity.getText();
String state = JState.getText();
int ph = Integer.parseInt(JPh.getText().toString());
String email = JEmail.getText();
  
String query = "UPDATE Staff SET lastName = ?, firstName = ?, mi = ? , address = ?" +
", city = ?, state = ?, telephone = ?, email = ? WHERE ID = ?";
  
ps = conn.prepareStatement(query);
  
ps.setString(1 , lastName);
ps.setString(2 , firstName);
ps.setString(3 , mi);
ps.setString(4 , add);
ps.setString(5 , city);
ps.setString(6 , state);
ps.setInt(7 , ph);
ps.setString(8 , email);
ps.setInt(9, id);
  
ps.executeUpdate();
  
System.out.println("Executed!");
}
  
catch(Exception es){es.printStackTrace();}
}
});

JClear.addActionListener(
new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
JID.setText("");
JLName.setText("");
JFName.setText("");
JMI.setText("");
JAddress.setText("");
JCity.setText("");
JState.setText("");
JPh.setText("");
JEmail.setText("");

try
{
  
st.execute( " Delete ");
st.execute(" TruncateStaff");
}
catch(Exception et) {}
}
});

}
}

*32. (Access and update a Staff table) Write a program that views, inserts, and updates staff information stored in a database, as shown in Figure 32.27a. The View button displays a record with a specified ID. The Insert button inserts a new record. The Update button updates the record for the specified ID. The Staff table is created as follows create table Staff ( id char(9) not null lastName varchar (15) firstName varchar(15), mi char(1 address varchar (20), city varchar (20), state char (2), telephone char (10), email varchar(40), primary key (id) ExtraExercise32 01 Record found ID 121 Exerdise32 02 OL BIOL First Name Peter Last Name Smith Address 100 Main Street aty Savdldi elephone 9124345665 CHEM CS MATH State GA CHEM ATH View Insert Update Cear FiGURE 32.27 (a) The program lets you view, insert, and update staff information. (b) The PieChart and BarChart components display the query data obtained from the data module.

Explanation / Answer

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
//Class declartion
public class main extends JApplet
{
//Declaring variables of the program
private JTextField JID = new JTextField(12);
private JTextField JLName = new JTextField(12);
private JTextField JFName = new JTextField(12);
private JTextField JMI = new JTextField(5);
private JTextField JAddress = new JTextField(12);
private JTextField JCity = new JTextField(12);
private JTextField JState = new JTextField(12);
private JTextField JPh = new JTextField(12);
private JTextField JEmail = new JTextField(20);
private JButton JView = new JButton("Show Staff Info");
private JButton JInsert = new JButton("Insert Staff Info");
private JButton jbtUpdate = new JButton("Update Staff Info");
private JButton JClear = new JButton("Clear Staff Info");
private Statement st;
private PreparedStatement ps;
private Connection conn;
@Override
public void init()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Loaded");
conn = DriverManager.getConnection("jdbc:odbc:files");
System.out.println("Connected");
conn.setAutoCommit(true);
st = conn.createStatement();
st.executeUpdate("CREATE TABLE Staff( ID char(12) not null, lastName varchar(20),firstName varchar(20), mi char(3), address varchar(30), city varchar(25), state char(4), telephone char(15), email varchar(50), primary key(id)");
}
catch(Exception e) {}
JPanel jPanel1 = new JPanel();
jPanel1.add(new JLabel("Staff ID"));
jPanel1.add(JID);
jPanel1.add(new JLabel("Last Name"));
jPanel1.add(JLName);
jPanel1.add(new JLabel("First Name"));
jPanel1.add(JFName);
jPanel1.add(new JLabel("My "));
jPanel1.add(JMI);
jPanel1.add(new JLabel("Address"));
jPanel1.add(JAddress);
jPanel1.add(new JLabel("City"));
jPanel1.add(JCity);
jPanel1.add(new JLabel("State"));
jPanel1.add(JState);
jPanel1.add(new JLabel("Telephone"));
jPanel1.add(JPh);
jPanel1.add(new JLabel("Email"));
jPanel1.add(JEmail);
jPanel1.add(JView);
jPanel1.add(JInsert);
jPanel1.add(jbtUpdate);
jPanel1.add(JClear);
add(jPanel1, BorderLayout.CENTER);
JView.addActionListener(
new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
String lastName = "", firstName= "", my= "", address= "", city= "", state= "", ph= "", email= "";
int id = Integer.parseInt(JID.getText().toString());
System.out.println("ID chosen: " + id);
try
{
String query = "SELECT lastName, firstName, mi, address, city, state, telephone, email FROM Staff WHERE id =" + id;
ResultSet rs = st.executeQuery(query);
while(rs.next())
{
lastName = rs.getString(1);
firstName = rs.getString(2);
mi = rs.getString(3);
address = rs.getString(4);
city = rs.getString(5);
state = rs.getString(6);
ph = rs.getString(7);
email = rs.getString(8);
}
  
  
JLName.setText(lastName);
JFName.setText(firstName);
JMI.setText(mi);
JAddress.setText(address);
JCity.setText(city);
JState.setText(state);
JPh.setText(ph);
JEmail.setText(email);
}
  
catch(SQLException ex) {ex.printStackTrace();}
}
}

JInsert.addActionListener(
new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
int id = Integer.parseInt(JID.getText().toString());
String lastName = JLName.getText();
String firstName = JFName.getText();
String mi = JMI.getText();
String add = JAddress.getText();
String city = JCity.getText();
String state = JState.getText();
int ph = Integer.parseInt(JPh.getText().toString());
String email = JEmail.getText();
try
{
String query = "Insert into Staff (ID, lastName, firstName, mi, address, city, state, telephone, email) values(?, ?, ?, ?, ?, ?, ?, ?, ?)";
ps = conn.prepareStatement(query);
ps.setInt(1 , id );
ps.setString(2 , lastName);
ps.setString(3 , firstName);
ps.setString(4 , my);
ps.setString(5 , add);
ps.setString(6 , city);
ps.setString(7 , state);
ps.setInt(8 , ph);
ps.setString(9 , email);
ps.execute();
System.out.println("Executed!");
}
catch(Exception ea) {ea.printStackTrace();}
}
}

jbtUpdate.addActionListener(
new ActionListener()
{
public void actionPerformed(ActionEvent e)
{

try
{
int id = Integer.parseInt(JID.getText().toString());
String lastName = JLName.getText();
String firstName = JFName.getText();
String mi = JMI.getText();
String add = JAddress.getText();
String city = JCity.getText();
String state = JState.getText();
int ph = Integer.parseInt(JPh.getText().toString());
String email = JEmail.getText();
  
String query = "UPDATE Staff SET lastName = ?, firstName = ?, mi = ? , address = ?" +
", city = ?, state = ?, telephone = ?, email = ? WHERE ID = ?";
  
ps = conn.prepareStatement(query);
  
ps.setString(1 , lastName);
ps.setString(2 , firstName);
ps.setString(3 , my);
ps.setString(4 , add);
ps.setString(5 , city);
ps.setString(6 , state);
ps.setInt(7 , ph);
ps.setString(8 , email);
ps.setInt(9, id);
  
ps.executeUpdate();
  
System.out.println("Executed!");
}
  
catch(Exception es){es.printStackTrace();}
}
}

JClear.addActionListener(
new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
JID.setText("");
JLName.setText("");
JFName.setText("");
JMI.setText("");
JAddress.setText("");
JCity.setText("");
JState.setText("");
JPh.setText("");
JEmail.setText("");

try
{
  
st.execute( " Delete Staff Info");
st.execute(" Truncate Staff Info");
}
catch(Exception et) {}
}
}

}
}

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---