C#访问数据库类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;

namespace BOOK
{
class DBsql
{
string dbstring = “Data Source=.;Initial Catalog=headFirst;Integrated Security=True”;//数据库连接字符串
SqlCommand cmd;//执行数据库操作
SqlConnection conn;//创建数据库连接

    //打开数据库
    public void dbOpen(string sql)
    {
        conn = new SqlConnection(dbstring);
        conn.Open();
        cmd = new SqlCommand(sql, conn);
    }
    //读取数据库
    public bool dbRead()
    {
        SqlDataReader dataReader = cmd.ExecuteReader();
        if (dataReader.Read())
        {
            //conn.Close();
            return true;
        }
        else
        {
            //conn.Close();
            return false;
        }
    }

    //写入、删除、更新数据库
    //返回值大于等于1时写入成功
    public int dbWrite()
    {
        int row=cmd.ExecuteNonQuery();
        return row;
       // int row=cmd.ExecuteNonQuery();
        //return;
    }
    //关闭数据库
    public void dbClose()
    {
        conn.Close();
    }
}

}