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.

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? — Tim Sparg
– Tim Sparg, Commented May 22, 2011 at 10:11

Vincent Ramdhanie · Accepted Answer · 2011-05-21 11:59:45Z

11

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. Driver Information

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

answered May 21, 2011 at 11:59

Vincent Ramdhanie

103k23 gold badges143 silver badges196 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel · Accepted Answer · 2011-05-21 11:16:00Z

2

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.

answered May 21, 2011 at 11:16

Daniel

85510 silver badges21 bronze badges

Comments

Jigar Joshi · Accepted Answer · 2011-05-21 11:56:02Z

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

edited May 21, 2011 at 11:56

answered May 21, 2011 at 11:14

Jigar Joshi

241k42 gold badges409 silver badges446 bronze badges

5 Comments

Ravi Parekh Over a year ago

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

Jigar Joshi Over a year ago

@ravi I meant installation by that

Amit Over a year ago

@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 Over a year ago

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

Jigar Joshi Over a year ago

You need to provide driver jar into classpath

Adiii · Accepted Answer · 2015-07-18 17:38:16Z

1

click on window and then select services

enter image description here

then click on databases and select new connection enter image description here

select driver which you want

enter image description here

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());
    }

answered Jul 18, 2015 at 17:38

Adiii

61.1k10 gold badges180 silver badges174 bronze badges

Comments

Ravi Parekh · Accepted Answer · 2011-05-21 12:03:10Z

0

see mysql .jar for u project properties if u waant to run or for netbeans shown by @Vincent Ramdhanie enter image description here

answered May 21, 2011 at 12:03

Ravi Parekh

5,69010 gold badges49 silver badges59 bronze badges

Comments

Sudhir · Accepted Answer · 2016-08-20 12:00:03Z

0

Follow the steps:-

1.Create a new application 2.In projects section of netbeans right click on libraries 3.Check the picture(i)Libraries java mysql connector Thus you successfully setup the connection with mysql.

answered Aug 20, 2016 at 12:00

Sudhir

1

Collectives™ on Stack Overflow

How to connect NetBeans to MySQL database?

6 Answers 6

Comments

Comments

5 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

5 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related