import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;



public class ConnectionMySQL {
	public static void main (String[] args){

		try{

			Connection con = DriverManager.getConnection("jdbc:mysql://localhost/db_student","root", "");
		//System.out.println("Connected");
			String query = "SELECT * FROM tbl_student";
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(query);
			while(rs.next()){

				System.out.println("Student ID:"+rs.getString("student_id")+"Student Name:"+rs.getString("student_name")+"Couse:"+rs.getString("course")+"Address:"+rs.getString("address")+"Gender:"+rs.getString("gender"));
			}
		}catch (Exception e){
			System.err.println(e);
	}

	}
}