import java.sql.*;
public class StudentsTest {
	   public static void main(String arg[])  {
					Connection conn;
	   	 try 	 {
	   	 	 			 String url = "jdbc:mysql://localhost/college";
               Class.forName ("com.mysql.jdbc.Driver");
               conn = DriverManager.getConnection (url, "root", "");
               Statement stmt = conn.createStatement();
               String sql = "Select fname, lname, course from students";
               ResultSet  rs = stmt.executeQuery(sql);
               while(rs.next())
               {
               			String ln, fn, c;

               			ln = rs.getString("lname");
               			fn = rs.getString("fname");
               			c = rs.getString("course");

               			System.out.println("Name : " + fn + " " + ln + " \nCourse: "
               				+ c + "\n");
               }
               conn.close();
	   	 }catch (Exception sqx)
	   	 {
               System.out.println ("Error connecting..." );
               sqx.printStackTrace();
	   	 }
	   }
}