Bank Application Project Section 14: Deposit Feature Using JDBC and NetBeans,lesson

In this video, we continue our bank application project using Java, NetBeans, and MySQL (XAMPP). This lesson focuses on implementing the deposit feature. We'll cover how to use JDBC and PreparedStatement to interact with the database securely. Watch to learn how to:

1. Search for an account by name.
2. Calculate the new balance after a deposit.
3. Update the balance in the database.

Code snippets used in the video:
```java
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
String sql = "SELECT * FROM balances WHERE Name = ?";
try {
pst = conn.prepareStatement(sql);
pst.setString(1, jTextField12.getText());
rs = pst.executeQuery();
if (rs.next()) {
String add1 = rs.getString("Name");
jTextField13.setText(add1);
String add2 = rs.getString("Acc");
jTextField14.setText(add2);
String add3 = rs.getString("Balance");
jTextField15.setText(add3);
rs.close();
pst.close();
} else {
JOptionPane.showMessageDialog(null, "Please enter the correct name.");
}
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
try {
String text1 = jTextField15.getText();
String text2 = jTextField16.getText();
int number1 = Integer.parseInt(text1);
int number2 = Integer.parseInt(text2);
int sum = number1 + number2;
String sumString = String.valueOf(sum);
jTextField17.setText(sumString);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}

private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
try {
String name = jTextField13.getText();
String balance = jTextField17.getText();
String sql = "UPDATE balances SET Balance = ? WHERE Name = ?";
pst = conn.prepareStatement(sql);
pst.setString(1, balance);
pst.setString(2, name);
pst.executeUpdate();
JOptionPane.showMessageDialog(null, "Deposit successful.");
clearFields();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}

private void clearFields() {
jTextField12.setText("");
jTextField13.setText("");
jTextField14.setText("");
jTextField15.setText("");
jTextField16.setText("");
jTextField17.setText("");
}

Видео Bank Application Project Section 14: Deposit Feature Using JDBC and NetBeans,lesson канала Tareg Balola