using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Data.SqlClient;
namespace?WindowsFormsApp1
{
??public??class?DBHelper
????{
????????public?static?string?constring?=?“server=127.0.0.1\\MSSQLSERVER2;database=accountBook;uid=sa;pwd=1625862412“;
????????public?static?SqlConnection?con?=?null;
????????public?static?SqlCommand?cmd?=?null;
????????public?static?bool?sqlOpen（string?sql）?
????????{
????????????try
????????????{
????????????????con?=?new?SqlConnection（constring）;
????????????????cmd?=?new?SqlCommand（sql?con）;
????????????????con.Open（）;
????????????????int?count?=?0;
????????????????if?（sql.Contains（“insert“）?==?true?&&?sql.Contains（“update“）?==?true?&&?sql.Contains（“delete“）?==?true）
????????????????{
????????????????????count?=?cmd.ExecuteNonQuery（）;
????????????????????if?（count?>?0）
????????????????????{
????????????????????????return?true;
????????????????????}
????????????????????else?
????????????????????{
????????????????????????return?false;
????????????????????}
????????????????}
????????????????else?if（sql.Contains（“COUNT“））
????????????????{
????????????????????count?=Convert.ToInt32（?cmd.ExecuteScalar（））;
????????????????????if?（count?>?0）
????????????????????{
????????????????????????return?true;
????????????????????}
????????????????????else?
????????????????????{
????????????????????????return?false;
????????????????????}
????????????????}
????????????????else
????????????????{
?????????????????SqlDataReader?hehe??=?cmd.ExecuteReader（）;
????????????????????if?（hehe?!=?null）
????????????????????{
????????????????????????return?true;
????????????????????}
????????????????????else?
????????????????????{
????????????????????????return?false;
????????????????????}
????????????????}
????????????}
????????????catch?（Exception）
????????????{
????????????????return?false;
????????????}
????????}
????}
}