欢迎来到unity学习、unity培训、unity企业培训教育专区,这里有很多U3D资源、U3D培训视频、U3D教程、U3D常见问题、U3D项目源码,我们致力于打造业内unity3d培训、学习第一品牌。
首先在引入命名空间:
using System.Data;
using System.Date.Sqlclient;
using System.Collections;
然后建立类方法:
ArrayList list=new ArrayList();
public ArrayList Show(){
Sqlconnection con=new Sqlconnection("server=.;database=class;Trusted_connection=SSPI");
con.Open();
string sql = "select S.id,S.name,G.score from student as S left join grade as G on S.id=G.sid";
SqlCommand com = new SqlCommand(sql, con);
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Student s1 = new Student();
s1.Id = (int)reader.GetValue(0);
Student s2 = new Student();
s2.Name = (string)reader.GetValue(1);
Grade g = new Grade();
g.Score = (int)reader.GetValue(2);
list.Add(s1);
list.Add(s2);
list.Add(g);
}
reader.Close();
con.Close();
return list;
}
再建立一个迭代器类方法:
public void Show() {
ArrayList list = new Grade().Show();
IEnumerator it = list.GetEnumerator();
while (it.MoveNext())
{
Student s1 = (Student)it.Current;
it.MoveNext();
Student s2 = (Student)it.Current;
it.MoveNext();
Grade g = (Grade)it.Current;
Console.WriteLine(s1.Id+" "+s2.Name + " " + g.Score);
}
}
最后引用迭代器的类方法就可以了:
case "4":
Show();
break;