package javatest;

import java.sql.*;
import java.sql.DriverManager;
import java.sql.SQLException;

public class JavaTest {

    public static void main(String[] args) {

        //Connecting the database
        try{
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/employeedetails","root","");
        Statement stmt=conn.createStatement();

        //Insert a new record
        String s="INSERT INTO emp VALUES (13,'gfgf','Marketing', 125000)";
        stmt.executeUpdate(s);

        //Display all records
        ResultSet res=stmt.executeQuery("Select * from emp");
        while(res.next()){
            System.out.print(res.getInt(1)+" | ");
            System.out.print(res.getString(2)+" | ");
            System.out.print(res.getString(3)+" | ");
            System.out.println(res.getInt(4));
        }
        //Update a record
        String s1="UPDATE emp SET name='Emily' WHERE id=5" ;
        stmt.executeUpdate(s1);

        //Delete a record
        String s2="DELETE  FROM emp WHERE name='Bobby'" ;
        stmt.executeUpdate(s2);
        }

        catch(SQLException | ClassNotFoundException ex){
            System.out.println(ex.getMessage());
        }
    }
}