Scribd
Upload
63 views6 pages

Ajp 15 20

This Java code defines a class called Deletedetails that allows a user to delete student registration details from a database. It contains GUI components like labels, text fields, and buttons to display and edit student information. Methods are included to connect to a database, retrieve student data, and delete a record when the Delete button is clicked. The class implements an action listener interface to handle button click events.

Uploaded by

Lala Bhau
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
63 views6 pages

Ajp 15 20

This Java code defines a class called Deletedetails that allows a user to delete student registration details from a database. It contains GUI components like labels, text fields, and buttons to display and edit student information. Methods are included to connect to a database, retrieve student data, and delete a record when the Delete button is clicked. The class implements an action listener interface to handle button click events.

Uploaded by

Lala Bhau
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Code:

import [Link]; [Link](txtSubcode);


import [Link]; [Link](lblSubName);
import [Link]; [Link](txtSubName);
import [Link]; [Link](lblCredit);
import [Link]; [Link](txtCredit);
import [Link]; [Link](lblMaxmark);
import [Link]; [Link](txtMaxmark);
import [Link]; [Link](lblType);
Import [Link]; [Link](cmbType);
import [Link]; [Link](lblPract);
import [Link]; [Link](cmbPract);
import [Link]; [Link](btnSave);
import [Link]; [Link](btnCancel);

public class AddSubjects extends JInternalFrame [Link](this);


implements ActionListener{ [Link](this);
private JLabel }//constructor closed
lblSubcode,lblSubName,lblCredit,lblMaxmark,lblType,lbl
P ract;
private JTextField public void actionPerformed(ActionEvent ae){
txtSubcode,txtSubName,txtCredit,txtMaxmark; if([Link]()==btnSave){
private JComboBox cmbType,cmbPract; try{
private JButton btnSave,btnCancel; [Link]("[Link]");
public AddSubjects(){ Connection
super("Add Subjects",false,true,false,true); con=[Link]("jdbc:odbc:student");
setSize(200,200); String sql="INSERT INTO Subject values(?,?,?,?,?,?)";
setLocation(400,200); PreparedStatement ps=[Link](sql);
setDefaultCloseOperation(DISPOSE_ON_CLOSE); [Link](1, [Link]());
Container c=[Link](); [Link](2, [Link]());
getContentPane().setLayout(new GridLayout(7,2)); [Link](3, [Link]([Link]()));
[Link](4, [Link]([Link]()));
lblSubcode=new JLabel(" Code"); [Link](5,[Link]().toString() );
lblSubName=new JLabel(" Name"); [Link](6, [Link]().toString());
lblCredit=new JLabel(" Credit"); int retval=[Link]();
lblMaxmark=new JLabel(" [Link]"); if(retval>0){
lblType=new JLabel(" Type"); [Link](null, "Record
lblPract=new JLabel("Practical"); successfully added to database");
txtSubcode=new JTextField(); [Link]("");
txtSubName=new JTextField(); [Link]("");
txtCredit=new JTextField(); [Link]("");
txtMaxmark=new JTextField(); [Link]("");
cmbType=new JComboBox(); [Link](0);
cmbPract=new JComboBox(); [Link](0);
[Link]("COUNTING"); }
[Link]("NON COUNTING"); }catch(Exception ex){
[Link](0); [Link](null,"Error connection
[Link]("YES"); not established or record already
[Link]("NO"); exists","Error",JOptionPane.ERROR_MESSAGE);
[Link](0); }
btnSave=new JButton("Save"); }else if([Link]()==btnCancel){
btnCancel=new JButton("Cancel"); [Link]();
}
[Link](lblSubcode); }
}//class closed
import [Link]; lblCity = new JLabel("City");
import [Link]; lblDistrict = new JLabel("District");
import [Link]; lblState = new JLabel("State");
import [Link]; lblPin = new JLabel("Pin");
import [Link]; lblYear = new JLabel("Year");
import [Link]; lblQualification = new JLabel("Qualification");
import [Link];
import [Link]; txtName = new JTextField();
import [Link]; txtAdNo = new JTextField();
import [Link]; txtPhNo = new JTextField();
import [Link]; txtSex = new JTextField();
import [Link]; txtFatherName = new JTextField();
import [Link]; txtOccupation = new JTextField();
import [Link]; txtMotherName = new JTextField();
import [Link]; txtDOB = new JTextField();
txtAge = new JTextField();
public class Deletedetails extends JInternalFrame txtCaste = new JTextField();
implements ActionListener { txtReligion = new JTextField();
txtHouseName = new JTextField();
private JPanel panel; txtCity = new JTextField();
private JButton btnDelete, btnCancel, btnView; txtDistrict = new JTextField();
private JLabel lblName, lblAdNo, lblPhNo, lblSex, txtState = new JTextField();
lblFatherName, lblOccupation; txtPin = new JTextField();
private JLabel lblMotherName, lblDOB, lblAge, txtQualification = new JTextField();
lblCaste, lblReligion, lblHouseName; txtYear = new JTextField();
private JLabel lblCity, lblDistrict, lblState, lblPin,
lblYear, lblQualification; [Link](false);
private JTextField txtName, txtAdNo, txtPhNo, [Link](false);
txtFatherName, txtOccupation; [Link](false);
private JTextField txtMotherName, txtDOB, txtAge, [Link](false);
txtCaste, txtReligion, txtHouseName; [Link](false);
private JTextField txtCity, txtDistrict, txtState, txtPin, [Link](false);
txtYear, txtQualification, txtSex; [Link](false);
private Connection con; [Link](false);
private Statement st; [Link](false);
[Link](false);
public Deletedetails() { [Link](false);
super("Edit Student Registration", true, true, true, true); [Link](false);
[Link](DISPOSE_ON_CLOSE); [Link](false);
[Link](1000, 1000); [Link](false);
[Link](false);
panel = new JPanel(); [Link](false);
lblAdNo = new JLabel("Admission no"); [Link](false);
lblName = new JLabel("Name"); btnDelete = new JButton("Delete", new
lblPhNo = new JLabel("Phone no"); ImageIcon([Link]("Images/delu
lblSex = new JLabel("Sex"); [Link]")));
lblFatherName = new JLabel("Father's name"); [Link](false);
lblOccupation = new JLabel("Occupation"); btnCancel = new JButton("Cancel", new
lblMotherName = new JLabel("Mother's name"); ImageIcon([Link]("Images/can
lblDOB = new JLabel("DOB"); [Link]")));
lblAge = new JLabel("Age"); btnView = new JButton("View", new
lblCaste = new JLabel("Caste"); ImageIcon([Link]("Images/vie
lblReligion = new JLabel("Religion"); [Link]")));
lblHouseName = new JLabel("House Name"); [Link](this);
[Link](this); [Link](lblFatherName);
[Link](this); [Link](txtFatherName);
[Link](lblOccupation);
[Link](null); [Link](txtOccupation);
[Link](lblMotherName);
[Link](100, 50, 150, 25); [Link](txtMotherName);
[Link](200, 50, 200, 25); [Link](lblDOB);
[Link](100, 90, 150, 25); [Link](txtDOB);
[Link](200, 90, 200, 25); [Link](lblAge);
[Link](100, 130, 150, 25);
[Link](200, 130, 200, 25); [Link](txtAge);
[Link](100, 170, 150, 25); [Link](lblCaste);
[Link](200, 170, 200, 25); [Link](txtCaste);
[Link](100, 210, 150, 25); [Link](lblReligion);
[Link](200, 210, 200, 25); [Link](txtReligion);
[Link](100, 250, 100, 25);
[Link](200, 250, 200, 25); [Link](lblHouseName);
[Link](100, 290, 100, 25); [Link](txtHouseName);
[Link](200, 290, 200, 25); [Link](lblCity);
[Link](100, 330, 150, 25); [Link](txtCity);
[Link](200, 330, 200, 25); [Link](lblDistrict);
[Link](100, 370, 150, 25); [Link](txtDistrict);
[Link](200, 370, 200, 25); [Link](lblState);
[Link](txtState);
[Link](500, 90, 150, 25); [Link](lblPin);
[Link](600, 90, 200, 25); [Link](txtPin);
[Link](500, 130, 100, 25); [Link](txtYear);
[Link](600, 130, 200, 25); [Link](lblYear);
[Link](500, 170, 100, 25); [Link](lblQualification);
[Link](600, 170, 200, 25); [Link](txtQualification);
[Link](500, 210, 150, 25); [Link](btnDelete);
[Link](600, 210, 200, 25); [Link](btnCancel);
[Link](500, 250, 100, 25); [Link](btnView);
[Link](600, 250, 200, 25); add(panel, [Link]);
[Link](500, 290, 50, 25);
[Link](600, 290, 200, 25); try {
[Link](500, 330, 150, 25); [Link]("[Link]");
[Link](600, 330, 200, 25); con =
[Link](500, 370, 100, 25); [Link]("jdbc:odbc:student");
[Link](600, 370, 200, 25); } catch (Exception ex) {
[Link](100, 420, 80, 25); [Link](null, "Error on
[Link](200, 420, 600, 25); connection to database, cannot continue updation process",
[Link](300, 470, 100, 25); "Error", JOptionPane.ERROR_MESSAGE);
[Link](450, 470, 100, 25); }//outer try catch closed
[Link](600, 470, 100, 25); }//constructor closed
public void actionPerformed(ActionEvent e) {
[Link](lblAdNo); if ([Link]().equalsIgnoreCase("Delete")) {
[Link](txtAdNo); try {
[Link](lblName); //[Link]("[Link]");
[Link](txtName); if ([Link]() == btnDelete) {
[Link](lblPhNo); String sql = "DELETE FROM student WHERE RollNo="
[Link](txtPhNo); + [Link]();
[Link](lblSex); [Link](sql);
[Link](txtSex); [Link](null, "Record
successfully deleted", "Success", [Link]("");
JOptionPane.INFORMATION_MESSAGE); [Link]("");
ClearForm(); [Link]("");
[Link](false); [Link]("");
}//if closed [Link]("");
} catch (Exception ex) { [Link]("");
[Link](null, "Error on database [Link]("");
operation", "Error", JOptionPane.ERROR_MESSAGE); [Link]("");
}//outer try catch closed [Link]("");
}//if closed [Link]("");
if ([Link]().equalsIgnoreCase("View")) { [Link]("");
try { [Link]("");
st = [Link](); [Link]("");
ResultSet rs = [Link]("SELECT * FROM student [Link]("");
WHERE RollNo=" + [Link]()); [Link]("");
if ([Link]()) { [Link]("");
[Link]([Link]("SName")); [Link]("");
[Link]([Link]("Sex")); [Link]("");
[Link]([Link]("FName")); }//clearform() closed
[Link]([Link]("MName")); }//class closed
[Link]([Link]("Age")); private JLabel lblUName = new JLabel("User name");
[Link]([Link]("Occupation")); private JComboBox cmbUName = new JComboBox();
[Link]([Link]("phno")); private JButton btnDelete = new JButton("Delete", new
[Link]([Link]("Religion")); ImageIcon([Link]("Images/delu
[Link]([Link]("Hname")); [Link]")));
[Link]([Link]("Caste"));
[Link]([Link]("City")); public Deleteuser() {
[Link]([Link]("State")); super("Delete user accounts", false, true, false, true);
[Link]([Link]("Dob").toString()); setBounds(350, 200, 300, 200);
[Link]([Link]("District")); setDefaultCloseOperation(DISPOSE_ON_CLOSE);
[Link]([Link]("Pin")); setLayout(null);
[Link]([Link]("Year")); [Link](30, 30, 100, 30);
[Link]([Link]("Qualification")); [Link](120, 30, 130, 25);
[Link](true); [Link](100, 90, 100, 25);
} else { add(lblUName);
[Link](null, "Roll No not add(cmbUName);
found in database", "Not found", add(btnDelete);
JOptionPane.INFORMATION_MESSAGE); [Link](this);
ClearForm(); LoadUserames();
[Link](false); }
}//if else closed
} catch (Exception x) { public void actionPerformed(ActionEvent e) {
[Link](null, "Error on database try {
operation,Updation failure", "Error", [Link]("[Link]");
JOptionPane.ERROR_MESSAGE); Connection con =
}//inner try catch closed [Link]("jdbc:odbc:student");
Statement st = [Link]();
}//if closed String Type;
if ([Link]().equalsIgnoreCase("Cancel")) { try {
[Link](); if ([Link]() == btnDelete) {
}//if closed String sql = "delete from UAD where Username='" +
} [Link]().toString() + "'";
[Link](sql);
private void ClearForm() { [Link](null, "Database
successfully updated", "Success", Container c = [Link]();
JOptionPane.INFORMATION_MESSAGE); getContentPane().setLayout(new GridLayout(5, 2));
LoadUserames();
} lblSubcode = new JLabel("Code");
} catch (Exception x) { lblSubName = new JLabel("Name");
[Link](null, "Error,Unable to lblCredit = new JLabel("Credit");
perform database operation", "Error", lblMaxmark = new JLabel("[Link]");
JOptionPane.ERROR_MESSAGE); cmbCode = new JComboBox();
}//inner try catch closed txtSubName = new JTextField();
} catch (Exception ex1) { txtCredit = new JTextField();
[Link](null, "Error on database txtMaxmark = new JTextField();
connection, Cannot perform database operation", "Error", btnDelete = new JButton("Delete");
JOptionPane.ERROR_MESSAGE); btnCancel = new JButton("Cancel");
}//outer try catch closed
}//actionPerformed() closed [Link](lblSubcode);
private void LoadUserames() { [Link](cmbCode);
String name; [Link](lblSubName);
try { [Link](txtSubName);
[Link]("[Link]"); [Link](lblCredit);
Connection con = [Link](txtCredit);
[Link]("jdbc:odbc:student"); [Link](lblMaxmark);
Statement st = [Link](); [Link](txtMaxmark);
ResultSet rs = [Link]("select Username from [Link](btnDelete);
UAD"); [Link](btnCancel);
[Link](); [Link](this);
while ([Link]()) { [Link](this);
name=[Link](1); [Link](this);
if (!([Link]("admin"))) { [Link](false);
[Link](name); [Link](false);
} [Link](false);
} loadSubjectCodes();
} catch (Exception ex) { }//constructor closed
[Link](null, "Error while
loading users list, Closing window" + [Link]()); public void actionPerformed(ActionEvent ae) {
[Link](); if ([Link]() == btnDelete) {
}//try catch clsoed try {
} if([Link]()==null)
}//class closed return;
[Link]("[Link]");
Connection con =
public class DelSubjects extends JInternalFrame [Link]("jdbc:odbc:student");
implements ActionListener { String sql = "DELETE FROM Subject WHERE
Subjectcode=?";
private JLabel lblSubcode, lblSubName, lblCredit, PreparedStatement ps = [Link](sql);
lblMaxmark; [Link](1, [Link]().toString());
private JTextField txtSubName, txtCredit, txtMaxmark; int retval = [Link]();
private JComboBox cmbCode; if (retval > 0) {
private JButton btnDelete, btnCancel; [Link](null, "Record
successfully deleted");
public DelSubjects() { [Link](this);
super("Add Subjects", false, true, false, true); loadSubjectCodes();
setSize(200, 150); [Link]("");
setLocation(400, 200); [Link]("");
setDefaultCloseOperation(DISPOSE_ON_CLOSE); [Link]("");
[Link](this);
[Link](0); void register()// for regitsering a new user { s = new
JFrame(); Container c = [Link]();
}
} catch (Exception ex) { [Link]([Link]); [Link](null);
[Link](null, [Link]()); [Link](true); [Link](500,500);
} [Link]("Register Here");
} [Link]([Link]); fname = new
if ([Link]() == btnCancel) { JLabel("First Name");
[Link](); [Link](20,50,100,20); [Link](fname);
} getfname = new JTextField();
if ([Link]() == cmbCode) {
[Link](110,50,150,20);
try {
[Link]("[Link]"); [Link](getfname); lname = new JLabel("Last Name");
Connection con = [Link](20,80,100,20); [Link](lname);
[Link]("jdbc:odbc:student"); getlname = new JTextField();
String sql = "SELECT Subjectname,CreditMark,MaxMark [Link](110,80,150,20);
FROM Subject WHERE Subjectcode=?"; [Link](getlname);
PreparedStatement ps = [Link](sql);
[Link](1, [Link]().toString());
ResultSet rs = [Link]();
if ([Link]()) {
[Link]([Link](1)); email = new JLabel("Email ID");
[Link]([Link]([Link](2)));
[Link](20,110,100,20); [Link](email);
[Link]([Link]([Link](3)));
} getemail = new JTextField();
[Link](110,110,150,20);
} catch (Exception ex) { [Link](getemail);
[Link](null,"Error on deletion
process","Error",JOptionPane.ERROR_MESSAGE); uname = new JLabel("Username");
}
}
[Link](20,140,100,20); [Link](uname);
} getuname = new JTextField();
[Link](110,140,150,20);
private void loadSubjectCodes() { [Link](getuname); passwd = new
try { JLabel("Password");
[Link](); [Link](20,170,100,20); [Link](passwd);
[Link]("[Link]"); getpasswd = new JPasswordField();
Connection con = [Link](110,170,150,20);
[Link]("jdbc:odbc:student"); [Link](getpasswd); registerme = new
String sql = "SELECT Subjectcode FROM Subject"; JButton("Register Me!!");
PreparedStatement ps = [Link](sql);
[Link](80,230,140,30);
ResultSet rs = [Link]();
while ([Link]()) {
[Link](registerme);
[Link]([Link](1)); [Link](this);
} [Link]([Link]);
} catch (Exception ex) { [Link]([Link]); } public
[Link](null, [Link]()); void ip() //it will find the IP address of localhost { try
} { InetAddress addr = [Link]();
} String ipAddress = [Link](); disp_ip =
} new JLabel("Your IP is =>

You might also like