using System.Data;
using System.Data.SqlClient; using System.Configuration;
namespace DAL {
public class SQLHelper {
private SqlConnection conn = null; private SqlCommand cmd = null; private SqlDataReader sdr = null;
public SQLHelper() {
string connStr = ConfigurationManager.ConnectionStrings
[\].ConnectionString;
conn = new SqlConnection(connStr); }
private SqlConnection GetConn() {
if (conn.State == ConnectionState.Closed) {
conn.Open(); }
return conn; }
///
/// 执行不带参数的增删改SQL语句或存储过程 ///
/// /// ///
public int ExecuteNonQuery(string cmdText, CommandType ct) {
int res; try {
cmd = new SqlCommand(cmdText, GetConn()); cmd.CommandType = ct;
res = cmd.ExecuteNonQuery(); }
6
catch (Exception ex) {
throw ex; }
finally {
if (conn.State == ConnectionState.Open) {
conn.Close(); } }
return res; }
///
/// 执行带参数的SQL增删改语句或存储过程 ///
/// /// ///
public int ExecuteNonQuery(string sql, SqlParameter[] paras,
CommandType ct)
{
int res;
using (cmd = new SqlCommand(sql, GetConn())) {
cmd.CommandType = ct;
cmd.Parameters.AddRange(paras); res = cmd.ExecuteNonQuery(); }
return res; }
///
/// 该方法执行传入的SQL查询语句或存储过程 ///
///
/// ///
DataTable dt = new DataTable();
7
cmd = new SqlCommand(cmdText, GetConn()); cmd.CommandType = ct; using (sdr = cmd.ExecuteReader
(CommandBehavior.CloseConnection))
{
dt.Load(sdr); }
return dt; }
///
/// 执行带参数的查询SQL语句或存储过程 ///
/// /// /// ///
paras, CommandType ct)
{
DataTable dt = new DataTable();
cmd = new SqlCommand(cmdText, GetConn()); cmd.CommandType = ct;
cmd.Parameters.AddRange(paras); using (sdr = cmd.ExecuteReader
(CommandBehavior.CloseConnection))
{
dt.Load(sdr); }
return dt; } }
} 2.2.2、 DAL层实现数据库对表(CategoryDAO、CommentDAO、CompanyManageDAO、ManageDAO、UserManageDAO)的基本操作 /*
*招聘信息类别表的操作类 * 王溢文 */
using System;
using System.Collections.Generic; using System.Linq; using System.Text; using System.Data;
8
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库人才招聘网站系统毕业论文(2)在线全文阅读。
相关推荐：