7

package javajdbc;
import java.sql.*;
import javax.sql.*;
import java.util.*;

public class Javajdbc {

    public static void main(String[] args) {
        Scanner sc = new Scanner(System.in);
        String usn,name,dept;
        System.out.println("Enter Name:");
        name= sc.next();
        System.out.println("Enter USN:");
        usn= sc.next();
        System.out.println("Enter Dept.:");
        dept= sc.next();
        try{
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection con =DriverManager.getConnection("jdbc:mysql://localhost:3306/Student","root","root");
            Statement stmt = con.createStatement();
            String q1 = "insert into student values('" +usn+"','"+name+"','"+dept+"')";

            stmt.executeUpdate(q1);
        }
       catch(Exception e){
           System.out.println(e);
       }
    }

}





package javajdbc;

import java.sql.*;
import javax.sql.*;
public class output {
    public static void main(String[] args) {


    try{
            Class.forName("com.mysql.jdbc.Driver");
            Connection con =DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","root");
            Statement stmt = con.createStatement();
            String q2 = "select * from student";
            ResultSet rs = stmt.executeQuery(q2);
            while(rs.next()){
                System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
        }
            }
       catch(Exception e){
           System.out.println(e);
       }
    }
    }