string pMysqlRanking = "SELECT `花名册`.`姓名`,`成绩表`.`学号`,`成绩表`.`语文`,`成绩表`.`数学`,`成绩表`.`英语` FROM `成绩表` LEFT JOIN `花名册` ON `成绩表`.`学号`=`花名册`.`学号`"+ "ORDER BY `成绩表`."+"`" +pMysqlSubject+"`" +"DESC";
注意:order by 后面加的变量不能用@变量,而是用""包起来
string pMysqlRanking = "SELECT `花名册`.`姓名`,`成绩表`.`学号`,`成绩表`.`语文`,`成绩表`.`数学`,`成绩表`.`英语` FROM `成绩表` LEFT JOIN `花名册` ON `成绩表`.`学号`=`花名册`.`学号`"+ "ORDER BY `成绩表`."+"`" +pMysqlSubject+"`" +"DESC";
注意:order by 后面加的变量不能用@变量,而是用""包起来