title: Trying to run SQL statements in the Main of a Java application
body: <p>I've successfully connected to the database through intellij, but I can't figure out how to run sql statements in the main. I have a database class that can run all of the SQL statements but can't get it to work as if I were to write functions that can insert and delete.</p>
  
  <pre><code>public static void main (String[] args)
      {
  
          Connection conn;
  
          {
              try {
                  conn = DriverManager.getConnection("jdbc:mysql://35.247.87.196:4406","username","password");
                  Statement stmt=conn.createStatement();
                  String strselect="select * from EmployeeTable";
                  System.out.println("The sql statement is: "+strselect+"\n");
  
              } catch (SQLException e) {
                  e.printStackTrace();
              }
          }
  
      }
  </code></pre>
  
  <p>and I get the exception</p>
  
  <pre><code>java.sql.SQLException: No suitable driver found for jdbc:mysql://35.247.87.196:3306
      at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702)
      at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
      at DataGenerator.main(DataGenerator.java:30)
  </code></pre>