Can't Show database on XAMPP-> mysql to java

Question

I am using XAMPP->Mysql to create database and using Netbeans IDE 8.1 fro create java

My XAMPP Control Panel pic

Student database pic

My Code

//default package
//1st step
import java.sql.*;

public class DemoJDBC {

    public static void main(String[] args) {
        try{
          String Query = "Select * from Student";
          //2nd step  
            Class.forName("com.mysql.jdbc.Driver");
          //3rd step
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost/student", "root", "0");
          //4th step
            Statement st = con.createStatement();
          //5th step
            ResultSet rs = st.executeQuery(Query);
            rs.next();
            String name = rs.getString("sname");
            System.out.println(name);

          //6th step
          con.close();
        }
        catch (Exception e){

        }
    }

}

Why it didn't show output name ? It just show "BUILD SUCCESSFUL (total time: 1 second)" in netbeans output

"BUILD SUCCESSFUL" indicates you built the code, but maybe you didn't run it? — Mark Rotteveel
– Mark Rotteveel, Commented Nov 25, 2016 at 8:38

Young Emil · Accepted Answer · 2016-11-25 04:14:04Z

1

You need to loop through the ResultSet to get the tuples or rows. So while looping you retrieve whatever data or field you want to get. try:

    public static void main(String[] args) {
        try {
            String Query = "Select * from Student";
            //2nd step  
            Class.forName("com.mysql.jdbc.Driver");
            //3rd step
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost/student", "root", "0");
            //4th step
            Statement st = con.createStatement();
            //5th step
            ResultSet rs = st.executeQuery(Query);

            //Loop to retrieve tuple(s) from the ResultSet rs
            while (rs.next()) {
                String name = rs.getString("sname");
                System.out.println(name);
            }

            //6th step
            con.close();
        } catch (Exception e) {

        }
    }

NOTE if by default you did not change the password of the root user it is just the empty String (thus "" and not "0"). Other than that you know what you are doing.

edited Nov 25, 2016 at 4:14

answered Nov 25, 2016 at 4:05

Young Emil

2,2763 gold badges29 silver badges39 bronze badges

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

9 Comments

deta utama Over a year ago

It's still show run: BUILD SUCCESSFUL (total time: 1 second)

Young Emil Over a year ago

take note of the NOTE part of my answer, if it would be helpful.

Young Emil Over a year ago

Are you running or you are just building the project? If you are just building, you can run using SHIFT+F6 to run this file only.

deta utama Over a year ago

Should I change jdbc:mysql://localhost/student to jdbc:mysql://localhost:8080/student ?

Young Emil Over a year ago

Mysql is running on port 3306 according to your xampp so if anything, you rather change it to 3306. I hope you have also added the mysql java driver jar file to libraries.

|

N00b Pr0grammer · Accepted Answer · 2016-11-25 08:55:33Z

0

Along with the correction of your code to loop through the ResultSet, you also need to correct your connection string as shown below:

Considering that your MySQL is running on the default MySQL port 3306 (which I see that you already are), the connection string needs to be updated.

Also saw that password for the user root is '0', is it really the password?

public static void main(String[] args) {
    try {
        String query = "SELECT * FROM Student";
        Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student", "root", "0");
        Statement st = con.createStatement();
        ResultSet rs = st.executeQuery(query);

        //Loop to retrieve tuple(s) from the ResultSet rs
        while (rs.next()) {
            String name = rs.getString("sname");
            System.out.println(name);
        }
        con.close();
    } catch (Exception e) {
    }
}

Also ensure to have your MySQL Connector/J jar file to be present in your CLASSPATH to not to face any reference issues.

Hope that this helps!

edited Nov 25, 2016 at 8:55

answered Nov 25, 2016 at 6:31

N00b Pr0grammer

4,6676 gold badges36 silver badges49 bronze badges

2 Comments

deta utama Over a year ago

when I change to "jdbc:mysql://localhost:3360/student", "root", ""); , it's worked..!. Didn't it set by default port in MySQL ?

N00b Pr0grammer Over a year ago

It's by design, you need to mention the port number in your connection string

Collectives™ on Stack Overflow

Can't Show database on XAMPP-> mysql to java

2 Answers 2

9 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related