>>696
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Select {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
Connection cn = DriverManager.getConnection("jdbc:mysql://localhost/Exercise", "root", "pass");
Statement st = cn.createStatement();
System.out.println("Connected to MySQL Server.");
ResultSet rs = st.executeQuery("SELECT Course_ID, Student_ID, MAX(Grades) FROM Registration GROUP BY Course_ID");
int rows=0;
while (rs.next()) {
System.out.println("Course_ID = " + rs.getString(1) +", Student_ID = "+rs.getString(2)+", MAX(Grades) = "+rs.getString(3));
rows++;
}
System.out.println("" + rows + " rows were returned.");
rs.clearWarnings();
st.close();
cn.close();
System.out.println("Disconnected from MySQL Server.");
}
}