asp.net类中公共类DBHelp（C#）

关注

VIP免费原创最新推荐文章于 2026-01-22 09:33:06 发布 2k 阅读 AI 写同款· GEO 优化 ›

C#可视化编程技术第三章：DBHelper类（内含思路、代码、注释） DBHelper类：阅读详情

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace MyBookShop.DAL
{
    public static class DBHelper
    {

        //SQL数据库的连接，注意：MyBookShop是连接字符串，需要根据项目实际情况进行改变
        private static SqlConnection connection;
        public static SqlConnection Connection
        {
            get 
            {
                string connectionString = ConfigurationManager.ConnectionStrings["MyBookShop"].ConnectionString;
                if (connection == null)
                {
                    connection = new SqlConnection(connectionString);
                    connection.Open();
                }
                else if (connection.State == System.Data.ConnectionState.Closed)
                {
                    connection.Open();
                }
                else if (connection.State == System.Data.ConnectionState.Broken)
                {