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](http://stackoverflow.com/questions/2839321/java-connectivity-with-mysql/2840358#2840358). — BalusC, Oct 16 '11 at 16:38

score 1 · Accepted Answer · answered Oct 16 '11 at 16:38

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 '11 at 16:38

Nivas

18,126
4
62
76

score 0 · Answer 2 · answered Oct 16 '11 at 17:35

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 '11 at 17:35

satu

1

Connecting java and mysql

2 Answers2