Olá sou novo aqui, mas tenho uma dúvida com jdbc, criei um BD mysql fiz uma classe mas não me conecto ao BD; alguém poderia me dar uma dica?
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
public class DisplayAuthors {
//nome do drive JDBC e URL do banco de dados
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DATABASE_URL = "jdbc:mysql://localhost/books";
//carrega o apicativo
public static void main(String[] args) {
Connection connection = null;
Statement statement = null;
//conecta-se ao banco de dados books e oconsulta
try {
Class.forName( JDBC_DRIVER );//carrega a classe de driver do banco de dados
//estabelece conexão com o banco de dados
connection = DriverManager.getConnection( DATABASE_URL, "jhtp6", "jhtp6" );
//cria Statement para consultar banco de dados
statement = connection.createStatement();
//consulta o banco de dados
ResultSet resultSet = statement.executeQuery("SELECT authorID, firstName, lastName FROM authors");
//processa resultados da consulta
ResultSetMetaData metaData = resultSet.getMetaData();
int numberOfColumns = metaData.getColumnCount();
System.out.println("Authors Table of Books Database");
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);
}
catch (ClassNotFoundException classNotFoundException) {
classNotFoundException.printStackTrace();
System.exit(1);
}
finally{
try {
statement.close();
connection.close();
} catch (Exception exception) {
exception.printStackTrace();
System.exit(1);
}
}
}
}
//No console do Eclipse me retorna:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at DisplayAuthors.main(DisplayAuthors.java:21)