我在后台设置一个全局变量,例如是string path;在程序中有很多方法,例如查询,删除等,那么想用这个path来代表路径:path="select named from 表1",删除方法中又重新给path赋值:path="delete from 表1",这样在每个方法中都重新给path全局变量赋值,这样做可以吗?感觉用起来很方便,不知道会不会影响速度等。
源程序:
public partial class LeaveWord : System.Web.UI.Page
{
SqlDo sqldo = new SqlDo();
SqlDataReader re;
protected string path;//例如这里的这个变量,需要重复使用
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
path = "Insert into all_LeaveWord (uId,LeaverId,LeaveName,LeaveWord) values (" + getId + "," + uId + ",'" + UserName + "','" + FCKeditor1.Value+ "')";
int geted= sqldo.DoSql(path);
if(getId>0)
sqldo.alerted("留言成功");
}
protected void Users()//左边展示用户信息
{
path = "select a.ImageName,a.UserName,a.Grade,a.QQ,a.Sex,a.Address,a.WorkName,a.Birthday,a.Introduce,b.GradeName from all_Users a join all_UserGrade b on a.uId=" + getId + " and a.Grade=b.grId";
re = sqldo.GetRow(path);
if (re.Read())
{
lintroduce.Text = re["Introduce"].ToString();
}
re.Close();
}
全局变量这样重复使用可以吗? 帮忙解释下声明变量是如何占用内存的?
源程序:
public partial class LeaveWord : System.Web.UI.Page
{
SqlDo sqldo = new SqlDo();
SqlDataReader re;
protected string path;//例如这里的这个变量,需要重复使用
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
path = "Insert into all_LeaveWord (uId,LeaverId,LeaveName,LeaveWord) values (" + getId + "," + uId + ",'" + UserName + "','" + FCKeditor1.Value+ "')";
int geted= sqldo.DoSql(path);
if(getId>0)
sqldo.alerted("留言成功");
}
protected void Users()//左边展示用户信息
{
path = "select a.ImageName,a.UserName,a.Grade,a.QQ,a.Sex,a.Address,a.WorkName,a.Birthday,a.Introduce,b.GradeName from all_Users a join all_UserGrade b on a.uId=" + getId + " and a.Grade=b.grId";
re = sqldo.GetRow(path);
if (re.Read())
{
lintroduce.Text = re["Introduce"].ToString();
}
re.Close();
}
全局变量这样重复使用可以吗? 帮忙解释下声明变量是如何占用内存的?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货