aspnet 数据库 操作类_操作类

ASP.NET数据库操作类是一个用于执行数据库操作的类，通常包含以下功能：

1、连接数据库：建立与数据库的连接。

2、查询数据：从数据库中检索数据。

3、插入数据：向数据库中插入新数据。

4、更新数据：修改数据库中已有的数据。

5、删除数据：从数据库中删除数据。

6、关闭连接：断开与数据库的连接。

以下是一个简单的ASP.NET数据库操作类的示例代码：

using System;
using System.Data;
using System.Data.SqlClient;
public class DatabaseOperations
{
    private string connectionString;
    public DatabaseOperations(string connectionString)
    {
        this.connectionString = connectionString;
    }
    // 连接数据库
    private SqlConnection GetConnection()
    {
        return new SqlConnection(connectionString);
    }
    // 查询数据
    public DataTable SelectData(string query)
    {
        using (SqlConnection connection = GetConnection())
        {
            connection.Open();
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    DataTable dataTable = new DataTable();
                    dataTable.Load(reader);
                    return dataTable;
                }
            }
        }
    }
    // 插入数据
    public void InsertData(string query)
    {
        using (SqlConnection connection = GetConnection())
        {
            connection.Open();
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.ExecuteNonQuery();
            }
        }
    }
    // 更新数据
    public void UpdateData(string query)
    {
        using (SqlConnection connection = GetConnection())
        {
            connection.Open();
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.ExecuteNonQuery();
            }
        }
    }
    // 删除数据
    public void DeleteData(string query)
    {
        using (SqlConnection connection = GetConnection())
        {
            connection.Open();
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.ExecuteNonQuery();
            }
        }
    }
}

使用示例：

string connectionString = "your_database_connection_string";
DatabaseOperations dbOperations = new DatabaseOperations(connectionString);
// 查询数据
string selectQuery = "SELECT * FROM your_table";
DataTable dataTable = dbOperations.SelectData(selectQuery);
// 插入数据
string insertQuery = "INSERT INTO your_table (column1, column2) VALUES ('value1', 'value2')";
dbOperations.InsertData(insertQuery);
// 更新数据
string updateQuery = "UPDATE your_table SET column1 = 'new_value' WHERE column2 = 'value2'";
dbOperations.UpdateData(updateQuery);
// 删除数据
string deleteQuery = "DELETE FROM your_table WHERE column1 = 'value1'";
dbOperations.DeleteData(deleteQuery);