package assignment;
import java.util.ArrayList;
import java.util.Scanner;
public class Student {
    private String name;
    private String age;
    private String phone;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getAge() {
        return age;
    }
    public void setAge(String age) {
        this.age = age;
    }
    public String getPhone() {
        return phone;
    }
    public void setPhone(String phone) {
        this.phone = phone;
    }
    public static  Student stDetails() {
        Scanner s= new Scanner(System.in);
        Student st= new Student();
        boolean isTrue=true;
        ArrayList<String> sn=null;
        while (isTrue) {
            System.out.println("enter the student name,age and phone");
            st.name=s.nextLine();
            st.age=s.nextLine();
            st.phone=s.nextLine();
            ArrayList<String > alst= new ArrayList<>();
            alst.add(st.name);
            alst.add(st.age);
            alst.add(st.phone);
            System.out.println("if you want enter details again enter 1, if not enter 99");
            int t=s.nextInt();
            switch (t) {
            case 1:
                sn=alst;
                Student.stDetails();
                break;
            case 99:
                s.close();
                System.exit(0);
            }
        }
        return sn ;
    }
}

package assignment;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
public class Runner {
    public static void main(String[] args) {
        String URL="jdbc:mysql://localhost:3306";
        String UN="root";
        String PWD="shiva";
        Connection con=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");// load and register the driver
            con=DriverManager.getConnection(URL,UN,PWD);// establish a connection
            Statement stmt= con.createStatement();// create a  platform
            ArrayList<Student> lst= new ArrayList<Student>();//execute a statement
            lst.add(Student.stDetails());
            for (Student st : lst) {
                String sql="insert into m_jdbc.user values('"+st.getName() +" ''"+st.getAge() +" '+'"+st.getPhone() +" ')";
                stmt.execute(sql);
            }
        }
        catch (ClassNotFoundException | SQLException e)
        {
            e.printStackTrace();
        }
        finally
        {
            if (con!=null) {
                try {
                    con.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}