selecting rows from a table

Hi
I have a table 'Address' with fields: name varchar(30) ,surname varchar(30),email varchar(30),phone varchar(30)
I am writing a program to select all records from the table.Can you please tell me what is going wrong

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

public class DBTest2 {

Connection m_Connection = null;
  Statement m_Statement = null;
  ResultSet m_ResultSet = null;

public Connection createConnection(){
	  String url = "jdbc:mysql://localhost:3306/";
	  String dbName = "abc";
	  String driver = "com.mysql.jdbc.Driver";
	  String userName = "root"; 
	  String password = "def";
	  
	  try {
		  Class.forName(driver).newInstance();
		  m_Connection = DriverManager.getConnection(url+dbName,userName,password);
		  System.out.println("Connected to the database");
		  return m_Connection;
		  } catch (Exception e) {
		  e.printStackTrace();
		  return null;
		  }
   }
  
  public void readTable() {
	   
 	      String read = "";
	   
 	      try {
 	      	//Create Statement object
 	     	 m_Connection = createConnection();
 	         m_Statement = m_Connection.createStatement();
 	        read = "Select * from Address";
 	        
 	        //Execute the query
 	         m_Statement.executeQuery(read);
 	        	        
 	        System.out.println("Name: " + "\t" + "Surname: " + "\t" + "Email ID: " + "Phone No: ");
 	       
 	       String f =   getString("name") ;
 	       String s =   getString("surname");
 	       String e =   getString("email");
               String p =   getString("phone");
               System.out.println(f + "\t\t" + s + "\t\t" + e + "\t\t" +p);
 	        
	      }
 	      catch (SQLException ex) {
 	        ex.printStackTrace();
 	        System.out.println(read);
 	        
 	      }
 	      finally {
	   
 	        try {   
 	               m_Statement.close();      }
 	        catch (SQLException ex) {
 	        ex.printStackTrace();
 	        }
 	      }
	     }

public static void main(String[] args) {
	    DBTest2 dbTable = new DBTest2();
	    dbTable.readTable();
  }
}

how about you tell us what is happening to make you think something is wrong. then maybe we can help you work out how to fix it.

I think when using getString for varchar field, I am going wrong.

The code above is missing the result set returned from execute Query?

getString is the exact method to call on a result set for a varchar

Thanks.I have modified the program with Result set.but no help.Please have a look.

you need to find examples of how to work with a result set, as it is designed to contain more than one row (think about it, a design that could only return 1 row isn't much use).
I'm not going to type it again as there are dozens of examples out there already.

Thank you Wendy.It got worked with