C#数据库连接（类的形式）

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

namespace systemprotect
{
    class DataCon
    {
        static string strCon = "server=.;database =自己的数据库名;uid=sa;pwd=自己的数据库密码";//数据库连接串

        SqlConnection conn = new SqlConnection(strCon);
        public SqlDataReader query(string str)//查询

        {
            if (this.conn.State == System.Data.ConnectionState.Closed)//判断连接是否打开

            {
                this.conn.Open();

            }

            SqlCommand cmd = new SqlCommand(str, conn);

            return cmd.ExecuteReader();

        }
        public int insert(string str)//插入，删除，更新 返回影响的行数

        {
            if (this.conn.State == System.Data.ConnectionState.Closed)

            {
                this.conn.Open();

            }

            SqlCommand cmd = new SqlCommand(str, conn);

            return cmd.ExecuteNonQuery();

        }
        public void close()//关闭连接

        {
            conn.Close();
        }
    }
}