package Studentmanager;

import java.sql.*;
import java.util.Scanner;

public class manager {
    public void manager(){}
    public void view(){
        try{
            //Buoc 2 - khai bao driver
            Class.forName("com.mysql.jdbc.Driver");

            //Buoc 3 - Tao Database URL
            String DB_URL="jdbc:mysql://localhost:3306/t1806e";
            String DB_USER="root";
            String DB_PASS="root";

            //Buoc 4 - ket noi DB
            Connection conn= DriverManager.getConnection(DB_URL,DB_USER,DB_PASS);
            //Buoc 5 - thuc thi truy van
        Statement statement = conn.createStatement();//Tao 1 obj statement
        String sql ="SELECT*FROM student"; //tao 1 string query
            ResultSet resultSet = statement.executeQuery(sql);

            while (resultSet.next()){
                System.out.println("ID: "+resultSet.getInt("id"));
                System.out.println("Name: "+resultSet.getString("Name"));
                System.out.println("Age: "+resultSet.getInt("age"));
                System.out.println("Mark: "+resultSet.getInt("mark"));

            }
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }catch (SQLException e){
            e.printStackTrace();
        }

    }
    public void Add(){
        try{
            //Buoc 2 - khai bao driver
            Class.forName("com.mysql.jdbc.Driver");

            //Buoc 3 - Tao Database URL
            String DB_URL="jdbc:mysql://localhost:3306/t1806e";
            String DB_USER="root";
            String DB_PASS="root";

            //Buoc 4 - ket noi DB
            Connection conn= DriverManager.getConnection(DB_URL,DB_USER,DB_PASS);
            //Buoc 5 - thuc thi truy van
            Statement statement = conn.createStatement();//Tao 1 obj statement
            String sql ="SELECT*FROM student"; //tao 1 string query
            ResultSet resultSet = statement.executeQuery(sql);
            Scanner scanner=new Scanner(System.in);
            System.out.println("Nhap ten sinh vien:");
            String name= scanner.nextLine();
            System.out.println("Nhap tuổi sinh viên:");
            int age = scanner.nextInt();
            System.out.println("Nhập điểm sinh viên:");
            int mark=scanner.nextInt();
            String sql2="INSERT INTO student (Name,age,mark) VALUES ('"+name+"','"+age+"','"+mark+"')";
            statement.executeUpdate(sql2);
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }catch (SQLException e){
            e.printStackTrace();
        }

    }
    public void Delete(){
        try{
            //Buoc 2 - khai bao driver
            Class.forName("com.mysql.jdbc.Driver");

            //Buoc 3 - Tao Database URL
            String DB_URL="jdbc:mysql://localhost:3306/t1806e";
            String DB_USER="root";
            String DB_PASS="root";

            //Buoc 4 - ket noi DB
            Connection conn= DriverManager.getConnection(DB_URL,DB_USER,DB_PASS);
            //Buoc 5 - thuc thi truy van
            Statement statement = conn.createStatement();//Tao 1 obj statement
            Scanner scanner=new Scanner(System.in);
            System.out.println("Nhap ten ID sinh vien cần xóa:");
            int id = scanner.nextInt();
            String sql3="DELETE FROM student WHERE id = '"+id+"'";
            statement.executeUpdate(sql3);
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }catch (SQLException e){
            e.printStackTrace();
        }

    }
}