数据库连接增，删，该、改，查

来源：互联网发布：windows 7 64 sp1补丁编辑：程序博客网时间：2024/06/14 05:09

一个类四个方法：

class Program

{

// 连接数据库，并查询数据库中的users信息

List<Users> list = new List<Users>();

public List<Users> select() {

SqlConnection con = new SqlConnection("server=.;database=GameMarket;Trusted_Connection=SSPI");

con.Open();

string sql = "select * from users";

SqlCommand sc = new SqlCommand(sql, con);

SqlDataReader reader = sc.ExecuteReader();

while (reader.Read()) {

Users u = new Users();

u.Id =(int) reader.GetValue(0);

u.Name = (string)reader.GetValue(1);

list.Add(u);

}

return list;

}

//向数据库的users表中插入数据

public int insert(string name)

{

SqlConnection con = new SqlConnection("server=.;database=GameMarket;Trusted_Connection=SSPI");

con.Open();

string sql = "insert into users values('"+name+"')";

SqlCommand sc = new SqlCommand(sql, con);

int i=sc.ExecuteNonQuery();

return i;

}

//更新数据库中users表的数据

public int update(int id,string name)

{

SqlConnection con = new SqlConnection("server=.;database=GameMarket;Trusted_Connection=SSPI");

con.Open();

string sql = "update users set name='"+name+"' where id="+id+"";

SqlCommand sc = new SqlCommand(sql, con);

int i = sc.ExecuteNonQuery();

return i;

}

//删除数据库中users表中的某些数据

public int delete(int id)

{

SqlConnection con = new SqlConnection("server=.;database=GameMarket;Trusted_Connection=SSPI");

con.Open();

string sql = "delete from users where id="+id+"";

SqlCommand sc = new SqlCommand(sql, con);

int i = sc.ExecuteNonQuery();

return i;

}

static void Main(string[] args)

{

}

0 0