CODEWITHSUNDEEP
javamysqlpostgresqlnetbeansjdbc
Amit
Amit

Reputation: 13364

How to connect NetBeans to MySQL database?

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.

Upvotes: 7

Views: 112648

Answers (6)

Sudhir
Sudhir

Reputation: 1

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.

Upvotes: 0

Adiii
Adiii

Reputation: 59896

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

Upvotes: 1

Ravi Parekh
Ravi Parekh

Reputation: 5594

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

Upvotes: 0

Vincent Ramdhanie
Vincent Ramdhanie

Reputation: 103135

In the Services window you can right click on the Databases tab and select New Connection. 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. Database Details

Upvotes: 11

Jigar Joshi
Jigar Joshi

Reputation: 240860

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

Upvotes: 2

Daniel
Daniel

Reputation: 855

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.

Upvotes: 2

Related Questions