菜品管理數(shù)據(jù)庫.doc

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Data;namespace 網(wǎng)吧計費系統(tǒng) class SqlHelper static string connStr = server=.;database=netBarDb;uid=sa;pwd=123456; /增刪改 #region / / 執(zhí)行增刪改語句 / / insert/delelt/update語句 / 參數(shù)的數(shù)組 / public static int ExecuteNonQuery(string sql, params SqlParameter parameters) /創(chuàng)建連接對象 SqlConnection conn = new SqlConnection(connStr); conn.Open(); /創(chuàng)建命令對象 SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddRange(parameters); /返還受影響的行數(shù) int row = cmd.ExecuteNonQuery(); conn.Close(); return row; #endregion /單行單列查詢 #region / / 單行單列查詢 / / select語句 / 參數(shù)數(shù)組 / 第一列第一行的內(nèi)容 public static object ExecuteScalar(string sql, params SqlParameter parameters) /創(chuàng)建連接對象 /SqlConnection conn = new SqlConnection(connStr); /conn.Open(); /創(chuàng)建命令對象 /SqlCommand cmd = new SqlCommand(sql, conn); /cmd.Parameters.AddRange(parameters); /object obj = cmd.ExecuteScalar(); /conn.Close(); /return obj; using (SqlConnection conn = new SqlConnection(connStr) conn.Open(); using (SqlCommand cmd = conn.CreateCommand() cmd.CommandText = sql; foreach (SqlParameter parameter in parameters) cmd.Parameters.Add(parameter); return cmd.ExecuteScalar(); #endregion /多行多列查詢 #region / / 多行多列連接查詢 / / select語句 / 參數(shù)數(shù)組 / SqlDataReader讀取器 public static SqlDataReader ExecuteReader(string sql, params SqlParameter parameters) SqlConnection conn = new SqlConnection(connStr); conn.Open(); /創(chuàng)建連接對象 SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddRange(parameters); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); return reader; #endregion /斷開式查詢 #region / / 斷開式查詢 / / select語句 / 參數(shù)的數(shù)組 / 數(shù)據(jù)集 public static DataSet ExecuteDataSet(string sql, params SqlParameter parameters) /創(chuàng)建連接對象 SqlConnection conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = new SqlCommand(sql,conn); cmd.Parameters.AddRange(parameters); /創(chuàng)建數(shù)據(jù)適配器 SqlDataAdapter adapter = new SqlDataAdapte