首頁 資料庫 mysql教程 C# SqlServer的Helper基类

C# SqlServer的Helper基类

Jun 07, 2016 pm 05:40 PM
helper sqlserver

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Collections; using System.Data; using System.Data.SqlClient; using System.Data.Common; namespace SqlServerDAL { public class SqlHelper { sta


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;


namespace SqlServerDAL
{
public class SqlHelper
{
static string _SqlConnectionString;
public static string SqlConnectionString
{
get
{
return _SqlConnectionString;
}
set
{
_SqlConnectionString = value;
}
}


///


/// 设置参数内容
///

/// 名称
/// 数据类型
/// 长度大小
///
/// 类型
///
public static SqlParameter SetDataParameter(string ParamName, SqlDbType DbType, Int32 Size, object paramevalue, ParameterDirection Direction)
{
SqlParameter param = new SqlParameter();
param.SqlDbType = DbType;
param.ParameterName = ParamName;

if (Size > 0)
{
param.Size = Size;
}
if (paramevalue.ToString() != "" && paramevalue != null && Direction != ParameterDirection.Output)
{
param.Value = paramevalue;
}

param.Direction = Direction;
return param;
}
///
/// 设置参数内容
///

/// 名称
/// 数据类型
/// 类型
///
public static SqlParameter SetDataParameter(string ParamName, SqlDbType DbType, ParameterDirection Direction)
{
SqlParameter param = new SqlParameter();
param.SqlDbType = DbType;
param.ParameterName = ParamName;
param.Direction = Direction;
return param;
}

#region 私有办法
///
/// 将SqlParameter参数数组(参数值)分派给DbCommand号令.
/// 这个办法将给任何一个参数分派DBNull.Value;
/// 该操纵将阻拦默认值的应用.
///

/// 号令名
/// SqlParameters数组
private static void AttachParameters(SqlCommand command, SqlParameter[] commandParameters)
{
if (command == null) throw new ArgumentNullException("command");
if (commandParameters != null)
{
foreach (SqlParameter p in commandParameters)
{
if (p != null)
{
// 搜检未分派值的输出参数,将其分派以DBNull.Value.
if ((p.Direction == ParameterDirection.InputOutput || p.Direction == ParameterDirection.Input) &&
(p.Value == null))
{
p.Value = DBNull.Value;
}
command.Parameters.Add(p);
}
}
}
//应用完成后清除原所有参数值
// ClearIDataParameter();
}

///
/// 预处理惩罚用户供给的号令,数据库连接/事务/号令类型/参数
///

/// 一个有效的事务或者是null值
/// 号令类型 (存储过程,号令文本, 其它.)
/// 存储过程名或都SQL号令文本
/// 和号令相接洽关系的SqlParameter参数数组,若是没有参数为""null""
/// true 若是连接是打开的,则为true,其它景象下为false.
private static void PrepareCommand(SqlConnection Connection, SqlCommand Command, SqlTransaction transaction, CommandType commandType, string commandText, SqlParameter[] commandParameters, out bool mustCloseConnection)
{
try
{
if (Command == null) throw new ArgumentNullException("command");
if (commandText == null || commandText.Length == 0) throw new ArgumentNullException("commandText");

if (Connection.State != ConnectionState.Open)
{
mustCloseConnection = true;
Connection.Open();
}
else
{
mustCloseConnection = false;
}

// 给号令分派一个数据库连接.
Command.Connection = Connection;

// 设置号令文本(存储过程名或SQL语句)
Command.CommandText = commandText;

// 分派事务
if (transaction != null)
{
if (transaction.Connection == null) throw new ArgumentException("The transaction was rollbacked or commited, please provide an open transaction.", "transaction");
Command.Transaction = transaction;
}

// 设置号令类型.
Command.CommandType = commandType;

// 分派号令参数
if (commandParameters != null)
{
//SqlParameter[] dpitem =
AttachParameters(Command, commandParameters);
}
}
catch
{
mustCloseConnection = false;
}
}
#endregion

#region uteDataSet 数据表
///
/// 履行指定命据库连接字符串的号令,返回DataSet.
///

/// 存储过程名称或SQL语句
/// 返回一个包含成果集的DataSet
public static DataSet uteDataSet(string commandText)
{
return uteDataSet((SqlTransaction)null, commandText, CommandType.Text, (SqlParameter[])null);
}
///
/// 履行指定命据库连接字符串的号令,返回DataSet.
///

/// 存储过程名称或SQL语句
/// 号令类型 (存储过程,号令文本或其它)
/// 参数
/// 返回一个包含成果集的DataSet
public static DataSet uteDataSet(SqlTransaction transaction, string commandText, CommandType commandType, params SqlParameter[] commandParameters)
{
if (SqlConnectionString == null || SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");

using (SqlConnection connection = new SqlConnection(SqlConnectionString))
{

connection.Open();
bool mustCloseConnection = false;
SqlCommand Command = new SqlCommand();
PrepareCommand(connection, Command, transaction, commandType, commandText, commandParameters, out mustCloseConnection);
try
{
SqlDataAdapter sdap = new SqlDataAdapter();
sdap.SelectCommand = Command;

DataSet ds = new DataSet();
sdap.Fill(ds);
Command.Parameters.Clear();//清空

Command.Dispose();
if (mustCloseConnection)
connection.Close();
return ds;
}
catch (Exception ex)
{
Command.Parameters.Clear();//清空

Command.Dispose();
if (mustCloseConnection)
connection.Close();

return new DataSet();
}
}
}
///
/// 履行指定命据库连接字符串的号令,返回DataSet.
///

/// 存储过程名称或SQL语句
/// 号令类型 (存储过程,号令文本或其它)
/// 返回一个包含成果集的DataSet
public static DataSet uteDataSet(string commandText, CommandType commandTytpe)
{
return uteDataSet((SqlTransaction)null, commandText, commandTytpe, (SqlParameter[])null);
}
///
/// 履行指定命据库连接字符串的号令,返回DataSet.
///

/// 输出输出参数成果凑集,例:{Name,Value}
/// 存储过程名称或SQL语句
/// 号令类型 (存储过程,号令文本或其它)
/// 参数
/// 返回一个包含成果集的DataSet
public static DataSet uteDataSet(ref Hashtable outParameters, string commandText, CommandType commandType, params SqlParameter[] commandParameters)
{
if (SqlConnectionString == null || SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");

using (SqlConnection connection = new SqlConnection(SqlConnectionString))
{

connection.Open();

bool mustCloseConnection = false;
SqlCommand Command = new SqlCommand();
PrepareCommand(connection, Command, (SqlTransaction)null, commandType, commandText, commandParameters, out mustCloseConnection);
try
{
SqlDataAdapter sdap = new SqlDataAdapter();
sdap.SelectCommand = Command;

DataSet ds = new DataSet();
sdap.Fill(ds);

if (outParameters != null)
{
for (int i = 0; i {
if (Command.Parameters[i].Direction == ParameterDirection.Output)
{
if (!outParameters.Contains(Command.Parameters[i].ParameterName))
{
outParameters.Add(Command.Parameters[i].ParameterName, Command.Parameters[i].Value.ToString());
}
}
}
}
Command.Parameters.Clear();//清空

Command.Dispose();
if (mustCloseConnection)
connection.Close();
return ds;
}
catch (Exception ex)
{
Command.Parameters.Clear();//清空

Command.Dispose();
if (mustCloseConnection)
connection.Close();

return new DataSet();
}
}
}
///
/// 履行指定命据库连接字符串的号令,返回DataSet.
///

/// 输出输出参数成果凑集,例:{Name,Value}
/// 存储过程
/// 参数
/// 返回一个包含成果集的DataSet
public static DataSet uteDataSet(ref Hashtable outParameters, string SqlSPro, params SqlParameter[] commandParameters)
{
return uteDataSet(ref outParameters, SqlSPro, CommandType.StoredProcedure, commandParameters);
}
///
/// 履行指定命据库连接字符串的号令,返回DataSet.
///

/// 输出输出参数成果凑集,例:{Name,Value}
/// 存储过程
/// 参数
/// 返回一个包含成果集的DataSet
public static DataSet uteDataSet(string SqlSPro, params SqlParameter[] commandParameters)
{
Hashtable outParameters = null;
return uteDataSet(ref outParameters, SqlSPro, CommandType.StoredProcedure, commandParameters);
}
#endregion

#region uteScalar 返回成果集中的第一行第一列

///
/// 返回一条数据
///

///
///
///
///
///
public static object uteScalar(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
if (SqlConnectionString == null || SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");

using (SqlConnection connection = new SqlConnection(SqlConnectionString))
{

connection.Open();
bool mustCloseConnection = false;
SqlCommand Command = new SqlCommand();
try
{
PrepareCommand(connection, Command, transaction, commandType, commandText, commandParameters, out mustCloseConnection);
object rvalue = Command.uteScalar();
Command.Parameters.Clear();//清空
Command.Dispose();
if (mustCloseConnection)
connection.Close();
return rvalue;
}
catch (Exception ex)
{
Command.Parameters.Clear();//清空
if (mustCloseConnection)
connection.Close();

return null;
}

}
}
///
/// 返回一条数据
///

///
///
///
public static object uteScalar(CommandType commandType, string commandText)
{
return uteScalar((SqlTransaction)null, commandType, commandText, (SqlParameter[])null);
}
///
/// 返回一条数据
///

///
///
///
public static object uteScalar(CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
return uteScalar((SqlTransaction)null, commandType, commandText, commandParameters);
}
///
/// 返回一条数据
///

///
///
///
///
public static object uteScalar(CommandType commandType, string commandText, SqlTransaction transaction)
{
return uteScalar(transaction, commandType, commandText, (SqlParameter[])null);
}
///
/// 返回一第数据
///

///
///
public static object uteScalar(string commandText)
{
return uteScalar(CommandType.Text, commandText, (SqlTransaction)null);
}
#endregion

#region uteDataReader 数据浏览器

public static DbDataReader uteDataReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
if (connection == null) throw new ArgumentNullException("connection");
DbDataReader reader = null;
bool mustCloseConnection = false;
SqlCommand Command = new SqlCommand();
try
{
PrepareCommand(connection, Command, transaction, commandType, commandText, commandParameters, out mustCloseConnection);

reader = Command.uteReader(System.Data.CommandBehavior.CloseConnection);

//reader = Command.uteReader(System.Data.CommandBehavior.CloseConnection);

Command.Parameters.Clear();//清空
//Command.Dispose();
}
catch (Exception ex)
{

}
return reader;
}
public static DbDataReader uteDataReader(SqlTransaction transaction, CommandType commandType, string commandText)
{
if (SqlConnectionString == null || SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");
SqlConnection connection = null;
try
{
connection = new SqlConnection(SqlConnectionString);

connection.Open();
return uteDataReader(connection, transaction, commandType, commandText, (SqlParameter[])null);
}
catch
{
// If we fail to return the SqlDatReader, we need to close the connection ourselves
if (connection != null) connection.Close();
throw;
}
}
public static DbDataReader uteDataReader(CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
if (SqlConnectionString == null || SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");
SqlConnection connection = null;
try
{
connection = new SqlConnection(SqlConnectionString);

connection.Open();
return uteDataReader(connection, (SqlTransaction)null, commandType, commandText, commandParameters);
}
catch
{
// If we fail to return the SqlDatReader, we need to close the connection ourselves
if (connection != null) connection.Close();
throw;
}
}
public static DbDataReader uteDataReader(CommandType commandType, string commandText)
{
return uteDataReader(commandType, commandText, (SqlParameter[])null);
}
public static DbDataReader uteDataReader(string commandText)
{
return uteDataReader(CommandType.Text, commandText);
}
public static DbDataReader uteDataReader(SqlConnection connection, out List outParameters, string commandText, CommandType commandType, params SqlParameter[] commandParameters)
{
DbDataReader reader = null;
outParameters = new List();
try
{
bool mustCloseConnection = false;
SqlCommand Command = new SqlCommand();
PrepareCommand(connection, Command, (SqlTransaction)null, commandType, commandText, commandParameters, out mustCloseConnection);

reader = Command.uteReader(System.Data.CommandBehavior.CloseConnection);// (CommandBehavior.CloseConnection);
Command.Parameters.Clear();//清空
Command.Dispose();

}
catch (Exception ex)
{
}
return reader;
}
public static DbDataReader uteDataReader(out List outParameters, string SqlSPro, params SqlParameter[] commandParameters)
{
if (SqlConnectionString == null || SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");
SqlConnection connection = null;
try
{
connection = new SqlConnection(SqlConnectionString);

connection.Open();
return uteDataReader(connection, out outParameters, SqlSPro, CommandType.StoredProcedure, commandParameters);
}
catch
{
// If we fail to return the SqlDatReader, we need to close the connection ourselves
if (connection != null) connection.Close();
throw;
}
}
#endregion

#region uteDataRow 返回成果集中第一行
///
/// 履行指定命据库连接字符串的号令,返回DataSet第一行.
///

/// 存储过程名称或SQL语句
/// 号令类型 (存储过程,号令文本或其它)
/// 参数
/// 返回一个包含成果集的DataSet中的第一行
public static DataRow uteDataRow(SqlTransaction transaction, string commandText, CommandType commandType, params SqlParameter[] commandParameters)
{
try
{
DataRow row = null;
DataSet ds = uteDataSet(transaction, commandText, commandType, commandParameters);
if (ds.Tables[0].Rows.Count > 0)
{
row = (DataRow)ds.Tables[0].Rows[0];
}
ds.Dispose();
return row;
}
catch
{
return null;
}
}
public static DataRow uteDataRow(string commandText, CommandType commandType)
{
return uteDataRow((SqlTransaction)null, commandText, commandType, (SqlParameter[])null);
}
public static DataRow uteDataRow(string commandText, CommandType commandType, params SqlParameter[] commandParameters)
{
return uteDataRow((SqlTransaction)null, commandText, commandType, commandParameters);
}
public static DataRow uteDataRow(string commandText)
{
return uteDataRow((SqlTransaction)null, commandText,香港服务器, CommandType.Text, (SqlParameter[])null);
}
#endregion

#region uteNonQuery办法
public static int uteNonQuery(ref Hashtable OutPut, string commandText, params SqlParameter[] commandParameters)
{
if (_SqlConnectionString == null || _SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");

using (SqlConnection connection = new SqlConnection(_SqlConnectionString))
{
connection.Open();
// 创建DbCommand号令,并进行预处理惩罚

bool mustCloseConnection = false;
SqlCommand Command = new SqlCommand();
PrepareCommand(connection, Command, (SqlTransaction)null, CommandType.StoredProcedure, commandText, commandParameters, out mustCloseConnection);

// 履行号令
int retval = Command.uteNonQuery();
for (int i = 0; i {
if (Command.Parameters[i].Direction == ParameterDirection.Output)
{
if (!OutPut.Contains(Command.Parameters[i].ParameterName.ToString()))
{
OutPut.Add(Command.Parameters[i].ParameterName.ToString(), Command.Parameters[i].Value.ToString());
}
}
}
// 清除参数,以便再次应用.
Command.Parameters.Clear();

Command.Dispose();

return retval;
}
}
///
/// DataTable批量添加到数据库
///

/// 要写入的表名
/// DataTable表
public static void CopyutNonQuery(string TableName, DataTable dt)
{
if (SqlConnectionString == null || SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");
using (SqlConnection connection = new SqlConnection(SqlConnectionString))
{
connection.Open();
using (SqlTransaction Trans = connection.BeginTransaction())
{
using (SqlBulkCopy sqlBC = new SqlBulkCopy(connection, SqlBulkCopyOptions.FireTriggers, Trans))
{
try
{
//一次批量的插入的数据量
sqlBC.BatchSize = dt.Rows.Count;
//超时之前操纵完成所容许的秒数,若是超时则事务不会提交 ,数据将回滚,所有已复制的行都邑从目标表中移除
sqlBC.BulkCopyTimeout = 360;

//設定 NotifyAfter 属性,以便在每插入10000 条数据时,呼唤响应事务。
// sqlBC.NotifyAfter = 1000;
// sqlBC.SqlRowsCopied += new SqlRowsCopiedEventHandler(OnSqlRowsCopied);

//设置要批量写入的表
sqlBC.DestinationTableName = TableName;

//自定义的datatable和数据库的字段进行对应
//sqlBC.ColumnMappings.Add("id", "tel");
//sqlBC.ColumnMappings.Add("name", "neirong");
//for (int i = 0; i //{
// sqlBC.ColumnMappings.Add(dtColum[i].ColumnName.ToString(), dtColum[i].ColumnName.ToString());
//}
//批量写入
sqlBC.WriteToServer(dt);
Trans.Commit();
}
catch
{
Trans.Rollback();
}

}
}
}
}
///
/// 履行指定命据库连接对象的号令
///

/// 号令类型(存储过程,号令文本或其它.)
/// T存储过程名称或SQL语句
/// SqlParamter参数数组
/// 返回影响的行数
public static int uteNonQuery(CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
if (SqlConnectionString == null || SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");

using (SqlConnection connection = new SqlConnection(SqlConnectionString))
{
connection.Open();
// 创建DbCommand号令,并进行预处理惩罚

bool mustCloseConnection = false;
SqlCommand Command = new SqlCommand();
PrepareCommand(connection, Command, (SqlTransaction)null, commandType, commandText, commandParameters, out mustCloseConnection);

// 履行号令
int retval = Command.uteNonQuery();
// 清除参数,以便再次应用.
Command.Parameters.Clear();

Command.Dispose();

return retval;
}
}
public static int uteNonQuery(SqlTransaction Transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{

bool mustCloseConnection = false;
SqlCommand Command = new SqlCommand(); ;
PrepareCommand(Transaction.Connection, Command, Transaction, commandType, commandText, commandParameters, out mustCloseConnection);

try
{
// 履行号令
int retval = Command.uteNonQuery();

// 清除参数,以便再次应用.
Command.Parameters.Clear();
if (Transaction != null)
{
Transaction.Commit();
}

Command.Dispose();
if (mustCloseConnection)
{
Transaction.Connection.Close();
Transaction.Connection.Dispose();
}
return retval;
}
catch (Exception ex)
{
if (Transaction != null)
{
Transaction.Rollback();
}

Command.Dispose();
return 0;
}
}
public static int uteNonQuery(out int Scope_Identity, SqlTransaction Transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
Scope_Identity = 0;


bool mustCloseConnection = false;
SqlCommand Command = new SqlCommand();
PrepareCommand(Transaction.Connection, Command, Transaction, commandType, commandText, commandParameters, out mustCloseConnection);

try
{
// 履行号令
int retval = Command.uteNonQuery();
// 清除参数,以便再次应用.
Command.Parameters.Clear();
Command.CommandType = CommandType.Text;
Command.CommandText = "SELECT SCOPE_IDENTITY()";
Scope_Identity = int.Parse(Command.uteScalar().ToString());

Command.Dispose();
if (mustCloseConnection)
{
Transaction.Connection.Close();
Transaction.Connection.Dispose();
}
return retval;
}
catch (Exception ex)
{
Command.Dispose();
Transaction.Connection.Close();
Transaction.Connection.Dispose();
return 0;
}
}
///
/// 履行指定命据库连接对象的号令,并输出最后履行的成果编号
///

/// 输出最后履行成果
/// 号令类型(存储过程,号令文本或其它.)
/// T存储过程名称或SQL语句
/// SqlParamter参数数组
/// 返回影响的行数
public static int uteNonQuery(out int Scope_Identity, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{

Scope_Identity = 0;
if (SqlConnectionString == null || SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");

using (SqlConnection connection = new SqlConnection(SqlConnectionString))
{

connection.Open();
// 创建DbCommand号令,并进行预处理惩罚

bool mustCloseConnection = false;
SqlCommand Command = new SqlCommand();
PrepareCommand(connection, Command, (SqlTransaction)null, commandType, commandText, commandParameters, out mustCloseConnection);

try
{
// 履行号令
int retval = Command.uteNonQuery();
// 清除参数,以便再次应用.
Command.Parameters.Clear();
Command.CommandType = CommandType.Text;
Command.CommandText = "SELECT SCOPE_IDENTITY()";
Scope_Identity = int.Parse(Command.uteScalar().ToString());

Command.Dispose();
return retval;
}
catch (Exception ex)
{

Command.Dispose();
return 0;
}
}
}
///
/// 履行指定命据库连接对象的号令
///

/// 一个有效的数据库连接对象
/// 号令类型(存储过程,号令文本或其它.)
/// 存储过程名称或SQL语句
/// 返回影响的行数
public static int uteNonQuery(CommandType commandType, string CommandText)
{
if (CommandText == null || CommandText.Length == 0) throw new ArgumentNullException("commandText");
return uteNonQuery(commandType, CommandText, (SqlParameter[])null);
}
///
/// 履行指定命据库连接对象的号令,将对象数组的值赋给存储过程参数.
///

/// 一个有效的数据库连接对象
/// 存储过程名
/// 分派给存储过程输入参数的对象数组
/// 返回影响的行数
public static int uteNonQuery(string spName,香港空间, params SqlParameter[] commandParameters)
{

if (spName == null || spName.Length == 0) throw new ArgumentNullException("spName");

// 若是有参数值
if ((commandParameters != null) && (commandParameters.Length > 0))
{
return uteNonQuery(CommandType.StoredProcedure, spName, commandParameters);
}
else
{
return uteNonQuery(CommandType.StoredProcedure, spName);
}
}

///
/// 履行带事务的SQL语句
///

///
///
public static int uteNonQuery(string commandText)
{
if (commandText == null || commandText.Length == 0) throw new ArgumentNullException("commandText");
//SqlTransaction Transaction = BBDataProvider.Transaction;
if (SqlConnectionString == null || SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");

using (SqlConnection connection = new SqlConnection(SqlConnectionString))
{
connection.Open();
SqlTransaction Transaction = connection.BeginTransaction();

return uteNonQuery(Transaction, CommandType.Text, commandText, (SqlParameter[])null);
}
}
///
/// 履行存储过程,返回Output成果
///

/// 存储过程名
/// 号令类型(存储过程)
/// SqlParamter参数数组
/// Output成果
public static List uteNonQuery(string commandText, CommandType commandType, params SqlParameter[] commandParameters)
{
if (SqlConnectionString == null || SqlConnectionString.Length == 0) throw new ArgumentNullException("ConnectionString");

using (SqlConnection connection = new SqlConnection(SqlConnectionString))
{
connection.Open();
bool mustCloseConnection = false;
SqlCommand Command = new SqlCommand();
PrepareCommand(connection, Command, (SqlTransaction)null, CommandType.StoredProcedure, commandText, commandParameters, out mustCloseConnection);
try
{
Command.uteNonQuery();
}
catch { }

List outParameters = new List();
for (int i = 0; i {
if (Command.Parameters[i].Direction == ParameterDirection.Output)
{
string[] parameteritem = { Command.Parameters[i].ParameterName.ToString(), Command.Parameters[i].Value.ToString() };
outParameters.Add(parameteritem);
}
}
Command.Parameters.Clear();//清空

Command.Dispose();
if (mustCloseConnection)
connection.Close();
return outParameters;
}
}

#endregion
}
} ,美国服务器

本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn

熱AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智慧驅動的應用程序,用於創建逼真的裸體照片

AI Clothes Remover

AI Clothes Remover

用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool

Undress AI Tool

免費脫衣圖片

Clothoff.io

Clothoff.io

AI脫衣器

Video Face Swap

Video Face Swap

使用我們完全免費的人工智慧換臉工具,輕鬆在任何影片中換臉!

熱門文章

<🎜>:泡泡膠模擬器無窮大 - 如何獲取和使用皇家鑰匙
3 週前 By 尊渡假赌尊渡假赌尊渡假赌
北端:融合系統,解釋
3 週前 By 尊渡假赌尊渡假赌尊渡假赌
Mandragora:巫婆樹的耳語 - 如何解鎖抓鉤
3 週前 By 尊渡假赌尊渡假赌尊渡假赌

熱工具

記事本++7.3.1

記事本++7.3.1

好用且免費的程式碼編輯器

SublimeText3漢化版

SublimeText3漢化版

中文版,非常好用

禪工作室 13.0.1

禪工作室 13.0.1

強大的PHP整合開發環境

Dreamweaver CS6

Dreamweaver CS6

視覺化網頁開發工具

SublimeText3 Mac版

SublimeText3 Mac版

神級程式碼編輯軟體(SublimeText3)

熱門話題

Java教學
1665
14
CakePHP 教程
1423
52
Laravel 教程
1321
25
PHP教程
1269
29
C# 教程
1249
24
sqlserver怎麼匯入mdf文件 sqlserver怎麼匯入mdf文件 Apr 08, 2024 am 11:41 AM

匯入步驟如下:將 MDF 檔案複製到 SQL Server 的資料目錄(通常為 C:\Program Files\Microsoft SQL Server\MSSQL\DATA)。在 SQL Server Management Studio(SSMS)中,開啟資料庫並選擇「附加」。點選“新增”按鈕,選擇 MDF 檔案。確認資料庫名稱,點選確定按鈕即可。

sqlserver資料庫中已存在名為的物件怎麼解決 sqlserver資料庫中已存在名為的物件怎麼解決 Apr 05, 2024 pm 09:42 PM

對於 SQL Server 資料庫中已存在同名對象,需要採取下列步驟:確認物件類型(表格、檢視、預存程序)。如果物件為空,可使用 IF NOT EXISTS 跳過建立。如果物件有數據,使用不同名稱或修改結構。使用 DROP 刪除現有物件(謹慎操作,建議備份)。檢查架構更改,確保沒有引用刪除或重新命名的物件。

怎麼查看sqlserver連接埠號 怎麼查看sqlserver連接埠號 Apr 05, 2024 pm 09:57 PM

若要查看 SQL Server 連接埠號碼:開啟 SSMS,連線到伺服器。在物件資源管理器中找到伺服器名稱,右鍵單擊它,然後選擇“屬性”。在「連線」標籤中,查看「TCP 連接埠」欄位。

sqlserver誤刪資料庫怎麼恢復 sqlserver誤刪資料庫怎麼恢復 Apr 05, 2024 pm 10:39 PM

若誤刪 SQL Server 資料庫,可採取下列步驟還原:停止資料庫活動;備份日誌檔案;檢查資料庫日誌;復原選項:從備份還原;從交易日誌還原;使用 DBCC CHECKDB;使用第三方工具。請定期備份資料庫並啟用交易日誌以防止資料遺失。

sqlserver資料庫在哪裡 sqlserver資料庫在哪裡 Apr 05, 2024 pm 08:21 PM

SQL Server 資料庫檔案通常儲存在下列預設位置:Windows: C:\Program Files\Microsoft SQL Server\MSSQL\DATALinux: /var/opt/mssql/data可透過修改資料庫檔案路徑設定來自訂資料庫檔案位置。

sqlserver服務無法啟動怎麼辦 sqlserver服務無法啟動怎麼辦 Apr 05, 2024 pm 10:00 PM

當 SQL Server 服務無法啟動時,可採取下列步驟解決:檢查錯誤日誌以確定根本原因。確保服務帳戶具有啟動服務的權限。檢查依賴項服務是否正在執行。禁用防毒軟體。修復 SQL Server 安裝。如果修復不起作用,重新安裝 SQL Server。

Java連接SqlServer錯誤如何解決 Java連接SqlServer錯誤如何解決 May 01, 2023 am 09:22 AM

問題發現這次使用的是SqlServer資料庫,之前並沒有使用過,但是問題不大,我按照需求文檔的步驟連接好SqlServer之後,啟動SpringBoot項目,發現了一個報錯,如下:剛開始我以為是SqlServer連接問題呢,於是便去查看資料庫,發現資料庫一切正常,我首先第一時間問了我的同事,他們是否有這樣的問題,發現他們並沒有,於是我便開始了我最拿手的環節,面向百度程式設計.開始解決具體報錯資訊是這樣,於是我便開始了百度報錯:ERRORc.a.d.p.DruidDataSource$CreateCo

sqlserver安裝失敗怎麼樣刪除乾淨 sqlserver安裝失敗怎麼樣刪除乾淨 Apr 05, 2024 pm 11:27 PM

如果 SQL Server 安裝失敗,可透過下列步驟清理:解除安裝 SQL Server刪除註冊表項刪除檔案和資料夾重新啟動計算機

See all articles