1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11
12/**//// <summary>
13/// LeibieOperater 的摘要说明
14/// </summary>
15public class LeibieOperater
16...{
17    private SqlConnection con = null;
18    private SqlCommand cmd = null;
19    public LeibieOperater()
20    ...{
21        //
22        // TODO: 在此处添加构造函数逻辑
23        //
24        this.con = ConDB.getConnection();//在构造函数中连接数据库！
25    }
26    public Leibie getbyid(int aid)
27    ...{
28        con.Open();
29        cmd = new SqlCommand("select * from leibietable where id=" + aid, con);
30        SqlDataReader dr = cmd.ExecuteReader();
31        Leibie lb = null;
32        while (dr.Read())
33        ...{
34            lb = new Leibie(dr);
35        }
36        con.Close();
37        return lb;
38    }
39}
40