人才招聘网站系统毕业论文(2)

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查询语句或存储过程 ///

///

/// /// public DataTable ExecuteQuery(string cmdText,CommandType ct) {

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语句或存储过程 ///

/// /// /// /// public DataTable ExecuteQuery(string cmdText, SqlParameter[]

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