How to connect Java to Mysql?

Question

I got these errors for my Java program. I have already put the mysql-connector-java-5.1.14-bin.jar inside my classpath. How to solve this?

HSystemRDB.java:144: package com.mysql.jdbc does not exist
    Driver driver = new com.mysql.jdbc.Driver();
                                      ^
HTestClassRDB.java:99: package com.mysql.jdbc does not exist
        DriverManager.registerDriver(new com.mysql.jdbc.Driver());

The code:

    String url = "jdbc:mysql://wire:3306/h?user="+pSystemRDB.USERNAME+"&password="+pSystemRDB.PASSWORD;
    Connection con;
    Statement stmt;
    String query1 = "Delete from dbase";
    String query2 = "Delete from id";


    try {
        DriverManager.registerDriver(new com.mysql.jdbc.Driver());
    } catch (Exception e) {
        System.out.println("Class Not Found Exception:");
        System.out.println(e.getMessage());
    }

Well, it's probably not lying. Are you sure the mysql connector is in your classpath? Have you read this? http://dev.mysql.com/doc/refman/5.1/en/connector-j-usagenotes-basic.html#connector-j-usagenotes-connect-drivermanager — Robert, Dec 08 '10 at 08:22

score 7 · Answer 1 · answered Dec 08 '10 at 08:19

7

You need to add MySQL Driver in your classpath for that , and import appropriate classes your source .

Please refer to this basic tutorial , article

answered Dec 08 '10 at 08:19

jmj

237,923
42
401
438

Already added the mysql *.jar to my classpath. Am I missing something inside the code? – karikari Dec 08 '10 at 08:20

score 7 · Accepted Answer · answered Dec 08 '10 at 08:21

You need to download the mysql package from: here and place it inside the library, i'll edit the excact steps in a few min

this is the correct syntax to connect to a database:

try
{
  // create a java mysql database connection
  String myDriver = "org.gjt.mm.mysql.Driver";
  String myUrl = "jdbc:mysql://localhost/test";
  Class.forName(myDriver);
  Connection conn = DriverManager.getConnection(myUrl, "root", "");

  // your prepstatements goes here...

  conn.close();
}
catch (Exception e)
{
  System.err.println("Got an exception! ");
  System.err.println(e.getMessage());
}

Hope this helps

score 0 · Answer 3 · edited Oct 20 '12 at 12:01

0

It seems that you do not have jar file to connect database. You can download mysql-connector-java-3.1.12.jar.

Please, download it and place it in the lib folder of your web application. This should fix your problem.

If you have any other problem, you can refer this tutorial for steps to connect MySQL using JDBC

edited Oct 20 '12 at 12:01

Littm

4,923
4
30
38

answered Jun 01 '12 at 07:17

Jwalant

1

How to connect Java to Mysql?

3 Answers3

Linked

Related