软件工程课程设计报告模板(18)

public int ExecuteSQL(string sqlstr) {

int count = -1; this.Open();

SqlCommand cmd = new SqlCommand(sqlstr, connection); count = cmd.ExecuteNonQuery(); this.Close();

return count; }

public DataSet GetDataSet(string sqlstr) {

this.Open();

DataSet ds = new DataSet();

SqlDataAdapter adapter = new SqlDataAdapter(sqlstr,connection); adapter.Fill(ds); this.Close();

return ds; }

public DataTable GetDataTable(string sqlstr) {

DataSet ds = this.GetDataSet(sqlstr); DataTable dt = new DataTable(); if (ds.Tables.Count > 0) {

dt = ds.Tables[0]; }

return dt; }

public SqlDataReader GetDataReader(string sqlstr) {

this.Open();

SqlCommand cmd = new SqlCommand(sqlstr, connection);

SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //this.Close(); return sdr; } } }

5.2 UserBase类是所有系统角色用户的基类，完成用户登录验证与修改密码的功能，代码如下：

namespace MyElectCourse.BLL {