Can you solve in simple way GROUP ASSIGNMENT DESCRIPTION The students need to fo
ID: 665842 • Letter: C
Question
Can you solve in simple way GROUP ASSIGNMENT DESCRIPTION The students need to form groups, each consisting of maximum 4 members. Each group has to develop a Java application applying the concepts studied in the CS202 (Introduction to Computer Science) course. The application may be developed for student report, employee record, shopping details, book collection, seminar reservation, air-ticket reservation, stock inventory or any other. The application must have methods to read, calculate and print the required information. Follow the details given below: Use GUI concept (Swing) to develop your application Include the OOPs concepts: Inheritance, Polymorphism, Abstract class and Interface suitable to your application Include at least TWO (2) new events or TWO (2) new controls Handle at least TWO (2) Exceptions (predefined/user defined) in your applicationExplanation / Answer
This is a java swing program for Student Reports, choosing courses, First Time Registration, change of university, student exchange and results publication management System:
First the Login program:
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;
class Login extends JFrame implements ActionListener // inherit from ActionListener class
{
ResultSet rs; // record set staorage from database table
JButton b1,b2; // b1 is the submit button
JLabel l1,l2; // l1 stores user name label l2 the password
JTextField t1,t2; // t1 = user name, t2 = password
Login()
{
super("Login");
setLayout(null);
l1=new JLabel("User Name");
add(l1);
l1.setBounds(20,45,100,30); // set the size of the label
t1=new JTextField();
add(t1);
t1.setBounds(110,50,150,20); // size of the text box control
setLayout(null);
l2=new JLabel("Password"); // receive password from user
add(l2);
l2.setBounds(20,95,100,30);
t2=new JPasswordField();
add(t2);
t2.setBounds(110,100,150,20);
b1=new JButton("Submit"); // execute - validate user credentials entered
add(b1);
b1.setBounds(90,160,90,30);
b1.addActionListener(this);
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
}
public void actionPerformed(ActionEvent ae)
{
String s1="",s2="";
Integer flag=0;
String user=t1.getText();
String pwd=t2.getText();
conn c=new conn();
if(ae.getSource()==b1)
{
try{
rs=c.st.executeQuery("select * from Login"); // get from database
rs.first();
do
{
s1=rs.getString(2);
s2=rs.getString(3);
if(user.equals(s1) && pwd.equals(s2))
// if user name and password are correct then
{
Student s=new Student();
s.setBounds(300,300,500,500);
s.setVisible(true);
}
}while(rs.next());
// loop while the are records in the record set
c.con.close(); // close the db connection
}catch(Exception e){}
}
else
{
System.out.println("Enter data Proparly");
JOptionPane.showMessageDialog(this,"Plse Fillup All Field",
"Error",JOptionPane.ERROR_MESSAGE);
}
}
}
class log
{
public static void main(String ar[])
{
Login l1=new Login(); // call the login function
l1.setBounds(300,300,300,250);
l1.setVisible(true);
}
}
// *********************************************************************************
// this program is to enroll a student and to test him/her:
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
class Student extends JFrame implements ActionListener
{
MenuItem newmenuitem,updatemenuitem,reportmenuitem,exitmenuitem;
TextArea t1;
Student()
{
super("Student");
MenuBar mbr=new MenuBar(); // declare a menu bar to hold options
Menu Filemenu=new Menu("Student"); // make a student menu of items
Filemenu.add(newmenuitem=new MenuItem("New")); // add a new menu item
Filemenu.add(updatemenuitem=new MenuItem("Update"));
// Filemenu.add(reportmenuitem=new MenuItem("Report"));
Filemenu.add(exitmenuitem=new MenuItem("Exit"));
mbr.add(Filemenu);
setMenuBar(mbr); // assign the menubar to mbr
newmenuitem.addActionListener(this);
updatemenuitem.addActionListener(this);
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
}
public void actionPerformed(ActionEvent ce)
{
if(ce.getActionCommand()=="New")
{
Newpage n=new Newpage();
n.setSize(1200,900); // set the size to 1200 and 900
n.setVisible(true); // make it visible
}
if(ce.getActionCommand()=="Update")
{
updatestud u=new updatestud(); // call the update student function
u.setSize(1200,900);
u.setVisible(true);
}
}
}
class Teststudent
{
public static void main(String ar[])
{
Student s1=new Student(); // enroll a new student in to the University
s1.setBounds(0,0,400,400);
s1.setVisible(true);
}
}
// ************************************************************************************************************
This program will update student details:
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.io.*;
import java.text.*;
import java.util.regex.*;
class updatestud extends JFrame implements ActionListener// FocusListener
{
JLabel l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12,l13,l14,l15,l16,l17,head;
JTextField t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16;
JButton b1,b2,b3,b4;
JComboBox cmb; // declare a combo box
conn c; // for database connection to acces the tables
int id;
int rid,rno;
String dob,gen,rdate,add,city,state,zip,homeph,cell,email,dept,year;
// all the details of students like Date Of Birth, Gender, Registration Date, Address,
// City, State, ZIP Code, Home Phone, Cell Phone, Email address, Department and Year
PreparedStatement ps; // progress report statement
boolean found = false;
static ResultSet res;
ResultSet rs; // record set
JPanel p;
String msg="";
updatestud()
{
super("Sudent EntryForm"); // form to collect student data
setLayout(null);
head=new JLabel("Modify Data ");
head.setBounds(270,30,600,50);
head.setFont(new Font("Courier",Font.BOLD,30));
add(head);
l1=new JLabel("Index Number");
l1.setBounds(150,110,100,30);
add(l1);
t1=new JTextField();
t1.setHorizontalAlignment (JTextField.RIGHT);
t1.setBounds(280,114,170,25);
add(t1);
l2=new JLabel("Registraction Id");
l2.setBounds(150,170,100,30);
add(l2);
t2=new JTextField();
t2.setHorizontalAlignment (JTextField.RIGHT);
t2.setBounds(280,174,170,25);
add(t2);
l3=new JLabel("Name ");
l3.setBounds(150,230,100,30);
add(l3);
t3=new JTextField(); // get the student name
t3.setHorizontalAlignment (JTextField.RIGHT);
t3.setBounds(280,234,170,25);
add(t3);
l4=new JLabel("Age"); // collect students Age
l4.setBounds(150,294,100,30);
add(l4);
t4=new JTextField();
t4.setHorizontalAlignment (JTextField.RIGHT);
t4.setBounds(280,294,170,25);
add(t4);
l5=new JLabel("Birth Date"); // get his/her date of birth = dob
l5.setBounds(150,354,100,30);
add(l5);
t5=new JTextField();
t5.setHorizontalAlignment (JTextField.RIGHT);
t5.setBounds(280,354,170,25);
add(t5);
l6=new JLabel("Gender"); // male or female?
l6.setBounds(150,414,100,30);
add(l6);
cmb=new JComboBox();
cmb.addItem("Male");
cmb.addItem("Female");
cmb.setBounds(280,414,170,30);
add(cmb);
l7=new JLabel("Registration Date");
l7.setBounds(150,474,100,30);
add(l7);
t7=new JTextField();
t7.setHorizontalAlignment (JTextField.RIGHT);
t7.setBounds(280,474,170,25);
add(t7);
l8=new JLabel("Address"); // door number, street name
l8.setBounds(150,534,100,30);
add(l8);
t8=new JTextField();
t8.setHorizontalAlignment (JTextField.RIGHT);
t8.setBounds(280,534,170,25);
add(t8);
l9=new JLabel("City");
l9.setBounds(650,110,100,30);
add(l9);
t9=new JTextField();
t9.setHorizontalAlignment (JTextField.RIGHT);
t9.setBounds(780,110,170,25);
add(t9);
l10=new JLabel("State"); // NY for New York, DC for Washington, OH for Ohio etc
l10.setBounds(650,170,100,30);
add(l10);
t10=new JTextField();
t10.setHorizontalAlignment (JTextField.RIGHT);
t10.setBounds(780,170,170,25);
add(t10);
l11=new JLabel("Zip");
l11.setBounds(650,230,100,30);
add(l11);
t11=new JTextField();
t11.setHorizontalAlignment (JTextField.RIGHT);
t11.setBounds(780,230,170,25);
add(t11);
l12=new JLabel("Home Phone"); // land line phone number
l12.setBounds(650,290,100,30);
add(l12);
t12=new JTextField();
t12.setHorizontalAlignment (JTextField.RIGHT);
t12.setBounds(780,290,170,25);
add(t12);
l13=new JLabel("Cell"); // the 10 digit mobile phone number
l13.setBounds(650,350,100,30);
add(l13);
t13=new JTextField();
t13.setHorizontalAlignment (JTextField.RIGHT);
t13.setBounds(780,350,170,25);
add(t13);
l14=new JLabel("EMail");
l14.setBounds(650,410,100,30);
add(l14);
t14=new JTextField();
t14.setHorizontalAlignment (JTextField.RIGHT);
t14.setBounds(780,410,170,25);
add(t14);
l15=new JLabel("Department"); // Maths, Physics, Chemistry, Computer Science, Biology etc
l15.setBounds(650,470,100,30);
add(l15);
t15=new JTextField();
t15.setHorizontalAlignment (JTextField.RIGHT);
t15.setBounds(780,470,170,25);
add(t15);
l16=new JLabel("Year");
l16.setBounds(650,530,100,30);
add(l16);
t16=new JTextField();
t16.setHorizontalAlignment (JTextField.RIGHT);
t16.setBounds(780,530,170,25);
add(t16);
b1=new JButton("Search");
b1.setBounds(280,630,100,30);
add(b1);
b2=new JButton("Update");
b2.setBounds(440,630,100,30);
add(b2);
b3=new JButton("Delete");
b3.setBounds(600,630,100,30);
add(b3);
b4=new JButton("Exit");
b4.setBounds(760,630,100,30);
add(b4);
b4.addActionListener(this);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
t2.addActionListener(this);
disable();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
}
//public void focusGained (FocusEvent ae) { }
//public void focusLost (FocusEvent ae)
public void actionPerformed(ActionEvent ae)
{
c=new conn();
if(ae.getSource()==b1)
{
if (!t2.getText().equals (""))
{
enable();
id = Integer.parseInt(t2.getText ());
// String q = "SELECT * FROM stud WHERE RId != " + id;
// rs=c.st.executeQuery(q);
try { //SELECT Query to Retrieved the Record.
// set the SQL statement
String q = "SELECT * FROM stud WHERE RId = " + id;
rs=c.st.executeQuery(q);
System.out.println(rs);
//ResultSet rs = c.st.executeQuery (q);
while(rs.next ())
{
found = true;
// get all the details of the student using record set's getinteger
rid = rs.getInt("RId");
rno=rs.getInt("Id");
String nm=rs.getString("Name");
int ag=rs.getInt("Age");
dob=rs.getString("DateOfbirth");
gen=rs.getString("Gender");
rdate=rs.getString("RDate");
add=rs.getString("Add");
city=rs.getString("City");
state=rs.getString("State");
zip=rs.getString("Zip");
homeph=rs.getString("HomePhone");
cell=rs.getString("Cell");
email=rs.getString("Email");
dept=rs.getString("Dept");
year=rs.getString("Year1");
t1.setText(Integer.toString(rno));
t2.setText (Integer.toString(id));
t3.setText (nm);
t4.setText (Integer.toString(ag));
t5.setText(dob);
cmb.setSelectedItem((Object)gen);
t7.setText(rdate);
t8.setText(add);
t9.setText(city);
t10.setText(state);
t11.setText(zip);
t12.setText(homeph);
t13.setText(cell);
t14.setText(email);
t15.setText(dept);
t16.setText(year);
JOptionPane.showMessageDialog(this,"Records is found","Message",JOptionPane.INFORMATION_MESSAGE);
}
found = false;
}
catch (SQLException sqlex) { // handle the sql exception
System.out.print(sqlex.toString());
}
}
else
{
JOptionPane.showMessageDialog(this,"Please enter registration no.","Message",JOptionPane.ERROR_MESSAGE);
}
}
if(ae.getSource()==b2)
{
String cmbitem=(String)cmb.getSelectedItem();
try{
conn c1=new conn();
ps=c1.con.prepareStatement("delete from stud where RId=?");
// delete a student record from the db table
ps.setInt(1,Integer.parseInt(t2.getText()));
ps.executeUpdate();
c1.con.commit();
// insert data in to stud table in the database
ps=c1.con.prepareStatement("insert into stud values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
ps.setInt(1,Integer.parseInt(t1.getText()));
ps.setInt(2,Integer.parseInt(t2.getText()));
ps.setString(3,t3.getText());
ps.setString(4,t4.getText());
ps.setString(6,cmbitem);
ps.setString(5,t5.getText());
ps.setString(7,t7.getText());
ps.setString(8,t8.getText());
ps.setString(9,t9.getText());
ps.setString(10,t10.getText());
ps.setString(11,t11.getText());
ps.setString(12,t12.getText());
ps.setString(13,t13.getText());
ps.setString(14,t14.getText());
ps.setString(15,t15.getText());
ps.setString(16,t16.getText());
ps.executeUpdate();
c1.con.commit();
}
catch(Exception e){}
}
if(ae.getSource()==b3)
{
try{
conn c1=new conn();
ps=c1.con.prepareStatement("delete from stud where RId=?");
ps.setInt(1,Integer.parseInt(t2.getText()));
ps.executeUpdate();
c1.con.commit();
t1.setText("");
t2.setText("");
t3.setText("");
t4.setText("");
t5.setText("");
t7.setText("");
t8.setText("");
t9.setText("");
t10.setText("");
t11.setText("");
t12.setText("");
t13.setText("");
t14.setText("");
t15.setText("");
t16.setText("");
}catch(Exception e){}
}
else
{
JOptionPane.showMessageDialog(this,"Please enter registration no.","Message",JOptionPane.ERROR_MESSAGE);
}
if(ae.getSource()==b4)
{
setVisible (false);
dispose();
}
}
public void disable()
{
t1.setEnabled(false);
t3.setEnabled(false);
t4.setEnabled(false);
t5.setEnabled(false);
cmb.setEnabled(false);
t7.setEnabled(false);
t8.setEnabled(false);
t9.setEnabled(false);
t10.setEnabled(false);
t11.setEnabled(false);
t12.setEnabled(false);
t13.setEnabled(false);
t14.setEnabled(false);
t15.setEnabled(false);
t16.setEnabled(false);
}
public void enable()
{
t1.setEnabled(true);
t3.setEnabled(true);
t4.setEnabled(true);
t5.setEnabled(true);
cmb.setEnabled(true);
t7.setEnabled(true);
t8.setEnabled(true);
t9.setEnabled(true);
t10.setEnabled(true);
t11.setEnabled(true);
t12.setEnabled(true);
t13.setEnabled(true);
t14.setEnabled(true);
t15.setEnabled(true);
t16.setEnabled(true);
}
}
class update
{
public static void main(String ar[])
{
updatestud u=new updatestud();
u.setBounds(0,0,1048,900);
u.setResizable(false);
u.setVisible(true);
}
}
// **************************************************************************************
This program is to create a new page for student details handling:
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.io.*;
import java.text.*;
import java.util.regex.*;
class Newpage extends JFrame implements ActionListener
{
JLabel l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12,l13,l14,l15,l16,l17,head;
JTextField t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16;
JButton b1,b2,b3;
JComboBox cmb;
PreparedStatement ps;
JPanel p;
String msg="";
Newpage()
{
super("Sudent EntryForm");
setLayout(null);
head=new JLabel("Student Entry Form");
head.setBounds(270,30,600,50);
head.setFont(new Font("Courier",Font.BOLD,30));
add(head);
l1=new JLabel("Index Number");
l1.setBounds(150,110,100,30);
add(l1);
t1=new JTextField();
t1.setHorizontalAlignment (JTextField.RIGHT);
t1.setBounds(280,114,170,25);
add(t1);
l2=new JLabel("Registraction Id");
l2.setBounds(150,170,100,30);
add(l2);
t2=new JTextField();
t2.setHorizontalAlignment (JTextField.RIGHT);
t2.setBounds(280,174,170,25);
add(t2);
l3=new JLabel("Name ");
l3.setBounds(150,230,100,30);
add(l3);
t3=new JTextField();
t3.setHorizontalAlignment (JTextField.RIGHT);
t3.setBounds(280,234,170,25);
add(t3);
l4=new JLabel("Age");
l4.setBounds(150,294,100,30);
add(l4);
t4=new JTextField();
t4.setHorizontalAlignment (JTextField.RIGHT);
t4.setBounds(280,294,170,25);
add(t4);
l5=new JLabel("Birth Date");
l5.setBounds(150,354,100,30);
add(l5);
t5=new JTextField();
t5.setHorizontalAlignment (JTextField.RIGHT);
t5.setBounds(280,354,170,25);
add(t5);
l6=new JLabel("Gender");
l6.setBounds(150,414,100,30);
add(l6);
cmb=new JComboBox();
cmb.addItem("Male");
cmb.addItem("Female");
cmb.setBounds(280,414,170,30);
add(cmb);
l7=new JLabel("Registration Date");
l7.setBounds(150,474,100,30);
add(l7);
t7=new JTextField();
t7.setHorizontalAlignment (JTextField.RIGHT);
t7.setBounds(280,474,170,25);
add(t7);
l8=new JLabel("Address");
l8.setBounds(150,534,100,30);
add(l8);
t8=new JTextField();
t8.setHorizontalAlignment (JTextField.RIGHT);
t8.setBounds(280,534,170,25);
add(t8);
l9=new JLabel("City");
l9.setBounds(650,110,100,30);
add(l9);
t9=new JTextField();
t9.setHorizontalAlignment (JTextField.RIGHT);
t9.setBounds(780,110,170,25);
add(t9);
l10=new JLabel("State");
l10.setBounds(650,170,100,30);
add(l10);
t10=new JTextField();
t10.setHorizontalAlignment (JTextField.RIGHT);
t10.setBounds(780,170,170,25);
add(t10);
l11=new JLabel("Zip");
l11.setBounds(650,230,100,30);
add(l11);
t11=new JTextField();
t11.setHorizontalAlignment (JTextField.RIGHT);
t11.setBounds(780,230,170,25);
add(t11);
l12=new JLabel("Home Phone");
l12.setBounds(650,290,100,30);
add(l12);
t12=new JTextField();
t12.setHorizontalAlignment (JTextField.RIGHT);
t12.setBounds(780,290,170,25);
add(t12);
l13=new JLabel("Cell");
l13.setBounds(650,350,100,30);
add(l13);
t13=new JTextField();
t13.setHorizontalAlignment (JTextField.RIGHT);
t13.setBounds(780,350,170,25);
add(t13);
l14=new JLabel("EMail");
l14.setBounds(650,410,100,30);
add(l14);
t14=new JTextField();
t14.setHorizontalAlignment (JTextField.RIGHT);
t14.setBounds(780,410,170,25);
add(t14);
l15=new JLabel("Department");
l15.setBounds(650,470,100,30);
add(l15);
t15=new JTextField();
t15.setHorizontalAlignment (JTextField.RIGHT);
t15.setBounds(780,470,170,25);
add(t15);
l16=new JLabel("Year");
l16.setBounds(650,530,100,30);
add(l16);
t16=new JTextField();
t16.setHorizontalAlignment (JTextField.RIGHT);
t16.setBounds(780,530,170,25);
add(t16);
b1=new JButton("Submit");
b1.setBounds(280,630,100,30);
add(b1);
b2=new JButton("Clear");
b2.setBounds(440,630,100,30);
add(b2);
b3=new JButton("Exit");
b3.setBounds(600,630,100,30);
add(b3);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
t1.addKeyListener (new KeyAdapter () {
public void keyTyped (KeyEvent ke) {
char c = ke.getKeyChar ();
if (! ((Character.isDigit (c)) || (c == KeyEvent.VK_BACK_SPACE))) {
getToolkit().beep ();
ke.consume ();
}
}
}
);
t2.addKeyListener (new KeyAdapter () {
public void keyTyped (KeyEvent ke) {
char c = ke.getKeyChar ();
if (! ((Character.isDigit (c)) || (c == KeyEvent.VK_BACK_SPACE))) {
getToolkit().beep ();
ke.consume ();
}
}
}
);
t11.addKeyListener (new KeyAdapter () {
public void keyTyped (KeyEvent ke) {
char c = ke.getKeyChar ();
if (! ((Character.isDigit (c)) || (c == KeyEvent.VK_BACK_SPACE))) {
getToolkit().beep ();
ke.consume ();
}
}
}
);
t12.addKeyListener (new KeyAdapter () {
public void keyTyped (KeyEvent ke) {
char c = ke.getKeyChar ();
if (! ((Character.isDigit (c)) || (c == KeyEvent.VK_BACK_SPACE))) {
getToolkit().beep ();
ke.consume ();
}
}
}
);
t13.addKeyListener (new KeyAdapter () {
public void keyTyped (KeyEvent ke) {
char c = ke.getKeyChar ();
if (! ((Character.isDigit (c)) || (c == KeyEvent.VK_BACK_SPACE))) {
getToolkit().beep ();
ke.consume ();
}
}
}
);
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
}
public void actionPerformed(ActionEvent ae)
{
String cmbitem=(String)cmb.getSelectedItem();
if(ae.getSource()==b1)
{
if(!t1.getText().equals("")&!t2.getText().equals("")&!t3.getText().equals("")&!t4.getText().equals("")&!t5.getText().equals("")&!t7.getText().equals("")&!t8.getText().equals("")&!t9.getText().equals("")&!t10.getText().equals("")&!t11.getText().equals("")&!t12.getText().equals("")&!t13.getText().equals("")&!t14.getText().equals("")&!t15.getText().equals("")&!t16.getText().equals("")) // if the JTextField is not empty then enable the button
{
//b1.setEnabled(true);
try
{
conn c=new conn();
ps=c.con.prepareStatement("insert into stud values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
ps.setInt(1,Integer.parseInt(t1.getText()));
ps.setInt(2,Integer.parseInt(t2.getText()));
ps.setString(3,t3.getText());
ps.setString(4,t4.getText());
ps.setString(6,cmbitem);
ps.setString(5,t5.getText());
ps.setString(7,t7.getText());
ps.setString(8,t8.getText());
ps.setString(9,t9.getText());
ps.setString(10,t10.getText());
ps.setString(11,t11.getText());
ps.setString(12,t12.getText());
ps.setString(13,t13.getText());
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.