package prg10;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
import java.util.logging.Level;
import java.util.logging.Logger;

public class Prg10 {
        Statement st=null;
        Preparedstatement pat = null;
        ResultSet rs = null;
        Connection con=null;
    String driver="com.mysql.jdbc.Driver";
    String url="jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convertToNull";
    String username="root";
    String password="root";
    public Prg10()
    {
        try {
            try {
                Class.forName(driver);
                con=DriverManager.getConnection(url, username,password);
            } catch (SQLException ex) {
                Logger.getLogger(Prg10.class.getName()).log(Level.SEVERE, null, ex);
            } catch (ClassNotFoundException ex) {
                Logger.getLogger(Prg10.class.getName()).log(Level.SEVERE, null, ex);
            }
            int choice;
            InputStreamReader isr=new InputStreamReader(System.in);
            BufferedReader br = new BufferedReader(isr);
            System.out.println("CRUD operations in JDBC");
System.out.println("1. Create Table\n 2. Insert\n 3. Read\n 4. Delete\n 5. Update\n 6. Alter\n 7. Drop\n 8. Exit\n");
            System.out.println("Enter your Choice of Operations");
            Scanner scanner = new Scanner(System.in);
            choice = scanner.nextInt();
            System.out.println("Enter your query");
            String qry=scanner.nextLine();
            scanner.hasNextLine();
            st=con.createStatement();
            switch(choice)
            {
                case 1:
                    st.execute(qry);
                    System.out.println("Table Created Successfully");
                    break;
                case 2:
                    int row = st.executeUpdate(qry);
                    System.out.println("Inserted Successfully");
                    break;
                case 3:break;
                case 4:break;
                case 5:break;
                case 6:break;
                case 7:break;
                case 8:System.exit(0);

            }
        } catch (SQLException ex) {
            Logger.getLogger(Prg10.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    public static void main(String[] args) {
        Prg10 p1 = new Prg10();

    }
}