//查询总数
public void QueryCount() {
SqlConnection con = new SqlConnection("Server=PC-201807031219;DataBase=test;Trusted_Connection=SSPI");
try
{
con.Open();
SqlCommand com = new SqlCommand("select count(*) from users", con);
int x = (int)com.ExecuteScalar();
Console.WriteLine("现在有几条数据:" + x);
}
catch (Exception s)
{
Console.WriteLine("错误信息" + s.Message);
}
finally
{
con.Close();
}
}
public void InsertData() {
SqlConnection con = new SqlConnection("Server=PC-201807031219;DataBase=test;Trusted_Connection=SSPI");
try
{
con.Open();
SqlCommand com = new SqlCommand("insert into users(id,name,password) values(@id,@name,@password)", con);
com.Parameters.AddWithValue("@id",3);
com.Parameters.AddWithValue("@name","ss");
com.Parameters.AddWithValue("@password","ss");
com.ExecuteNonQuery();
Console.WriteLine("写入成功");
}
catch (Exception s)
{
Console.WriteLine("错误信息" + s.Message);
}
finally
{
con.Close();
}
}
public void ModifyData() {
SqlConnection con= new SqlConnection("Server=PC-201807031219;DataBase=test;Trusted_Connection=SSPI");
try
{
con.Open();
SqlCommand com = new SqlCommand("update users set id=@id,name=@name,password=@password where id=@value", con);
com.Parameters.AddWithValue("@id", 5);
com.Parameters.AddWithValue("@name", "sss");
com.Parameters.AddWithValue("@password", "sss");
com.Parameters.AddWithValue("@value",3);
com.ExecuteNonQuery();
Console.WriteLine("修改成功");
}
catch (Exception s)
{
Console.WriteLine("错误信息" + s.Message);
}
finally
{
con.Close();
}
}
public void DeleteData() {
SqlConnection con = new SqlConnection("Server=PC-201807031219;DataBase=test;Trusted_Connection=SSPI");
try
{
con.Open();
SqlCommand com = new SqlCommand("delete from users where id=@id", con);
com.Parameters.AddWithValue("@id", 5);
com.ExecuteNonQuery();
Console.WriteLine("删除成功");
}
catch (Exception s)
{
Console.WriteLine("错误信息" + s.Message);
}
finally
{
con.Close();
}
}