i have the problem of the connection java to MySQL
i oledi download the entire software:
-J2SE development kit 5.0 update6.0
-MySQL 4.1.16
-MySQL connector/j 3.1.12
is it enough for me to connect the java application to MySQL??
i oledi set the classpath like that:
my computer right click>properties >advanced >Environment Variables> System
Variables>
create CLASSPATH and key in my .jar url which is:
C:\mysql-connector-java-3.1.12\mysql-connector-java-3.1.12-bin.jar
is it i inthe right path?
when i compile the source code, the error line come out:
Test.java:20: unreported exception java.lang.ClassNotFoundException; must be
cau
ght or declared to be thrown
                         Class.forName ("JDBC_DRIVER");
                                       ^
1 error

And my source code is:::
import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

public class Test
{
    static final String JDBC_DRIVER = "org.gjt.mm.mysql.driver";
    static final String DATABASE_URL = "jdbc:mysql://localhost/test";
   
    public static void main( String args[] )
    {
        Connection connection = null;
        Statement statement = null;
       
        try
        {
             Class.forName ("JDBC_DRIVER");
            connection =
                DriverManager.getConnection(DATABASE_URL,"root"," ");
            statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery(
                "SELECT name,last_name FROM t");
            ResultSetMetaData metaData = resultSet.getMetaData();
            int numberOfColumns = metaData.getColumnCount();
            System.out.println( " Name is:");
            for ( int i=1; i <= numberOfColumns;i++)
                System.out.printf( "%-8s\t",metaData.getColumnName(i));
            System.out.println();
            while (resultSet.next())
            {
                for(int i=1;i <= numberOfColumns; i++)
                    System.out.printf("%-8s\t",resultSet.getObject(i));
                System.out.println();
            }
        }
        catch ( SQLException sqlException )
        {
            sqlException.printStackTrace();
            System.exit(1);
        }
        finally
        {
            try
            {
                statement.close();
                connection.close();
            }
            catch (Exception exception)
            {
                exception.printStackTrace();
                System.exit(1);
            }
        }
    }
}

What the problem of me? can someone who can solve this problem guide me to
the right path
thank you..