Connecting java and mysql

Question

I have used the following code to connect between java and mysql, but it does not find the JDBC_DRIVER. How can I solve this?

Here is the code:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;

/*This code connects to the mysql database*/
public class mysqlconn 
{
    public Connection con = null;
    public Statement statement= null;
    public String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    public String username = "root",password = "taskinn432175";
    static String dbname = "jdbc:mysql://localhost/shopkeeper";
    String sql="select * from shopkeeper";
    String dbtime;

    public  mysqlconn(String userd , String passd){
        this.password = passd;
        this.username= userd;
    }

    public void Connect() {
        try {
            Class.forName(JDBC_DRIVER);
            con = DriverManager.getConnection(dbname,username,password);
            statement= con.createStatement();
            System.out.println ("Database connection established");
            System.out.println("capturing from database");
            ResultSet rs=statement.executeQuery(sql);
            while (rs.next()) {
                dbtime = rs.getString(1);
                System.out.println(dbtime);
            }
        }
        catch (Exception e) {
            JOptionPane.showMessageDialog(null,"not connected"+e.getMessage());
        }
    }

    public static void main( String args[] )
    {
        mysqlconn conn=new mysqlconn("taskin","taskinn432175");
        conn.Connect();
    }
}

Just put it in the runtime classpath. Here's a mini tutorial. — BalusC
– BalusC, Commented Oct 16, 2011 at 16:38
Apparently is the same issue that: <stackoverflow.com/questions/2839391/…> Please check the answer. — Ernesto Campohermoso
– Ernesto Campohermoso, Commented Oct 16, 2011 at 20:13

Nivas · Accepted Answer · 2011-10-16 16:38:48Z

1

Make sure you have the JDBC drivers for mySql in your classpath.

One way to do this (for a simple test program like this):

java -cp .;path_to_jdbc_connector; mysqlconn

answered Oct 16, 2011 at 16:38

Nivas

18.4k4 gold badges65 silver badges76 bronze badges

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

Comments

satu · Accepted Answer · 2011-10-16 17:35:02Z

0

you must use mysql connector (.jar) file along with this program while running it, you can also resolve this problem by creating DSN for your application.

answered Oct 16, 2011 at 17:35

satu

1

Collectives™ on Stack Overflow

Connecting java and mysql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related