How to connect NetBeans to MySQL database?

Question

I have just installed NetBeans 7.0 and I am a newbie in NetBeans' world. can any one tell me how to connect my application to MySQl / Postgres ? I work on Windows XP.

Solution 1

In the Services window you can right click on the Databases tab and select New Connection.

Select MySQL(Connector/J Driver) from the drop down list. The driver file should be listed in the window. If not, you can download the file, then click add and select it from your hard drive.

Finally enter your database details such as servername, username and password and click finish.

Solution 2

If you meant you want to use IDE's GUI tool then

• windows > services >database > driver
• Get the driver jar
• install the jar
• right click on driver installed > connect using > and then provide the information

Or otherwise use JDBC

Solution 3

One way to connect to such databases is to use a JDBC (Java Database Connectivity) driver. You can find more about JDBC at the Oracle FAQ.

Solution 4

click on window and then select services

then click on databases and select new connection

select driver which you want

then click finish

if you want to check the connection is successful or not

 try
    {
         con=DriverManager.getConnection("jdbc:mysql://localhost/student_result","root","");


JOptionPane.showMessageDialog(null,"connected with "+con.toString());


    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null,"not connect to server and message is"+e.getMessage());
    }

View more solutions

Comments

[Tim Sparg]

Is your question about using the built in NetBeans SQL editor to access your database, or are you asking how to connect the program that you've written to a MySQL database?

[Ravi Parekh]

@jigar u don't need to install jar. just select connetor/J dirver

[jmj]

@ravi I meant installation by that

[Amit]

@ravi and @Jigar : I have done all that... but still Class.forName() is throwing ClassNotFoundException. When I tried System.setProperty("jdbc.driver","driver info"); still it is not working.....

[Ravi Parekh]

buddy u have to attache mysql.jar to run your project library. attache with naetbean is just like workbench,querybrowser, toad etc.

[jmj]

You need to provide driver jar into classpath