Write a JDBC program to update the Doctor (dno, dname, city) information. Update city from ‘Pune’ to ‘Mumbai

 

import java.sql.*;

 

class UpdateDoctor {

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

                Statement stmt;

             Class.forName("com.mysql.jdbc.Driver");

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

              stmt = con.createStatement();

        

 int n = stmt.executeUpdate("UPDATE Doctor SET city = 'Mumbai' WHERE city = 'Pune'");

              System.out.println(n + " rows updated..");

        

           con.close();

    }

}