复习

来源：互联网发布：中银淘宝卡可以提额吗编辑：程序博客网时间：2024/04/29 15:11

完成多表的查询在控制台输出

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培训、学习第一品牌。

0 0