CS506 GDB SOLUTION POSTED DATE:30-01-2020

MAKE SOME CHANGESYes, use of worker thread along with main thread will reduce the response delay, thread allow utilization of multiprocessor architectures to a great scale and efficiency. Threads are we very little resources of an operating system in which they are working. That is thread do not need new address space, global data, program code or operating system resources. Main thread is responsible for everything that happens on screen after application starting. Responsive of your application UI that you do not block the UI thread. If you have operation to perform that are not instantaneous, you should make sure to do them in separate worker threads.

POSTED DATE:01-02-2019

person class

public class Person {

String CNIC;
String Name;
String DOB;
String Address;

public Person() {
super();
CNIC = “”;
Name = “”;
DOB = “”;
Address = “”;
}
public Person(String cNIC, String name, String dOB, String address) {
super();
CNIC = cNIC;
Name = name;
DOB = dOB;
Address = address;
}

public String getCNIC() {
return CNIC;
}

public void setCNIC(String cNIC) {
CNIC = cNIC;
}

public String getName() {
return Name;
}

public void setName(String name) {
Name = name;
}

public String getDOB() {
return DOB;
}

public void setDOB(String dOB) {
DOB = dOB;
}

public String getAddress() {
return Address;
}

public void setAddress(String address) {
Address = address;
}

};
//////////////////////////////////////////////////////////

Studen class

//////////////////////////////////////////////////////////

public class Student extends Person {

String ID;
String Program;
String Email;

public Student() {
super();
ID = “”;
Program = “”;
Email = “”;
}

public Student(String cNIC, String name, String dOB, String address, String iD, String program, String email) {
super(cNIC, name, dOB, address);
ID = iD;
Program = program;
Email = email;
}

public String getID() {
return ID;
}

public void setID(String iD) {
ID = iD;
}

public String getProgram() {
return Program;
}

public void setProgram(String program) {
Program = program;
}

public String getEmail() {
return Email;
}

public void setEmail(String email) {
Email = email;
}
}

/////////////////////////////////////////////////////////////////////////////////////////

Driver Class

/////////////////////////////////////////////////////////////////////////////////////////

import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.*;

import java.sql.*;

public class Driver implements ActionListener {

JFrame frame;
private JLabel CNICLabel;
private JLabel idLabel;
private JLabel addressLabel;
private JLabel nameLabel;
private JLabel progLabel;
private JLabel DOBLabel;
private JLabel EmailLabel;
private JTextField CNICTxt;
private JTextField idTxt;
private JTextField addressTxt;
private JTextField nameTxt;
private JTextField progTxt;
private JTextField DOBTxt;
private JTextField EmailTxt;
private JPanel row1Panel;
private JPanel row2Panel;
private JPanel row3Panel;
private JPanel row4Panel;
private JPanel row5Panel;
private JPanel row6Panel;

private JButton saveRecord, retrieveRecord;
private Student student;

public void createFrame() {
frame = new JFrame(“BC160201501”);
Container c = frame.getContentPane();
c.setLayout(new GridLayout(6, 1, 10, 10));
CNICLabel = new JLabel(“Enter CNIC:”);
idLabel = new JLabel(“Enter ID:”);
nameLabel = new JLabel(“Enter Name:”);
DOBLabel = new JLabel(“Date of Birth:”);
progLabel = new JLabel(“Enter Program:”);
addressLabel = new JLabel(“Enter :Address”);
EmailLabel = new JLabel(“Enter Email:”);

CNICTxt = new JTextField(15);
idTxt = new JTextField(15);
nameTxt = new JTextField(15);
DOBTxt = new JTextField(15);
progTxt = new JTextField(15);
addressTxt = new JTextField(15);
EmailTxt = new JTextField(15);

row1Panel = new JPanel(new FlowLayout(FlowLayout.LEFT));
row1Panel.add(CNICLabel);
row1Panel.add(CNICTxt);
row1Panel.add(idLabel);
row1Panel.add(idTxt);
c.add(row1Panel);
row2Panel = new JPanel(new FlowLayout(FlowLayout.LEFT));
row2Panel.add(nameLabel);
row2Panel.add(nameTxt);
row2Panel.add(DOBLabel);
row2Panel.add(DOBTxt);
c.add(row2Panel);

row3Panel = new JPanel(new FlowLayout(FlowLayout.LEFT));
row3Panel.add(progLabel);
row3Panel.add(progTxt);
row3Panel.add(addressLabel);
row3Panel.add(addressTxt);
c.add(row3Panel);
row4Panel = new JPanel(new FlowLayout(FlowLayout.LEFT));
row4Panel.add(EmailLabel);
row4Panel.add(EmailTxt);
c.add(row4Panel);

saveRecord = new JButton(“Save Record”);
retrieveRecord = new JButton(“Retrieve Record”);

row5Panel = new JPanel(new FlowLayout(FlowLayout.LEFT));

row5Panel.add(saveRecord);
row5Panel.add(retrieveRecord);
c.add(row5Panel);

frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.setSize(600, 400);
frame.setVisible(true);

saveRecord.addActionListener(this);
retrieveRecord.addActionListener(this);

}

public void addData(Student student) {

try{

Class.forName(“net.ucanaccess.jdbc.UcanaccessDriver”);
Connection con = DriverManager.getConnection(“jdbc:ucanaccess://E:/azhar/BC160201501.accdb”);

String sql = “SELECT * FROM Student”;
PreparedStatement pst  = con.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = pst.executeQuery();
rs.moveToInsertRow();

rs.updateString(“CNIC”, student.getCNIC());
rs.updateString(“Name”, student.getName());
rs.updateString(“DOB”, student.getDOB());
rs.updateString(“Address”, student.getAddress());
rs.updateString(“id”, student.getID());
rs.updateString(“Program”, student.getProgram());
rs.updateString(“Email”, student.getEmail());

rs.insertRow();

}
catch (ClassNotFoundException e) {
System.out.println(“error” + e);
}

catch (SQLException ex) {
System.out.println(“error” + ex);
}
}
public void searchData(String id)
{

try {

Class.forName(“net.ucanaccess.jdbc.UcanaccessDriver”);
Connection con = DriverManager.getConnection(“jdbc:ucanaccess://E:/BC160201501/BC160201501.accdb”);
Statement st = con.createStatement();
String sql = “SELECT * FROM Student”;

ResultSet rs = st.executeQuery(sql);
int searchcount = 0;
while (rs.next()) {
String checkingCNIC = rs.getString(“CNIC”);
;
String checkingid = rs.getString(“id”);
if (id.equals(checkingCNIC) || id.equals(checkingid)) {
JOptionPane.showMessageDialog(null, “CNIC” + rs.getString(“CNIC”) + “/nid” + rs.getString(“id”) + “/nName” + rs.getString(“Name”)
+ “/nDOB” + rs.getString(“DOB”)  + “/nProgram” + rs.getString(“Program”)+”/nAddress” + rs.getString(“Address”)
+ “/nEmail” + rs.getString(“Email”));
searchcount++;
}
if (searchcount == 0) {
JOptionPane.showMessageDialog(null, “No Record Found”);
}

}

} catch (ClassNotFoundException e) {
System.out.println(“error” + e);
} catch (SQLException ex) {
System.out.println(“error” + ex);
}

}

@Override
public void actionPerformed(ActionEvent event) {
if (event.getSource() == saveRecord)
{
String CNIC = CNICTxt.getText();
String id = idTxt.getText();
String Name = nameTxt.getText();
String DOB = DOBTxt.getText();
String Program = progTxt.getText();
String Address = addressTxt.getText();

String Email = EmailTxt.getText();
Student s1 = new Student(CNIC, id, Name, DOB,Program, Address, Email );
addData(s1);

}
if (event.getSource() == retrieveRecord)
{
String input = JOptionPane.showInputDialog(“Enter Your CNIC or Id”);
searchData(input);
}

}

public Driver() {
createFrame();
}

public static void main(String[] args) {
Driver d1 = new Driver();
}

}