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); } } }