content: package insertData;
  
  import java.sql.Connection;
  import java.sql.DriverManager;
  import java.sql.PreparedStatement;
  import java.util.Scanner;
  
  public class insertData {
  
  	private static Scanner sc;
  
  	public static void main(String[] args) throws Exception { // throws Exception is used to handle the exception without using try-catch block
  		
  	sc = new Scanner(System.in);
  	System.out.println("Enter the student details: ");
  	System.out.print("Enter the student id: ");
  	int id = sc.nextInt();
  	System.out.print("Enter the student name: ");
  	String name = sc.next();
  	System.out.print("Enter the student branch: ");
  	String branch = sc.next();
  		
  	 Class.forName("com.mysql.cj.jdbc.Driver"); // load and register the driver
  	 
  	 Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3308/jdbc_db", "root", "Akash@123"); // establish the connection
  		
  	 PreparedStatement ps = connection.prepareStatement("insert into student values('"+id+"','"+name+"','"+branch+"')"); // execute the query")
  	
  	 int i = ps.executeUpdate(); // execute the query
  		if (i > 0) // if the record is inserted successfully then it will return 1 else 0
  			System.out.println("Record inserted successfully");
  		else
  			System.out.println("Record not inserted successfully");
  	 
  	}
  
  }
  