(Blog) CLASSNOTFOUNDEXCEPTION in MySQL

CLASSNOTFOUNDEXCEPTION_demo.java

/**
  Get server version.
*/

import java.sql.*;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.*;

public class Version {

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

    public void getVersion() {
    /* it is important to place the code below under 'try' */
    try {
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:13000/test","root","");
        Statement st = con.createStatement();
        ResultSet rs = st.executeQuery("SELECT VERSION()");

        while(rs.next())
        {
          System.out.println(rs.getString(1));
        }
      } catch(Exception e) { System.out.println(e); }
    }  //end of getVersion()
} //end of Version Class