databaseconnection.cs

用于超市信息管理的系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
namespace 超市信息管理系统.MarketSystem
{
     public class DataBaseConnection
    {
         public static SqlConnection con;
         //数据库连接
      public static SqlConnection connection()
     {
        con=new SqlConnection ("Persist security info=false;initial catalog=MarketSystem;data source=localhost;integrated security=sspi;");
         return con;
     }
     //删除操作
         public static bool delete(string str)
         {
             SqlConnection con1 = DataBaseConnection.connection();
             try
             {
                 
                 SqlCommand com = new SqlCommand(str, con1);
                 con1.Open();
                 com.ExecuteNonQuery();
                 con1.Close();
             }
             catch (SqlException oe)
             {
                 oe.Message.ToString();
                 return false;
             }
             finally
             {
                 con1.Close();
             }
             return false;
         }
         //更新操作
         public static void update(string str)
         {
             try
             {

                 SqlConnection con1 = DataBaseConnection.connection();
                 con1.Open();
                 SqlCommand com = new SqlCommand(str, con1);
                 com.ExecuteNonQuery();
                 con.Close();
             }
             catch (SqlException oe)
             {
                 oe.Message.ToString();
             }
         }
         //查找ＩＤ是否唯一
         public static bool find(string str)
         {
             con = DataBaseConnection.connection();
             SqlCommand com = new SqlCommand(str,con);
             con.Open();
             SqlDataReader rd = com.ExecuteReader();
             while (rd.Read())
             {
                 con.Close();
                 return true;
             }
             con.Close();
             return false;
         }
         //查找用户密码
         public static string findPass(string str)
         {
             try
             {
                 con = DataBaseConnection.connection();
                 SqlCommand com = new SqlCommand(str, con);
                 con.Open();
                 SqlDataReader rd = com.ExecuteReader();
                 while (rd.Read())
                 {
                     return rd.GetString(1).Trim();
                 }
             }
             catch (SqlException oe)
             {
                 oe.Message.ToString();
             }
             finally
             {
                 con.Close();
             }
             return null;
         }
         //插入操作
         public static void insert(string str)
         {
             try
             {
                 con = DataBaseConnection.connection();
                 SqlCommand com = new SqlCommand(str, con);
                 con.Open();
                 com.ExecuteNonQuery();
             }
             catch (SqlException oe)
             {
                 oe.Message.ToString();
             }
             finally
             {

                 con.Close();
             }

         }

    }
}