Dao.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace WindowsFormsApp1
{
    class Dao
    {
        SqlConnection sc;
        public SqlConnection connect()
        {
            string str = @"Data Source=.;Initial Catalog=book;Integrated Security=True";
            sc = new SqlConnection(str);
            sc.Open();
            return sc;
         }
        public SqlCommand command(string sql)
        {
            SqlCommand cmd = new SqlCommand(sql, connect());
            return cmd;
        }
        public int Execute(string sql)
        {
            return command(sql).ExecuteNonQuery();

        }
        public SqlDataReader read(string sql)
        {
            return command(sql).ExecuteReader();
        }
        public void Daoclose()
        {
            sc.Close();
        }





    }
}