当前位置:Gxlcms > 数据库问题 > 将Sql查询语句获取的数据插入到List列表里面

将Sql查询语句获取的数据插入到List列表里面

时间:2021-07-01 10:21:17 帮助过:128人阅读

我想查询一个用户表的信息,该用户有姓名,密码,信息三列 //1.定义一个用户类型的List数组,userInfo类的代码在下方 List<userInfo> userInfo = new List<userInfo>(); //2.我们要读取查询语句的数据,并且保存了。这里我们将使用IDataReader语句 //数据库类的实例,类的代码在下方 DB db = new DB(); //解析方法 using(IDataReader read=db.read("select * from userInfo")) { while (read.Read()) { userInfo a = new userInfo(); a.user_Name = read[0].ToString(); a.user_Passwd = read[1].ToString(); a.user_region = read[2].ToString(); userInfo.Add(a); } }

 

userInfo类的代码:

  1. <span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> userInfo
  2. {
  3. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">string</span> user_Name{<span style="color: #0000ff">get</span>;<span style="color: #0000ff">set</span><span style="color: #000000">;}
  4. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">string</span> user_Passwd {<span style="color: #0000ff">get</span>;<span style="color: #0000ff">set</span><span style="color: #000000">;}
  5. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">string</span> user_region{<span style="color: #0000ff">get</span>;<span style="color: #0000ff">set</span><span style="color: #000000">;}
  6. }</span>

 

DB类的代码:

  1. <span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> DB
  2. {
  3. </span><span style="color: #008000">//</span><span style="color: #008000">数据库操作
  4. </span><span style="color: #008000">//</span><span style="color: #008000">1.连接数据库</span>
  5. <span style="color: #0000ff">public</span><span style="color: #000000"> SqlConnection connect()
  6. {
  7. </span><span style="color: #0000ff">string</span> rode = <span style="color: #800000">@"</span><span style="color: #800000">Data Source=KTY;Integrated Security=SSPI;Initial Catalog=shuyunquan</span><span style="color: #800000">"</span><span style="color: #000000">;
  8. SqlConnection con </span>= <span style="color: #0000ff">new</span><span style="color: #000000"> SqlConnection(rode);
  9. con.Open();
  10. </span><span style="color: #0000ff">return</span><span style="color: #000000"> con;
  11. }
  12. </span><span style="color: #008000">//</span><span style="color: #008000">执行语句的数据库方法</span>
  13. <span style="color: #0000ff">public</span> SqlCommand command(<span style="color: #0000ff">string</span><span style="color: #000000"> sql)
  14. {
  15. SqlCommand cmd </span>= <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand(sql, connect());
  16. </span><span style="color: #0000ff">return</span><span style="color: #000000"> cmd;
  17. }
  18. </span><span style="color: #008000">//</span><span style="color: #008000">行数影响的方法</span>
  19. <span style="color: #0000ff">public</span> <span style="color: #0000ff">int</span> Execute(<span style="color: #0000ff">string</span><span style="color: #000000"> sql)
  20. {
  21. </span><span style="color: #0000ff">return</span><span style="color: #000000"> command(sql).ExecuteNonQuery();
  22. }
  23. </span><span style="color: #008000">//</span><span style="color: #008000">返回查询结果的方法</span>
  24. <span style="color: #0000ff">public</span> SqlDataReader read(<span style="color: #0000ff">string</span><span style="color: #000000"> sql)
  25. {
  26. </span><span style="color: #0000ff">return</span><span style="color: #000000"> command(sql).ExecuteReader();
  27. }
  28. }</span>

 

将Sql查询语句获取的数据插入到List列表里面

标签:span   连接数据库   并且   rod   ade   使用   方法   结果   定义   

人气教程排行