private void btnQuery_Click(object sender, EventArgs e)
{
string startNumber = txtStartNumber.Text;
string count = txtEndNumber.Text;
Student[] student = ScoreQuerier.GetClassmatesGPA(startNumber, Convert.ToUInt32(count));
//Sql Server
OleDbConnection con = new OleDbConnection(@"Provider=SQLOLEDB;server=DESKTOP-OC99H24\SQLEXPRESS;Trusted_Connection=yes;Database=CS");
con.Open();
OleDbCommand com = new OleDbCommand();
com.Connection = con;
foreach (Student stu in student)
{
string sql = string.Format("INSERT INTO CS(Name, GPA) VALUES('{0}', {1})", stu.Name, stu.GPA);
com.CommandText = sql;
com.ExecuteNonQuery();
}
con.Close();
}
//获取成绩
/// <summary>
/// 学生类的获取成绩方法，将自动从查询成绩的网页上获取成绩
/// </summary>
/// <param name="schoolYear">查询指定学年的成绩</param>
/// <param name="schoolTerm">查询指定学期的成绩</param>
/// <returns>返回是否成功获取到成绩</returns>
public bool GetSubjectScore(string schoolYear, SchoolTermOptions schoolTerm, string queryPurpose, string queryType)
{
return(ScoreQuerier.QueryStudentScore(this, schoolYear, schoolTerm, queryPurpose, queryType));
}
