Java JDBC programme problem in execution

[Souranil21 chakraborty]

This is the main code

import java.util.*;
import java.sql.*;
import java.sql.Connection;
import java.sql.Statement;
public class jdbc {
   public static void main(String args[]){
    ResultSet selectquery;
    Statement st;
    try{
        // DriverManager.registerDriver(new com.mysql.jdbc.Driver ());
        // Class.forName("com.mysql.jdbc.Driver");
        Connection con1=DriverManager.getConnection("jdbc:mysql://localhost:3306/Studentname?useSSL=false", "souranil", "soura21nil29");
        System.out.println("Database connected.");
        st=con1.createStatement();
        // st.execute("Use Studentname");
        System.out.printf("Database connnection established.\n");
        st.execute("Insert into Department values(6,'B.Pharama')");
        selectquery=st.executeQuery("Select distinct(deptid),deptname from Department ");
        while(selectquery.next()){
            System.out.println("Department ID: "+selectquery.getString("deptid")+" Departmentname: "+selectquery.getString("deptname"));
        }
    }
    catch(Exception e){
        System.out.println(e.getMessage());
    }
    finally{
        System.out.printf("The programme terminates here.\n");
    }
   }
}

i have this logic and.so when i try to manually compile and execute the program from the terminal it gives this error.

 

But when i tried to execute the program through the run button in vscode just above the main function 

it worked perfectly as expected and this is the output:

 

Can anyone help me what is the problem here

[QuantumRand]

Try

javac jdbc.java -classpath "<path to mysql-connector-java-5.1.49.jar>"
java jdbc

Adding things to the global CLASSPATH is asking for trouble. A relative path can throw things off, or if something changes the classpath, all of a sudden other things start breaking.

[Biohazard777]

2 hours ago, Souranil21 chakraborty said:

it worked perfectly as expected and this is the output:

1. First letter of your class name should not be in lower case. (this won't affect your program, but do try to follow naming conventions)
2. Close the connection once you are done with it, same goes for the statement and result set.
3. That finally does nothing beside print, inside of that you should be doing if not null rs, st, conn --> close them.
   Or use try-with-resources instead.
    

2 hours ago, Souranil21 chakraborty said:

Can anyone help me what is the problem here

Learn about proper build tools such as Maven or Gradle.