import java.sql.*;

public class QueryStuScore11_1
{
	public static void main(String[] args) throws Exception 
	{
		String user = "root";
		String password = "123456";
		String url = "jdbc:mysql://localhost:3306/test";
		Class.forName("com.mysql.jdbc.Driver");	//Java 6 д˾ʡԲд
		Connection conn = DriverManager.getConnection(url, user, password);
		Statement stat = conn.createStatement();
		String sql = "SELECT sname, score FROM s LEFT JOIN sc ON s.sn = sc.Sn LEFT JOIN c ON sc.cn = c.cn WHERE c.cname = 'Ӣ' AND sc.score >90";
		ResultSet rs = stat.executeQuery(sql);
		String stu_name;
		int english_score;
		while(rs.next()) 
		{
			stu_name = rs.getString("sname");
			english_score = rs.getInt("score");
			System.out.println(stu_name + "\t" + english_score);
		}
	}
}