完成多表的查询在控制台输出
public ArrayList show() {
ArrayList list = new ArrayList();
SqlConnection con = He.Connert();
con.Open();
string sql = "select equment.name,equment.price,grade.score from equment inner join grade on equment.id=grade.sid ";
SqlCommand sc = new SqlCommand(sql, con);
SqlDataReader reader=sc.ExecuteReader ();
while (reader.Read()) {
equment e = new equment();
e.Name = (string)reader.GetValue(0);
equment e2 = new equment();
e2.Price = (int)reader.GetValue(1);
Grade g = new Grade();
g.Scroce = (int)reader.GetValue(2);
list.Add(e);
list.Add(e2);
list.Add(g);
}
He.Close(con,reader );
return list;
}
public void student() {
ArrayList list = new Grade().show();
IEnumerator it = list.GetEnumerator();
while (it.MoveNext())
{
equment e = (equment)it.Current;
it.MoveNext();
equment e2 = (equment)it.Current;
it.MoveNext();
Grade g = (Grade)it.Current;
Console.WriteLine(e.Name + " " + e2.Price + " " + g.Scroce);
}
欢迎来到 unity学习 、 unity培训、unity企业培训 教育专区,这里有很多 U3D资源、U3D培训视频U3D教 程、 U3D常见问题 、 U3D项目源码 ,我们致力于打造业内 unity3d培训 、学习第一品牌。