闲暇之余自己写来复习,漏洞百出,自己复习的,勿喷
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;
namespace WindowsFormsApp2
{
class dbh_cs
{
//创建数据库连接字符穿
private static string sql = “server=127.0.0.1;database=Music;uid=sa;pwd=123456”;
//创建数据库链接对象
private static SqlConnection coon = null;
//判断数据库链接状态
public static void k(){
if (coonnull)
{
coon = new SqlConnection(sql);
}
else if (coon.StateConnectionState.Closed)
{
coon.Open();
}
else if (coon.State==ConnectionState.Broken)
{
coon.Close();
coon.Open();
}
}
///
/// 增删改,连接式数据库访问
///
///
///
public static bool bucha(string sql) {
k();
SqlCommand scd= new SqlCommand(sql,coon );
int s = scd.ExecuteNonQuery();
coon.Close();
return s > 0;
}
//断开式数据库访问
public static DataSet gai(string sql) {
k();
DataSet x = new DataSet();
SqlDataAdapter c = new SqlDataAdapter(sql, coon);
c.Fill(x);
coon.Close();
coon.Dispose();
return x;
}
}
}