How to Update Data using JDBC

Program 2

// Search by Primary key data in database
package mydatabase;
import java.sql.*;
import java.util.*;
public class TestSearchMain 
{
    public static void main(String[] args) 
    {
        Connection con=null;
        ResultSet rs=null;
        PreparedStatement ps=null;
        //Driver load
         try
         {
             Class.forName("com.mysql.cj.jdbc.Driver");
             System.out.println("Driver load");
         }
         catch(ClassNotFoundException e)
         {
             System.out.println(e);
         }
         //Database Connection 
         try 
         {
             con=DriverManager.getConnection("jdbc:mysql:/dataflair", "root", "root@data");
             System.out.println("Database connection done....");     
             
             // Query Execution
             int rno; 
             String sql;
             System.out.println("Enter Roll no for search: ");
             Scanner scan=new Scanner(System.in);
             rno=scan.nextInt();
             sql="select * from student where studid=?";
             ps=con.prepareStatement(sql);
             ps.setInt(1, rno);
             rs=ps.executeQuery();
             if(rs.next())  
             {
                 System.out.println("Roll No: "+rs.getInt(1)); 
                 System.out.println("Name: "+rs.getString(2)); 
                 System.out.println("Mobile No: "+rs.getInt(3)); 
             }    
             else
                 System.out.println("Record not found.....");   
           // Connection close  
            con.close();
          } 
         catch (SQLException e) 
         {
             System.out.println(e);
         }
         
         
             
    }
    
}