Accessing MySQL from NetBeans

[Mahi Rahman]

Hello!

I am trying to get conncetion to MySQL database using this simple java class.

 
package simpledbconnection;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 

public class DBConnection {
    
    public static void main(String[] args)
            throws SQLException, ClassNotFoundException {
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("Driver Loaded");
            
            Connection connection =       DriverManager.getConnection("jdbc:mysql://localhost:3306/MyNewDatabase");
            System.out.println("Database Connected"); 
            
            Statement statement = connection.createStatement();
            
            ResultSet resultSet = statement.executeQuery("select * from   counselors");
            
            while (resultSet.next())
                System.out.println(resultSet.getString("counselors_id") + "\t"
                + resultSet.getString("first_name") + "\t" + resultSet.getString("email"));
            
            connection.close();
    }
    
}
  

I have added the mysql driver to NetBeans IDE, but when I try to compile the file I get a ClassNotFound error (the file can't locate the mysqljdbc.jar). Can anybody please suggest me how to fix this? If I need to register the database specificaly for this program how to do it then?

Thanks in advace!

[Vyas]

Try importing it as a library or put it in the Netbeans tomcat/lib

[Jan Cumps]

You did not mention your Netbeans Version, but here is how it works in NetBeans 6:

Right click on your project -> Properties
Category Libraries
Compile tab
Add JAR / Folder.

Locate the driver jar and confirm.

Regards, Jan

[Mahi Rahman]

Hei Jan!

Great! I use NetBeans 5.5 and I found the steps you suggested is also applicable to this version. And, it's now working! Thanks a lot for your tips!

Mahi.