Database

package database;

import java.sql.*;
public class Database {

    public static void main(String[] args) {

        String url = "jdbc:mysql://localhost/info";
        String user = "root";
        String password = "root";
        try {
            Connection con = DriverManager.getConnection(url, user, password);
            Statement state = con.createStatement();

            String sql="insert into student(id,name,semester)values('171','david','6th')";
            state.executeUpdate(sql);
            String sql2="delete from student where id ='152'";
            state.executeUpdate(sql2);

            ResultSet result = state.executeQuery("Select * from student");
            while (result.next()) {
                System.out.println("Id : " + result.getString("id"));
                System.out.println("Name: " + result.getString("name"));
                System.out.println("Semester: " + result.getString("semester"));
                System.out.println("");
            }
        } catch (Exception ex) {
            ex.printStackTrace();
            System.out.println("Cause : " + ex.getCause());
        }
    }

}