ado.net mysql类_ADO.NET 数据库操作类

//主要实现对Nation表的各种操作(增删改查)

public classNationDA

{private SqlConnection _conn; //连接对象

private SqlCommand _cmd; //命令对象

private SqlDataReader _dr; //读取器对象//构造方法来初始化连接对象 命令对象

publicNationDA()

{

_conn= DBConnect.Conn; //对连接对象进行初始化

_cmd = _conn.CreateCommand(); //对命令对象进行初始化

}//添加数据的方法

public bool Add(string code,stringname)

{

_cmd.CommandText= "insert into Nation values(@code,@name)";

_cmd.Parameters.AddWithValue("@code",code);

_cmd.Parameters.AddWithValue("@name",name);

_conn.Open();int n =_cmd.ExecuteNonQuery();

_conn.Close();if (n > 0)

{return true;

}else{return false;

}

}//查询所有数据的方法

public ListSelect()

{

_cmd.CommandText= "select * from Nation";

_conn.Open();

_dr=_cmd.ExecuteReader();//定义一个空的集合

List list = new List();if(_dr.HasRows)

{while(_dr.Read())

{//造一个Nation对象

Nation data = newNation();

data.Code= _dr[0].ToString();

data.Name= _dr[1].ToString();//扔到集合里面

list.Add(data);

}

}

_conn.Close();returnlist;

}//根据条件查询的方法

public List Select(stringcode)

{

_cmd.CommandText= "select * from Nation where Code=@code";

_cmd.Parameters.Clear();

_cmd.Parameters.AddWithValue("@code",code);

_conn.Open();

_dr=_cmd.ExecuteReader();//定义一个空的集合

List list = new List();if(_dr.HasRows)

{while(_dr.Read())

{//造一个Nation对象

Nation data = newNation();

data.Code= _dr[0].ToString();

data.Name= _dr[1].ToString();//扔到集合里面

list.Add(data);

}

}

_conn.Close();returnlist;

}//删除方法

public bool Delete(stringcode)

{

_cmd.CommandText= "delete from Nation where Code=@code";

_cmd.Parameters.Clear();

_cmd.Parameters.AddWithValue("@code",code);

_conn.Open();int n =_cmd.ExecuteNonQuery();

_conn.Close();if (n > 0)

{return true;

}else{return false;

}

}//修改方法

public bool Update(string code,stringname)

{

_cmd.CommandText= "update Nation set Name=@name where Code=@code";

_cmd.Parameters.Clear();

_cmd.Parameters.AddWithValue("@code",code);

_cmd.Parameters.AddWithValue("@name",name);

_conn.Open();int n =_cmd.ExecuteNonQuery();

_conn.Close();if (n > 0)

{return true;

}else{return false;

}

}public string NationName(stringcode)

{

_cmd.CommandText= "select Name from Nation where Code=@code";

_cmd.Parameters.AddWithValue("@code",code);

_conn.Open();

_dr=_cmd.ExecuteReader();if(_dr.HasRows)

{

_dr.Read();return _dr[0].ToString();

}else{return "汉族";

}

_conn.Close();

}

}