[go: up one dir, main page]
Scribd
Upload
14 views5 pages

Java Cgpa Calc

Uploaded by

Rounak Naik

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt

Java Cgpa Calc

Uploaded by

Rounak Naik
14 views5 pages

Copyright

© © All Rights Reserved

Available Formats

DOCX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
14 views5 pages

Java Cgpa Calc

Uploaded by

Rounak Naik

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1/ 5

VERIFY button:

private void verifyButtonActionPerformed(java.awt.event.ActionEvent evt) {


String rollno = rollnoVar.getText().trim();
if (rollno.isEmpty()) {
JOptionPane.showMessageDialog(this, "Please enter Roll No", "Error",
JOptionPane.ERROR_MESSAGE);
return;
}
try (
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", "root",
"");
PreparedStatement ps = con.prepareStatement("SELECT name, department, semester FROM
student_info WHERE rollno = ?");
){

ps.setString(1, rollno);
try (ResultSet rs = ps.executeQuery()) {
if (rs.next()) {
// Retrieve data from ResultSet and display in labels
nameVar.setText(rs.getString("name"));
departmentVar.setText(rs.getString("department"));

semesterVar.setSelectedItem(rs.getString("semester"));

JOptionPane.showMessageDialog(this, "Data fetched successfully!");


} else {
JOptionPane.showMessageDialog(this, "No record found for Roll No: " + rollno, "Info",
JOptionPane.INFORMATION_MESSAGE);

// Clear labels if no data found


nameVar.setText("");
departmentVar.setText("");
semesterVar.setSelectedItem("");

}
}
} catch (SQLException e) {
JOptionPane.showMessageDialog(this, "Error: " + e.getMessage(), "Error",
JOptionPane.ERROR_MESSAGE);
e.printStackTrace();
}
}

ADD button:
private void addButtonActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try{
Class.forName("com.mysql.cj.jdbc.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root","");


System.out.println(con);

PreparedStatement ps = con.prepareStatement("INSERT INTO student_info(name, rollno,


department, semester) VALUES (?, ? ,?, ?)");
ps.setString(1, nameVar.getText());
ps.setString(2, rollnoVar.getText());
ps.setString(3, departmentVar.getText());
ps.setString(4, selectedSemester);
ps.executeUpdate();

System.out.println("Inserted Successfully!");
JOptionPane.showMessageDialog(this, "Added Successfully!");
}catch(ClassNotFoundException | SQLException e){
System.out.println(e);
}

CALCULATE button:

private void calculateButtonActionPerformed(java.awt.event.ActionEvent evt) {


Integer.parseInt(sub3.getText()) + Integer.parseInt(sub4.getText()) + Integer.parseInt(sub5.getText())
+ Integer.parseInt(sub6.getText());

int s1 = calculateGradePoint((Integer.parseInt(sub1.getText())));
int s2 = calculateGradePoint((Integer.parseInt(sub2.getText())));
int s3 = calculateGradePoint((Integer.parseInt(sub3.getText())));
int s4 = calculateGradePoint((Integer.parseInt(sub4.getText())));
int s5 = calculateGradePoint((Integer.parseInt(sub5.getText())));
int s6 = calculateGradePoint((Integer.parseInt(sub6.getText())));

double cgpa = (double) (s1+s2+s3+s4+s5+s6) / 6; // First divide by 6, then divide by 10 to get


CGPA

label.setText(String.format("Your CGPA is : %.2f", cgpa)); // Display CGPA with 2 decimal places


}
JAVA PROJECT

CGPA CALCULATOR

Team members:
Rounak Naik
Atharv Pednekar
Elizabeth Joseph
Arnav Cundaikar

Block Diagram:

You might also like