I tried connecting mysql database to java but i got the exception as "com.mysql.jdbc.Driver"

Question

Here is my code

try
{
    Class.forName("com.mysql.jdbc.Driver");
    Connection conn=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/Hotel_management"+"root"+"1234");
    Statement stmt=conn.createStatement();
    String query="insert into Records(Name, Address, Contact_no, Email, Nationality) values('"+name+"','"+add+"','"+con+"','"+e_mail+"','"+nat+"');";
    stmt.executeQuery(query);
}
catch(Exception e)
{
    JOptionPane.showMessageDialog(this, e.getMessage());
}

score 0 · Accepted Answer · answered Jul 14 '15 at 17:45

0

set class path to mysql jar file. Since com.mysql.jdbc.Driver class available in this jar file.

String DB_URL = "jdbc:mysql://localhost/Hotel_management";
String USER = "username";
String PASS = "password";
conn = DriverManager.getConnection(DB_URL,USER,PASS);

answered Jul 14 '15 at 17:45

SatyaTNV

4,119
3
14
31

Now i'm getting the exception as Access denied for user"@'localhost'(using password: NO) – Sam Jul 14 '15 at 17:59
use mysql correct username and password in your code. – SatyaTNV Jul 14 '15 at 18:00
I'm pretty sure it is correct. – Sam Jul 14 '15 at 18:05
Is mysql installed in your current system or you are accessing it remotely. – SatyaTNV Jul 14 '15 at 18:06
It's on the current system. – Sam Jul 14 '15 at 18:13
Are you able to logging in to Mysql CMD prompt with same username and password. – SatyaTNV Jul 14 '15 at 18:15
which parameters you are passing to getConnection(). post that line here – SatyaTNV Jul 14 '15 at 18:17
"jdbc:mysql://localhost:3306/Hotel_management","root","1901211304"); – Sam Jul 14 '15 at 18:19
GRANT ALL PRIVILEGES ON `*.*` TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION; use this cmd. – SatyaTNV Jul 14 '15 at 18:22
Ok now it's working fianlly. Thanx. – Sam Jul 14 '15 at 18:31
@Sam, welcome. Accept this answer then this will be useful to others. – SatyaTNV Jul 14 '15 at 18:32

I tried connecting mysql database to java but i got the exception as "com.mysql.jdbc.Driver"

1 Answers1