.NET 三层架构中放在DAL层的DBHelper

}
finally
{
if (command != null)
{
command.Connection.Close();
}
finally
{
if (command != null)
{
command.Connection.Close();
}
}
return 0;
}
//带一个参数的返回受影响行数SQL语句
public static int ExecuteNonQuery(string sql, SqlParameter sp)
return command.ExecuteNonQuery();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (command != null)
{
command.Connection.Close();
{
SqlCommand command = null;
try
{
command = CreateCommand(sql, sp);
command.Connection.Open();
}
finally
{
if (command != null)
{
command.Connection.Close();
return command.ExecuteScalar();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
return command.ExecuteNonQuery();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
command.Parameters.AddRange(sps);
return command;
}
//没有带参数的返回受影响行数SQL语句
public static int ExecuteNonQuery(string sql)
}
finally
{
if (command != null)
{
command.Connection.Close();
public static SqlCommand CreateCommand(string sql, SqlParameter[] sps)
{
SqlCommand command = new SqlCommand(sql, CreateConnection());
}
}
return 0;
}
//带一个参数的返回第一行第一列的值SQL语句
public static object ExecuteScalar(string sql, SqlParameter sp)
}
finally
{
if (command != null)
{
command.Connection.Close();
return command.ExecuteScalar();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
{
public static SqlConnection CreateConnection()
{
//return new SqlConnection(@"server=.\sqlexperss;database=jiajiaodb;user Id=sa;pwd=123456");
}
}
return 0;
}
//没有带参数的返回第一行第一列的值SQL语句
public static object ExecuteScalar(string sql)
{
SqlCommand command = null;
try
{
command = CreateCommand(sql, sp);
command.Connection.Open();
}
}
return 0;
}
//没有带参数的返回多行多列的值SQL语句
public static SqlDataReader ExecuteReader(string sql)
{
SqlCommand command=new SqlCommand(sql,CreateConnection());
command.Parameters.Add(sp);
return command;
}
return new SqlConnection("Data Source=.;Initial Catalog=Myoffice;Persist Security Info=True;User ID=sa;Password=sa");
}
public static SqlCommand CreateCommand(string sql)
}
}
return 0;
}
//带多个参数的返回受影响行数SQL语句
public static int ExecuteNonQuery(string sql, SqlParameter[] sps)
return command.ExecuteNonQuery();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
{
SqlCommand command = null;
try
{
command = CreateCommand(sql);
command.Connection.Open();
{
return new SqlCommand(sql, CreateConnection());
}
public static SqlCommand CreateCommand(string sql, SqlParameter sp)
}
}
return 0;
}
//第多个参数的返回第一行第一列的值SQL语句
public static object ExecuteScalar(string sql, SqlParameter[] sps)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace DAL
{
public class DBHelቤተ መጻሕፍቲ ባይዱer
{
SqlCommand command = null;
try
{
command = CreateCommand(sql, sps);
command.Connection.Open();
return command.ExecuteScalar();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
{
SqlCommand command = null;
try
{
command = CreateCommand(sql);
command.Connection.Open();
{
SqlCommand command = null;
try
{
command = CreateCommand(sql, sps);
command.Connection.Open();