Q) Develop a JDBC application that increase the balance of the account holder by 500.

A)

// IncreaseBalance.java

import java.sql.*;

class IncreaseBalance {

       public static void main(String[] args)throws Exception {

              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

              Connection con = DriverManager.getConnection("Jdbc:Odbc:mydns","scott","tiger");

              Statement st = con.createStatement();

              int rc = st.executeUpdate("UPDATE ACCOUNT SET BALANCE=BALANCE+500 where ACCNO=1001");

              System.out.println(rc+"record is updated");

              st.close();

              con.close();

       }

}