how to connect java to mysql?

hello friend this is ranvir,
i'm working on simple java programm to connect mysql database, but showing error after compiled,
this is my programm....

MysqlConnect.java
###################

Code:

---

import java.sql.*;

public class MysqlConnect{
  public static void main(String[] args) {
    System.out.println("MySQL Connect Example.");
    Connection conn = null;
    String url = "jdbc:mysql://localhost:3306/";
    String dbName = "nik";
    String driver = "com.mysql.jdbc.Driver";
    String userName = "root";
    String password = "ranvir";
    try {
      Class.forName(driver).newInstance();
      conn = DriverManager.getConnection(url+dbName,userName,password);
      System.out.println("Connected to the database");
      conn.close();
      System.out.println("Disconnected from database");
    } catch (Exception e) {
    }
  }
}

---

after compilation showing some error
################################
error(when execute)
----------------
Database creation example!
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java: 202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 07)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 48)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at jdbc1.CreateDatabase.main(CreateDatabase.java:11)
BUILD SUCCESSFUL (total time: 1 second),

please suggest me ,what is possiblity of error,how to solve it?

Please use code tags, [CODE][/CODE], when posting codes

I am not sure if this is the code you are using but your password became pa ssword in getConnection method.

Quote:

---

String password = "ranvir";
...
conn = DriverManager.getConnection(url+dbName,userName,pa ssword);

---

Also, your try..catch statement does not print the error( e.printStackTrace(); ).

Quote:

---

try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,userName,pa ssword);
System.out.println("Connected to the database");
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
}

---

and yet you were able to tell us the problem base on printed stack trace.

It will be hard for us to know the actual/real problem if you give us code with different output.

About the error, did you already add the library of MySql on your class path?

You need driver for connecting a java program to MySQL.
The codes wont work if you dont have Jconnector installed...
I've explained the procedure to connect java pgms to mysql on a post in my blog.


http://javaxcoder.co.cc