Click here to Skip to main content
15,885,757 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i am trying database connectivity to mysql from java in eclipse ide.getting the following errors

Connecting to database...
Creating statement...
com.mysql.jdbc.JDBC4ResultSet@c487600
Goodbye!

following is the code
Java
package hello;
import java.sql.*;

class JDBCExample {
   // JDBC driver name and database URL
     
   static final String DB_URL = "jdbc:mysql://localhost/student";

   //  Database credentials
   static final String USER = "gargi";
   static final String PASS = "gargi";
   
    public static void main(String[] args) {
       Connection conn = null;
       Statement stmt = null;
       try{
          //STEP 2: Register JDBC driver
          Class.forName("com.mysql.jdbc.Driver");
    
          //STEP 3: Open a connection
          System.out.println("Connecting to database...");
          conn = DriverManager.getConnection(DB_URL,USER,PASS);
    
          //STEP 4: Execute a query to create statment with
          // required arguments for RS example.
          System.out.println("Creating statement...");
          stmt = conn.createStatement();
          String sql;
          sql = "SELECT count(id) FROM st";
          ResultSet rs = stmt.executeQuery(sql);
                
         System.out.println(rs);     
    
          //STEP 8: Clean-up environment
          rs.close();
          stmt.close();
          conn.close();
       }catch(SQLException se){
          //Handle errors for JDBC
          se.printStackTrace();
       }catch(Exception e){
          //Handle errors for Class.forName
          e.printStackTrace();
       }finally{
          //finally block used to close resources
          try{
             if(stmt!=null)
                stmt.close();
          }catch(SQLException se2){
          }// nothing we can do
          try{
             if(conn!=null)
                conn.close();
          }catch(SQLException se){
             se.printStackTrace();
          }//end finally try
       }//end try
       System.out.println("Goodbye!");
    }//end main
}//end JDBCExample




following is the work done:
1.added jar file in build path
2.created user in mysql command client

help required asap.its my final year project.
Posted
Updated 1-Feb-14 21:52pm
v2
Comments
Peter Leow 2-Feb-14 2:40am    
Try adding the port number 3306 to your DB_URL:
static final String DB_URL = "jdbc:mysql://localhost:3306/student";
thatraja 3-Feb-14 5:15am    
You forgot to include error messages

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900