Scribd
Upload
523 views

Bank Management System in Java and Mysql

This document contains source code for connecting a Java application to a MySQL database. It includes code for inserting, selecting, updating, and deleting records. Specifically, it shows: 1. Code to insert student records from Java fields to a MySQL table 2. Code to select and display all records from a MySQL table in a Java table 3. Code to select a single record from MySQL based on account number and display in Java fields 4. Code to delete a record from MySQL based on account number The document also includes sample output screens from the Java application.

Uploaded by

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

Bank Management System in Java and Mysql

This document contains source code for connecting a Java application to a MySQL database. It includes code for inserting, selecting, updating, and deleting records. Specifically, it shows: 1. Code to insert student records from Java fields to a MySQL table 2. Code to select and display all records from a MySQL table in a Java table 3. Code to select a single record from MySQL based on account number and display in Java fields 4. Code to delete a record from MySQL based on account number The document also includes sample output screens from the Java application.

Uploaded by

Mayurikaa Sivakumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 26

PARTICULARS OF STUDENT

NAME :
REG NO :
CLASS :

1 CERTIFICATE 3
2 ACKNOWLEDGMENT 4
3 OVERVIEW OF Java NetBeans 5
4 HARDWARE REQUIREMENTS 8
5 SOFTWARE REQUIREMENTS 9
6 CODINGS 10-29
7 OUTPUT 30-34
8 BIBLIOGRAPHY 35
INDEX

Source Code
Source code for inserting values from
JAVA to MYSQL
package project1;
import java.sql.*;
import javax.swing.JOptionPane;
import
javax.swing.table.DefaultTableModel;
private void
formWindowActivated(java.awt.event.WindowE
vent evt) {
// TODO add your handling code
here:
char g;int r1,inc;
try
{
//DefaultTableModel
model=(DefaultTableModel)
jTable1.getModel();
Class.forName("java.sql.Driver");
try (Connection c =
DriverManager.getConnection("jdbc:mysql://
localhost/first","root","1234")) {
try (Statement s =
c.createStatement()) {

if(jRadioButton1.isSelected()==true)
g='Y';
else
g='N';

r1=Integer.parseInt(jTextField1.getText())
;

inc=Integer.parseInt(jTextField10.getText(
));
String q="insert into Bank1
values("+"'"+r1+"',"+"'"+jTextField2.getTe
xt()+"',"+"'"+jTextField3.getText()+"',"+"
'"+jTextField4.getText()+"',"+"'"+jTextFie
ld5.getText()+"',"+"'"+jTextField6.getText
()+"',"+"'"+jTextField7.getText()+"',"+"'"
+jTextField8.getText()+"',"+"'"+jTextField
9.getText()+"',"+"'"+inc+"',"+"'"+jTextFie
ld11.getText()+"',"+"'"+g+"'"+");" ;
s.executeUpdate(q);
}

}
}
catch(ClassNotFoundException |
NumberFormatException | SQLException e)
{

JOptionPane.showMessageDialog(this,
e.toString());

}
this.setVisible(false);
new NewJFrame1().setVisible(true);
}
{
DefaultTableModel
model=(DefaultTableModel)
jTable1.getModel();
Class.forName("java.sql.Driver");
Connection
c=DriverManager.getConnection("jdbc:mysql:
//localhost/first","root","1234");
Statement s=c.createStatement();
String q="select * from stupro";
ResultSet r=s.executeQuery(q);
while(r.next())
{
String n=r.getString("name");
int ro=r.getInt("roll");
String
st=r.getString("stname");
String
ad1=r.getString("add1");
String
ad2=r.getString("add2");
String
ph=r.getString("phone");
String
ma=r.getString("email");
String g=r.getString("gender");
//int sa=r.getInt("sal");
model.addRow(new Object[]
{n,ro,st,ad1,ad2,ph,ma,g});
}
r.close();;
s.close();;
c.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,
e.toString());

}
}

Private void
jButton1ActionPerformed(java.awt.event.Act
ionEvent evt) {
// TODO add your handling code
here:
this.setVisible(false);
new NewJFrame().setVisible(true);
}

private void
jButton2ActionPerformed(java.awt.event.Act
ionEvent evt) {
// TODO add your handling code
here:
int x;
try
{
DefaultTableModel
model=(DefaultTableModel)
jTable1.getModel();
Class.forName("java.sql.Driver");
Connection
c=DriverManager.getConnection("jdbc:mysql:
//localhost/first","root","1234");
Statement s=c.createStatement();

x=Integer.parseInt(jTextField1.getText());
String q="select * from stupro
where roll="+x+";";
ResultSet r=s.executeQuery(q);
while(r.next())
{
String n=r.getString("name");
int ro=r.getInt("roll");
String
stn=r.getString("stname");
String
ad1=r.getString("add1");
String
ad2=r.getString("add2");
String
ph=r.getString("phone");
String
mail=r.getString("email");
String
gen=r.getString("gender");
model.addRow(new Object[]
{n,ro,stn,ad1,ad2,ph,mail,gen});
}
r.close();;
s.close();;
c.close();
}
catch(Exception e)
{

JOptionPane.showMessageDialog(this,
e.toString());

Source code for displaying Account


holder’s details from MYSQL to JAVA
private void
formWindowActivated(java.awt.event.WindowE
vent evt) {
// TODO add your handling code
here:
try
{
DefaultTableModel
model=(DefaultTableModel)
jTable1.getModel();
Class.forName("java.sql.Driver");
Connection
c=DriverManager.getConnection("jdbc:mysql:
//localhost/first","root","1234");
Statement s=c.createStatement();
String q="select * from bank1";
ResultSet r=s.executeQuery(q);
while(r.next())
{
String n=r.getString("name");
int ro=r.getInt("acno");
String
st=r.getString("stname");
String
ad1=r.getString("add1");
String
ad2=r.getString("add2");
String
ph=r.getString("phone");
String ma=r.getString("mail");
String g=r.getString("opdate");
int inc=r.getInt("inc");
//int sa=r.getInt("sal");
model.addRow(new Object[]
{ro,n,st,ad1,ad2,ph,ma,g,inc});
}
r.close();;
s.close();;
c.close();
}
catch(Exception e)
{

JOptionPane.showMessageDialog(this,
e.toString());

}
}

Source code for calculating interest


rate according to the A/C No Chosen
private void
jButton5ActionPerformed(java.awt.event.Act
ionEvent evt) {
// TODO add your handling code
here:
try
{
//DefaultTableModel
model=(DefaultTableModel)
jTable1.getModel();

Class.forName("java.sql.Driver");
Connection
c=DriverManager.getConnection("jdbc:mysql:
//localhost/first","root","1234");
Statement
s=c.createStatement();
String q="delete from stupro
where
roll="+Integer.parseInt(jTextField8.getTex
t())+";" ;
s.executeUpdate(q);

//r.close();;
s.close();;
c.close();
}
catch(Exception e)
{

JOptionPane.showMessageDialog(this,
e.toString());

JOptionPane.showMessageDialog(this, "The
record is deleted permanently");
jTextField8.setText("");
}
Source code for displaying a particular
A/C Holder’s details
private void
jButton1ActionPerformed(java.awt.event.Act
ionEvent evt) {
// TODO add your handling code
here:
int x;
try
{
DefaultTableModel
model=(DefaultTableModel)
jTable1.getModel();

Class.forName("java.sql.Driver");
Connection
c=DriverManager.getConnection("jdbc:mysql:
//localhost/first","root","1234");
Statement
s=c.createStatement();

x=Integer.parseInt(jTextField1.getText());
String q="select * from bank1
where acno="+x+";";
ResultSet r=s.executeQuery(q);
while(r.next())
{
String
n=r.getString("name");
int ro=r.getInt("acno");
String
st=r.getString("stname");
String
ad1=r.getString("add1");
String
ad2=r.getString("add2");
String
ph=r.getString("phone");
String
ma=r.getString("mail");
String
g=r.getString("opdate");
int inc=r.getInt("inc");
model.addRow(new Object[]
{ro,n,st,ad1,ad2,ph,ma,g,inc});
}
r.close();;
s.close();;
c.close();
}
catch(Exception e)
{

JOptionPane.showMessageDialog(this,
e.toString());

}
}

Source code for deleting a particular


Account
Private void
jButton3ActionPerformed(java.awt.event.ActionEvent
evt) {
try
{
//DefaultTableModel model=(DefaultTableModel)
jTable1.getModel();
Class.forName("java.sql.Driver");
try (Connection c =
DriverManager.getConnection("jdbc:mysql://localhost/fi
rst","root","1234")) {
try (Statement s = c.createStatement()) {
int
x=Integer.parseInt((jTextField12.getText()));
String q="delete from bank1 where ="+x+";" ;

s.executeUpdate(q);
}

}
}
catch(ClassNotFoundException |
NumberFormatException | SQLException e)
{
JOptionPane.showMessageDialog(this,
e.toString());
}
JOptionPane.showMessageDialog(this, "The record
is deleted permanently");
jTextField12.setText("");
}
OUTPUT SCREENS
Account Holder Details
Displaying details of all A/C holders
Interest rate calculation
Displaying a Particular A/C holder’s Details
Deleting a Particular A/C

You might also like