时间:2021-07-01 10:21:17 帮助过:128人阅读
userInfo类的代码:
- <span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> userInfo
- {
- </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">;}
- </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">;}
- </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">;}
- }</span>
DB类的代码:
- <span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> DB
- {
- </span><span style="color: #008000">//</span><span style="color: #008000">数据库操作
- </span><span style="color: #008000">//</span><span style="color: #008000">1.连接数据库</span>
- <span style="color: #0000ff">public</span><span style="color: #000000"> SqlConnection connect()
- {
- </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">;
- SqlConnection con </span>= <span style="color: #0000ff">new</span><span style="color: #000000"> SqlConnection(rode);
- con.Open();
- </span><span style="color: #0000ff">return</span><span style="color: #000000"> con;
- }
- </span><span style="color: #008000">//</span><span style="color: #008000">执行语句的数据库方法</span>
- <span style="color: #0000ff">public</span> SqlCommand command(<span style="color: #0000ff">string</span><span style="color: #000000"> sql)
- {
- SqlCommand cmd </span>= <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand(sql, connect());
- </span><span style="color: #0000ff">return</span><span style="color: #000000"> cmd;
- }
- </span><span style="color: #008000">//</span><span style="color: #008000">行数影响的方法</span>
- <span style="color: #0000ff">public</span> <span style="color: #0000ff">int</span> Execute(<span style="color: #0000ff">string</span><span style="color: #000000"> sql)
- {
- </span><span style="color: #0000ff">return</span><span style="color: #000000"> command(sql).ExecuteNonQuery();
- }
- </span><span style="color: #008000">//</span><span style="color: #008000">返回查询结果的方法</span>
- <span style="color: #0000ff">public</span> SqlDataReader read(<span style="color: #0000ff">string</span><span style="color: #000000"> sql)
- {
- </span><span style="color: #0000ff">return</span><span style="color: #000000"> command(sql).ExecuteReader();
- }
- }</span>
将Sql查询语句获取的数据插入到List列表里面
标签:span 连接数据库 并且 rod ade 使用 方法 结果 定义