How to connect netbeans 6.8 to sql server 2008?

Hello...!!


First you have to install the setup of mysql by checking the boxes of your uses and also by fill username & password.


After then you have to make a java file for making connection between netbeans and mysql.
The code for connection is here.


import java.sql.*;


  public class connect{
    public Connection c() throws Exception
     {
       Class.forName("com.mysql.jdbc.Driver");
Connection connect=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "root", "toor");    
return connect;
  }
}

3306 is a port number, "root" is username, "toor" is password, mydb is the name of database created in mysql after installing the setup of mysql.

For connection, you also need a rar file that should added in the library of your project package. The rar file is attached here.


For any query, please welcome again.


Thank you.