JDBC

package connection;


//import java.sql.DriverManager;
import java.sql.*;

public class StudentConnection {
    Connection con;
    StudentConnection(){
        try{
            Class.forName("com.mysql.cj.jdbc.Driver");
            System.out.println("Connecting to Database...");
            String connectionURL = "jdbc:mysql://localhost:3306/student";
            con = DriverManager.getConnection(connectionURL,"root","");
            System.out.println("Connection to Database successfully...");
        }
        catch (ClassNotFoundException e){
            e.printStackTrace();
        }
        catch (SQLException e){
            e.printStackTrace();
        }
    }

    public static void main(String[] args) {
        StudentConnection obj = new StudentConnection();
    }
}






package connection;

import java.sql.*;

public class DatabaseHelper extends StudentConnection{

    void insert(){
        try{
            //Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","");
            String insert_query = "insert into Student values(04,'vijay','BBA',2017)";
            PreparedStatement preparedStatement = con.prepareStatement(insert_query);
            int a= preparedStatement.executeUpdate();
            insert_query = "insert into Student values(01,'prateek','CSE',2018)";
            a += preparedStatement.executeUpdate(insert_query);
            System.out.println("Data inserted by affecting "+a+" row");
        }
        catch (Exception e){
            System.out.println(e);
        }
    }

    void view(){
        String view_query = "select * from Student";
        try{
            PreparedStatement preparedStatement = con.prepareStatement(view_query);
            ResultSet resultSet = preparedStatement.executeQuery(view_query);

            while(resultSet.next()){
                System.out.print("  "+resultSet.getInt("studentID"));
                System.out.print("  "+resultSet.getString("studentName"));
                System.out.print("  "+resultSet.getString("studentCourse"));
                System.out.print("  "+resultSet.getInt("year"));
                System.out.println("\n");

            }
            System.out.println("Data Found");
        }
        catch (Exception e){
            System.out.println(e);
        }
    }

    void delete(){

    }

    public static void main(String[] args) {
        DatabaseHelper obj = new DatabaseHelper();
        obj.insert();
        obj.view();
    }

}