Scribd
Upload
19 views

A Dvace Oop Lab Report Solved 5 4th Cs

The document details a Java program that implements a student management system with functionality to insert and delete student records from a database table. The program creates a GUI with labels, text fields and buttons to accept student details and connects to a MySQL database to perform CRUD operations on a student information table.

Uploaded by

Hamza Ramay
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
19 views

A Dvace Oop Lab Report Solved 5 4th Cs

The document details a Java program that implements a student management system with functionality to insert and delete student records from a database table. The program creates a GUI with labels, text fields and buttons to accept student details and connects to a MySQL database to perform CRUD operations on a student information table.

Uploaded by

Hamza Ramay
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
You are on page 1/ 4

Lab 5 Hamza Nazir

Advanced Object-Oriented Programming


LAB REPORT: 5
Submitted By:

Hamza Nazir
(2872)
Submitted To:

Ma’am Syeda Humaira Batool


DATE:
Bscs-40B (4rd Semester) Evening

Tasks:
Objective
Database Connectivity

Code:
Class

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

Lab 5 Hamza Nazir 1


public class st_info implements ActionListener {
public static void main(String[] args) {
new st_info();

// getconnection();
/// createtable();
}
JFrame f;
JLabel l1;

JLabel l2;
JTextField t1;
JLabel l3;
JTextField t2;
JLabel l4;
JComboBox cb;
JLabel l5;
JTextField t3;
JButton b1;
JButton b2;
st_info()
{
f=new JFrame("SMS");
f.setSize(400,400);
l1=new JLabel("Student Mangment System");
l1.setBounds(50, 30, 200, 40);
f.add(l1);

/// Component

l2 = new JLabel("Std_id");
l2.setBounds(30, 80, 200, 40);
f.add(l2);

/// text field

t1 = new JTextField();
t1.setBounds(100, 80, 200, 20);
f.add(t1);
//
//
//
l3 = new JLabel("Std_Name ");
l3.setBounds(30, 130, 200, 40);
f.add(l3);

t2 = new JTextField();
t2.setBounds(100, 130, 200, 20);
f.add(t2);

l4 = new JLabel("Std_degree");
l4.setBounds(30, 180, 200, 40);
f.add(l4);

/// combobox

String degree[] = {"Select Degree","MS", "BS", "PHD"};


cb = new JComboBox(degree);
cb.setBounds(100, 180, 200, 40);
f.add(cb);

l5 = new JLabel("Std_Cgpa ");


l5.setBounds(30, 230, 200, 40);
f.add(l5);

t3 = new JTextField();
t3.setBounds(100, 230, 200, 40);
f.add(t3);

/// Button

b1= new JButton("Insert");


b1.setBounds(120, 290, 100,30);
f.add(b1);

Lab 5 Hamza Nazir 2


b2= new JButton("Delete");
b2.setBounds(220, 290, 100,30);
f.add(b2);
b1.addActionListener(this);
b2.addActionListener(this);

f.setLayout(null);
f.setVisible(true);

String s_id;
String s_name;
String s_cgpa;
String s_degree;

@Override
public void actionPerformed(ActionEvent e) {
if (e.getSource()==b1)
{
s_id=t1.getText();
s_name=t2.getText();
s_cgpa=t3.getText();
s_degree= cb.getToolTipText();
Connection conn=getconnection();
try {
assert conn != null;
PreparedStatement insert=conn.prepareStatement( "INSERT INTO student_info(st_id,st_name,st_deg,st_gpa) VALUE(?,?,?,?)");
insert.setString(1,s_id );
insert.setString(2,s_name );
insert.setString(3,s_degree );
insert.setString(4,s_cgpa );

insert.executeUpdate();
System.out.println("insert selected");
} catch (Exception ex) {
System.out.println("execption in insertion ");
}

}
if (e.getSource()==b2)
{

}
}

public static void createtable() {


Connection conn = getconnection();
try {
PreparedStatement create = conn.prepareStatement("create table student_info(id int(20) primary key auto_increment, st_id varcha

create.executeUpdate();
} catch (Exception ex) {
System.out.println("execption in creation me ");
}

public static Connection getconnection()


{
System.out.println("-----------enter getconnection function----------");
try{
String driver="com.mysql.cj.jdbc.Driver";
String databseurl="jdbc:mysql://localhost:3306/testjdbc";
// String databseurl="jdbc:mysqul://localhost/phpmyadmin/index.php?route=/server/databases";
String username="root";
String password="";
Class.forName(driver);
Connection conn= DriverManager.getConnection(databseurl,username,password);
System.out.println("Data base connected");

Lab 5 Hamza Nazir 3


return conn;
} catch (Exception e) {
System.out.println("err aya hai connection me:"+e);
}
return null;
}
}

Output

Lab 5 Hamza Nazir 4

You might also like