Question

这样的通用类和DAL代码是存储过程吗?

DAL
//修改
public static bool UpdateStuInfo(StuInfo stu)
{
string strsql = "update stuInfo set "
+"stuName = @stuName,"
+"stuAge = @stuAge,"
+"stuSex = @stuSex,"
+"stuAdress = @stuAdress where stuNo=@stuNo";
//strsql += ";@@identity";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@stuName",stu.stuName),
new SqlParameter("@stuNo",stu.stuNo),
new SqlParameter("@stuAge",stu.stuAge),
new SqlParameter("@stuSex",stu.stuSex),
new SqlParameter("@stuAdress",stu.stuAdress)
};
int count = DBHelper.ExecuteCommand(strsql,para);
if (count > 0)
{
return true;
}
else
{
return false;
}
}

public static int AddStu(StuInfo stu)
{
string strsql = "insert into stuInfo(stuName,stuNo,stuAge,stuSex,stuAdress)"+
"values(@stuName,@stuNo,@stuAge,@stuSex,@stuAdress)";
//strsql += ";@@identity";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@stuName",stu.stuName),
new SqlParameter("@stuNo",stu.stuNo),
new SqlParameter("@stuAge",stu.stuAge),
new SqlParameter("@stuSex",stu.stuSex),
new SqlParameter("@stuAdress",stu.stuAdress)
};
int result= DBHelper.ExecuteCommand(strsql,para);

return result;
}
}

通用类=================================
public static class DBHelper
{

private static SqlConnection connection;
public static SqlConnection Connection
{
get
{
string connectionString = ConfigurationManager.ConnectionStrings["MyOfficeConnectionString"].ConnectionString;
connection = new SqlConnection(connectionString);
if (connection == null)
{
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
return connection;
}
}

public static SqlDataReader GetReader(string safeSql)
{
SqlCommand cmd = new SqlCommand(safeSql, Connection);
SqlDataReader reader = cmd.ExecuteReader();
return reader;
reader.Close();
reader.Dispose();
}

Answer 1

这个不是采用的存储过程，而是采用的SQL语句，而SQL语句是采用参数形式。