Using mysql from Xampp for java jdbc program

Question

I have Xampp installed on my pc with mysql database. now i wish to use this mysql database for my java JDBC program. For that i have writen following program.

package mysqltype4driverdemo;

import java.sql.*;
import java.util.*;


public class MysqlType4DriverDemo {

    public static void main(String[] args)throws SQLException {
        String url="jdbc:mysql://localhost:3306/mysql";
        Properties prop=new Properties();
        prop.setProperty("user","root");
        prop.setProperty("password","");
        Driver d=new com.mysql.jdbc.Driver();
        Connection con = d.connect(url,prop);
        if(con==null)   {
            System.out.println("connection failed");
            return;
        }
        DatabaseMetaData dm =con.getMetaData();
        String dbversion=dm.getDatabaseProductVersion();
        String dbname=dm.getDatabaseProductName();
        System.out.println("name:"+dbname);
        System.out.println("version:"+dbversion);

    }
}

but it says "package com.mysql.jdbc" does not exists. P.S. : i am using netbeans 7.2.x IDE on windows XP platform

Do you have that package available to the compiler and on your classpath? The answer must be no. — thatidiotguy
– thatidiotguy, Commented Nov 28, 2012 at 17:53

RobertB · Accepted Answer · 2012-11-29 20:45:29Z

6

It appears that you might have tried putting the library on the global CLASSPATH. For Netbeans projects, that's not quite right. You need to add the appropriate library(ies) to the project using Netbeans's library facility.

Right-click on the project's root node in the Projects tab.
In the pop-up context menu, click on Properties (on the bottom of the menu).
Click on Libraries under Categories:. You should see the following screen:
Click on the Add Library... button.
Under Global Libraries click on MySQL JDBC Driver and then click the Add Library button.
Click on OK.

You should be good to go.

If you need a specific version of the driver, you can download it, and then after clicking on Add Library... you can click on Create... to add the downloaded version to your library repository. You'd then remove the default JDBC Driver from the project, and add the library containing the specific version.

I tried this out myself using your code and a newly-created project. No additional imports needed, and the default driver included with the Netbeans distro should be good enough unless you need a specific version for your project.

edited Nov 29, 2012 at 20:45

answered Nov 29, 2012 at 20:20

RobertB

4,6221 gold badge33 silver badges29 bronze badges

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

1 Comment

dhpratik Over a year ago

thanks @RobertB it worked well. i was unaware of this things in ide. thanks for detail explaination

Robert H · Accepted Answer · 2012-11-29 20:22:24Z

1

You need to download the JDBC driver for mysql from here.

Once you download it, add the jar to your classpath and you should be good to go.

edited Nov 29, 2012 at 20:22

answered Nov 29, 2012 at 20:15

Robert H

11.7k19 gold badges72 silver badges112 bronze badges

1 Comment

RobertB Over a year ago

Netbeans should already have the MySQL driver. It is included (I believe) in the Database module that is part of the base IDE. It needs to be on the project's classpath, using the library facility.

Vaibhav Joshi · Accepted Answer · 2013-10-31 02:41:31Z

1

Alternatively, once you have downloaded the driver, you can paste it in you java installation at ...jre\lib\ext\

Then it would be available for all your projects with the default JRE system library which you can verify when you create a new project.

answered Oct 31, 2013 at 2:41

Vaibhav Joshi

992 bronze badges

Collectives™ on Stack Overflow

Using mysql from Xampp for java jdbc program

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related