Java Retrieve fetch Show data from SQL Server Database (JDBC)

Statement s = connect.createStatement();

String sql = "SELECT * FROM  customer ORDER BY CustomerID ASC";

ResultSet rec = s.executeQuery(sql);

while((rec!=null) && (rec.next()))
{
	System.out.print(rec.getString("CustomerID"));
}

package com.java.myapp;

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

public class MyClass {

	public static void main(String[] args) {
		
		Connection connect = null;
		Statement s = null;
		
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			connect =  DriverManager.getConnection("" +
			"jdbc:sqlserver://localhost\\SQL2008;databaseName=mydatabase;user=sa;password=");
			
			s = connect.createStatement();
			
			String sql = "SELECT * FROM  customer ORDER BY CustomerID ASC";
			
			ResultSet rec = s.executeQuery(sql);
			
			while((rec!=null) && (rec.next()))
            {
                System.out.print(rec.getString("CustomerID"));
                System.out.print(" - ");
                System.out.print(rec.getString("Name"));
                System.out.print(" - ");
                System.out.print(rec.getString("Email"));
                System.out.print(" - ");
                System.out.print(rec.getString("CountryCode"));
                System.out.print(" - ");
                System.out.print(rec.getFloat("Budget"));
                System.out.print(" - ");
                System.out.print(rec.getFloat("Used"));
                System.out.println("");
            }
             
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		try {
			s.close();
			connect.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	
}