creating database from sql command line and using it in Java jdbc code

Question

I want to create my database using pure sql code from sql command line sql command line imageand want to connect to the database from java code(jdbc). But while doing so I am facing problems- here is what I have tried: I have set the path of the driver - ["mysql-connector-java-5.1.39-bin"-a jar file ]- in path variable as well as ,on some suggestions from internet, I added this jar file to the [C:\Program Files\Java\jdk1.8.0\jre\bin] folder. but when I run my program from command prompt it shows an Exception - the image - message from command prompt. I have created a user for the databse from sql command prompt too. here is my java code -

  import java.sql.*;

  public class JDBCDemo
{
  public static void main(String... args)
 {
   try(Connection conn = DriverManager.getConnection(
    "jdbc:mysql//localhost:3306/studentdb?useSSL=false","amir","amir5");
    // step 2 . allocate a statement object in the connection 

    Statement stmt = conn.createStatement();
    )   {
       //step 3. execute  a SQL select query, the query result 
         String strSelect = "select * from student;";
         System.out.println("The sql query is "+ strSelect);
         System.out.println();
         ResultSet rset = stmt.executeQuery(strSelect);
         System.out.println("the records are selected");
         int rowCount =0;
         while(rset.next())
         {
             String name = rset.getString("name");
             String roll = rset.getString("roll_num");
             int id = rset.getInt("id");
             System.out.println(name+", "+roll+", "+id);
             ++rowCount;
         }
         System.out.println(rowCount);
        }
         catch(SQLException e)
         {
             e.printStackTrace();
         } 

   }    
}

how can I get rid of this problem?

Gord Thompson · Accepted Answer · 2016-07-26 16:11:25Z

0

Given the error message

java.sql.SQLException: No suitable driver found for jdbc:mysql//localhost:3306/studentdb?useSSL=false

your connection string is missing the colon after "mysql". It should be

jdbc:mysql://localhost ...

answered Jul 26, 2016 at 16:11

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

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

1 Comment

user404 Over a year ago

please tell me the steps in the form of an algorithm,if possible. right from •installing mysql (mention the link , where to download from , if possible), to •writing jdbc program. that may help me understand where I have been doing wrong!!

Tamil · Accepted Answer · 2016-07-27 05:29:14Z

0

You should use Class.forName("com.mysql.jdbc.Driver");

Refer tutorial here

Note: Download the mysql-connector-java-5.1.23-bin.jar here. It is not mentioned in that tutorial. Then set the class path where you download it.

import java.sql.*;  
class MysqlCon{  
public static void main(String args[]){  
try{  
Class.forName("com.mysql.jdbc.Driver");  

Connection con=DriverManager.getConnection(  
"jdbc:mysql://localhost:3306/sonoo","root","root");  

//here sonoo is database name, root is username and password  

Statement stmt=con.createStatement();  

ResultSet rs=stmt.executeQuery("select * from emp");  

while(rs.next())  
System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getString(3));  

con.close();  

}catch(Exception e){ System.out.println(e);}  

}  
}

edited Jul 27, 2016 at 5:29

answered Jul 26, 2016 at 13:06

Tamil

1,44811 silver badges25 bronze badges

8 Comments

user404 Over a year ago

it doesn't work- command prompt message - java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Tamil Over a year ago

@Amir Hasan : Have you referred the tutorial as i mentioned?

user404 Over a year ago

yes, I did. I had copied the tutorial in fact the database name too.

Tamil Over a year ago

Download the jar file here java2s.com/Code/Jar/m/Downloadmysqlconnectorjava5123binjar.htm. Then set the class path as mentioned in the tutorial and try it.

Tamil Over a year ago

@Amir Hasan : Are you using Windows or Linux OS?

|

Bhimreddy · Accepted Answer · 2016-07-27 06:23:45Z

0

Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/studentdb","amir","amir5");

use this line it will work perfectly

answered Jul 27, 2016 at 6:23

Bhimreddy

412 bronze badges

1 Comment

user404 Over a year ago

please tell me the steps in the form of an algorithm,if possible. right from •installing mysql (mention the link , where to download from , if possible), to •writing jdbc program. that may help me understand where I have been doing wrong!!

user404 · Accepted Answer · 2016-07-27 19:44:43Z

0

do not look here and there! just set up your mysql command line and install netbeans . netbeans has inbuilt Drivers. create a database in mysql command line then create a project in netbeans and double click on the library folder and select add library, a screen will pop up , scroll down it and select mysql odbc driver and you are done!!write your code and execute queries.

answered Jul 27, 2016 at 19:44

user404

1151 silver badge10 bronze badges

Collectives™ on Stack Overflow

creating database from sql command line and using it in Java jdbc code

4 Answers 4

1 Comment

8 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

8 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related