Untitled
user_2664266
java
3 years ago
15 kB
6
Indexable
package school;
import java.awt.CardLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JPanel;
import javax.swing.JTextField;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
public class SchoolFrame extends JFrame implements ActionListener {
JMenuBar menubar;
JMenu add, show, delete;
JMenuItem addStud, addEmp, showStud, showEmp, deleteStud, deleteEmp;
JButton addStudbtn, addEmpbtn, showStudbtn, showEmpbtn, deleteStudbtn, deleteEmpbtn;
JPanel addStudPanel, addEmpPanel, showStudPanel, showEmpPanel, deleteStudPanel, deleteEmpPanel;
JLabel StudentNameLabel, StudentIdLabel, StudentAgeLabel, StudentSemesterLabel;
JLabel ShowStudentNameLabel, ShowStudentIdLabel, ShowStudentAgeLabel, ShowStudentSemesterLabel;
JLabel EmpNameLabel, EmpIdLabel, EmpAgeLabel, EmpSalaryLabel;
JLabel ShowEmpNameLabel, ShowEmpIdLabel, ShowEmpAgeLabel, ShowEmpSalaryLabel;
JLabel DeletStudentIdLabel, DeleteEmpIdLabel;
JTextField StudentNametf, studentIdtf, StudentAgetf, StudentSemestertf;
JTextField EmpNametf, EmpIdtf, EmpAgetf, EmpSalarytf;
JTextField ShowStudenttf, ShowEmptf, DeleteStudenttf, DeleteEmptf;
CardLayout CardLayout = new CardLayout(20, 20);
JPanel mainPanel = new JPanel(CardLayout);
Connection con = null;
String url = "jdbc:ucanaccess://SchoolDataBase.accdb";
public SchoolFrame() {
menubar = new JMenuBar();
add = new JMenu("ADD");
show = new JMenu("SHOW");
delete = new JMenu("DELETE");
addStud = new JMenuItem("Add Student");
addEmp = new JMenuItem("Add Employee");
showStud = new JMenuItem("Show Student");
showEmp = new JMenuItem("Show Employee");
deleteStud = new JMenuItem("Delete Student");
deleteEmp = new JMenuItem("Delete Employee");
add.add(addStud);
add.add(addEmp);
show.add(showStud);
show.add(showEmp);
delete.add(deleteStud);
delete.add(deleteEmp);
menubar.add(add);
menubar.add(delete);
menubar.add(show);
this.setJMenuBar(menubar);
addStud.addActionListener(this);
addStud.addActionListener(this);
addEmp.addActionListener(this);
showStud.addActionListener(this);
showEmp.addActionListener(this);
deleteStud.addActionListener(this);
deleteEmp.addActionListener(this);
addStudPanel = new JPanel(new GridLayout(5, 2));
StudentIdLabel = new JLabel("Enter Student id :");
StudentNameLabel = new JLabel("Enter Student name :");
StudentAgeLabel = new JLabel("Enter Student Age :");
StudentSemesterLabel = new JLabel("Enter Semester :");
StudentNametf = new JTextField();
studentIdtf = new JTextField();
StudentAgetf = new JTextField();
StudentSemestertf = new JTextField();
addStudbtn = new JButton("ADD Student");
addStudbtn.addActionListener(this);
addStudPanel.add(StudentIdLabel);
addStudPanel.add(studentIdtf);
addStudPanel.add(StudentNameLabel);
addStudPanel.add(StudentNametf);
addStudPanel.add(StudentAgeLabel);
addStudPanel.add(StudentAgetf);
addStudPanel.add(StudentSemesterLabel);
addStudPanel.add(StudentSemestertf);
addStudPanel.add(addStudbtn);
mainPanel.add(addStudPanel, "1");
addEmpPanel = new JPanel(new GridLayout(5, 2));
EmpIdLabel = new JLabel("Enter Employee ID :");
EmpNameLabel = new JLabel("Enter Employee Name :");
EmpAgeLabel = new JLabel("Enter Employee Age :");
EmpSalaryLabel = new JLabel("Enter Salary :");
EmpNametf = new JTextField();
EmpIdtf = new JTextField();
EmpAgetf = new JTextField();
EmpSalarytf = new JTextField();
addEmpbtn = new JButton("ADD Employee");
addEmpbtn.addActionListener(this);
addEmpPanel.add(EmpIdLabel);
addEmpPanel.add(EmpIdtf);
addEmpPanel.add(EmpNameLabel);
addEmpPanel.add(EmpNametf);
addEmpPanel.add(EmpAgeLabel);
addEmpPanel.add(EmpAgetf);
addEmpPanel.add(EmpSalaryLabel);
addEmpPanel.add(EmpSalarytf);
addEmpPanel.add(addEmpbtn);
mainPanel.add(addEmpPanel, "2");
deleteStudPanel = new JPanel(new GridLayout(4, 1));
DeletStudentIdLabel = new JLabel("Enter Student ID To Delete :");
DeleteStudenttf = new JTextField();
deleteStudbtn = new JButton("Delete Student");
deleteStudbtn.addActionListener(this);
deleteStudPanel.add(DeletStudentIdLabel);
deleteStudPanel.add(DeleteStudenttf);
deleteStudPanel.add(deleteStudbtn);
mainPanel.add(deleteStudPanel, "3");
deleteEmpPanel = new JPanel(new GridLayout(4, 1));
DeleteEmpIdLabel = new JLabel("Enter Employee ID To Delete :");
DeleteEmptf = new JTextField();
deleteEmpbtn = new JButton("Delete Employee");
deleteEmpbtn.addActionListener(this);
deleteEmpPanel.add(DeleteEmpIdLabel);
deleteEmpPanel.add(DeleteEmptf);
deleteEmpPanel.add(deleteEmpbtn);
mainPanel.add(deleteEmpPanel, "4");
showStudPanel = new JPanel(new GridLayout(6, 1));
ShowStudentIdLabel = new JLabel("Enter Student name To Show :");
ShowStudentAgeLabel = new JLabel("Student Age is : ");
ShowStudentNameLabel = new JLabel("Student name is : ");
ShowStudentSemesterLabel = new JLabel("Student Semester is : ");
ShowStudenttf = new JTextField();
showStudbtn = new JButton("show Student");
showStudbtn.addActionListener(this);
showStudPanel.add(ShowStudentIdLabel);
showStudPanel.add(ShowStudenttf);
showStudPanel.add(showStudbtn);
showStudPanel.add(ShowStudentNameLabel);
showStudPanel.add(ShowStudentAgeLabel);
showStudPanel.add(ShowStudentSemesterLabel);
mainPanel.add(showStudPanel, "5");
showEmpPanel = new JPanel(new GridLayout(6, 1));
ShowEmpIdLabel = new JLabel("Enter Employee ID TO Show:");
ShowEmpAgeLabel = new JLabel("Employee Age is : ");
ShowEmpNameLabel = new JLabel("Employee name is : ");
ShowEmpSalaryLabel = new JLabel("Employee Salary is : ");
ShowEmptf = new JTextField();
showEmpbtn = new JButton("show Emp");
showEmpbtn.addActionListener(this);
showEmpPanel.add(ShowEmpIdLabel);
showEmpPanel.add(ShowEmptf);
showEmpPanel.add(showEmpbtn);
showEmpPanel.add(ShowEmpNameLabel);
showEmpPanel.add(ShowEmpAgeLabel);
showEmpPanel.add(ShowEmpSalaryLabel);
mainPanel.add(showEmpPanel, "6");
this.add(mainPanel);
// CardLayout.show(mainPanel, "6");
this.setTitle("School Project");
this.setBounds(450, 250, 400, 400);
this.setDefaultCloseOperation(EXIT_ON_CLOSE);
this.setVisible(true);
}
public static void main(String[] args) {
new SchoolFrame();
try {
Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");}
catch (ClassNotFoundException ex) {
System.out.println("error " +ex.getMessage());
}
}
@Override
public void actionPerformed(ActionEvent e) {
if (e.getSource() == addStud) {
studentIdtf.setText("");
StudentNametf.setText("");
StudentAgetf.setText("");
StudentSemestertf.setText("");
CardLayout.show(mainPanel, "1");
return;
}
if (e.getSource() == addEmp) {
EmpIdtf.setText("");
EmpNametf.setText("");
EmpAgetf.setText("");
EmpSalarytf.setText("");
CardLayout.show(mainPanel, "2");
return;
}
if (e.getSource() == deleteStud) {
DeleteStudenttf.setText("");
CardLayout.show(mainPanel, "3");
return;
}
if (e.getSource() == deleteEmp) {
DeleteStudenttf.setText("");
CardLayout.show(mainPanel, "4");
return;
}
if (e.getSource() == showStud) {
ShowStudenttf.setText("");
ShowStudentAgeLabel.setText("Student Age is : ");
ShowStudentNameLabel.setText("Student name is : ");
ShowStudentSemesterLabel.setText("Student Semester is : ");
CardLayout.show(mainPanel, "5");
return;
}
if (e.getSource() == showEmp) {
ShowEmptf.setText("");
ShowEmpAgeLabel.setText("Employee Age is : ");
ShowEmpNameLabel.setText("Employee name is : ");
ShowEmpSalaryLabel.setText("Employee Salary is : ");
CardLayout.show(mainPanel, "6");
return;
}
if (e.getSource() == addStudbtn) {
try {
con = DriverManager.getConnection(url);
PreparedStatement st = con.prepareStatement("insert into Student_Info (Std_Id,Std_Name,Std_Age,Std_Semester) VALUES (?,?,?,?)");
st.setString(1, studentIdtf.getText());
st.setString(2, StudentNametf.getText());
st.setString(3, StudentAgetf.getText());
st.setString(4, StudentSemestertf.getText());
st.execute();
JOptionPane.showMessageDialog(null, "Added succesfully");
con.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "error : " + ex.getMessage());
}
}
if (e.getSource() == addEmpbtn) {
try {
con = DriverManager.getConnection(url);
PreparedStatement st = con.prepareStatement("insert into Emp_Info (Emp_Id,Emp_Name,Emp_Age,Emp_Salary) VALUES (?,?,?,?)");
st.setString(1, EmpIdtf.getText());
st.setString(2, EmpNametf.getText());
st.setString(3, EmpAgetf.getText());
st.setString(4, EmpSalarytf.getText());
st.execute();
JOptionPane.showMessageDialog(null, "Added succesfully");
con.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "error : " + ex.getMessage());
}
}
if (e.getSource() == deleteStudbtn) {
try {
con = DriverManager.getConnection(url);
PreparedStatement st = con.prepareStatement("delete from Student_Info where Std_id = ?");
st.setString(1, DeleteStudenttf.getText());
st.execute();
JOptionPane.showMessageDialog(null, "Deleted Succesfully");
con.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "error : " + ex.getMessage());
}
}
if (e.getSource() == deleteEmpbtn) {
try {
con = DriverManager.getConnection(url);
PreparedStatement st = con.prepareStatement("delete from Emp_Info where Emp_id = ?");
st.setString(1, DeleteEmptf.getText());
st.execute();
JOptionPane.showMessageDialog(null, "Deleted Succesfully");
con.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "error : " + ex.getMessage());
}
}
if (e.getSource() == showStudbtn) {
try {
con = DriverManager.getConnection(url);
PreparedStatement st = con.prepareStatement("select * from Student_Info where Std_id = ?");
st.setString(1, ShowStudenttf.getText());
ResultSet rs = st.executeQuery();
if (rs.next()) {
ShowStudentAgeLabel.setText("Student Age is : " + rs.getString("Std_Age"));
ShowStudentNameLabel.setText("Student name is : " + rs.getString("Std_Name"));
ShowStudentSemesterLabel.setText("Student Semester is : " + rs.getString("Std_Semester"));
} else {
JOptionPane.showMessageDialog(null, "student not found");
ShowStudentAgeLabel.setText("Student Age is : ");
ShowStudentNameLabel.setText("Student name is : ");
ShowStudentSemesterLabel.setText("Student Semester is : ");
}
con.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "error : " + ex.getMessage());
}
}
if (e.getSource() == showEmpbtn) {
try {
con = DriverManager.getConnection(url);
PreparedStatement st = con.prepareStatement("select * from Emp_Info where Emp_id = ?");
st.setString(1, ShowEmptf.getText());
ResultSet rs = st.executeQuery();
if (rs.next()) {
ShowEmpAgeLabel.setText("Employee Age is : " + rs.getString("Emp_Age"));
ShowEmpNameLabel.setText("Employee name is : " + rs.getString("Emp_Name"));
ShowEmpSalaryLabel.setText("Employee Salary is : " + rs.getString("Emp_Salary"));
} else {
JOptionPane.showMessageDialog(null, "Employee not found");
ShowEmpAgeLabel.setText("Employee Age is : ");
ShowEmpNameLabel.setText("Employee name is : ");
ShowEmpSalaryLabel.setText("Employee Salary is : ");
}
con.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "error : " + ex.getMessage());
}
}
}
}
Editor is loading...