关于怎么写类

[panzi667]

我写咯一个关于登陆的类，但是总是出错，请高手指点

public int ht_login(string username,string userpass,string state)
{
string connectionString = ConfigurationManager.AppSettings["conn"];
using (OleDbConnection connection1 = new OleDbConnection(connectionString))
{
try
{
connection1.Open();
OleDbCommand command1 = new OleDbCommand();
command1.CommandText = "select * from cont_user where user_id=? and user_pwd=? and user_go=?";
OleDbParameter parameter1 = new OleDbParameter("@user_id", OleDbType.LongVarChar, 50);
parameter1.Direction = ParameterDirection.Input;
OleDbParameter parameter2 = new OleDbParameter("@user_pwd", OleDbType.LongVarChar, 50);
parameter2.Direction = ParameterDirection.Input;
OleDbParameter parameter3 = new OleDbParameter("@user_state", OleDbType.LongVarChar, 50);
parameter3.Direction = ParameterDirection.Input;

command1.Parameters.Add(parameter1);
command1.Parameters.Add(parameter2);
command1.Parameters.Add(parameter3);

parameter1.Value = username;
parameter2.Value = userpass;
parameter3.Value = state;

command1.Connection = connection1;
Int32 count = (Int32)command1.ExecuteNonQuery();

return count;

}
catch (Exception ex)
{
string ErrMsg = ex.Message.Replace("\n", "");
connection1.Close();
return -1;
}
}


}

[ladOnTheBrinkOfRage]

catch (Exception ex)
{
throw new Exception ex.ToString();
string ErrMsg = ex.Message.Replace("\n", "");
connection1.Close();
return -1;
}

这样就可以看到错误了！

[7712190]

我认为 很少有人把这个称为类

[活靶子哥哥]

出什么错？

[冬夜紫雨]

没看到CLASS啊

[panzi667]

他总是 return -1;

[panzi667]

int count=my_login.ht_login(username,userpass,user_go);
Response.Write(count);

我在登陆的时候调用，但是我输入数据是正确的，他也 return -1;所以我想问问
1，我写的这个类出现什么问题咯
2，我写的这个真的不是类么？如果是类，应该怎么写？
3，假如是类的话，我写的这个登陆类存在什么问题么？


public class mylogin
{
public int ht_login(string username,string userpass,string state)
{
string connectionString = ConfigurationManager.AppSettings["conn"];
using (OleDbConnection connection1 = new OleDbConnection(connectionString))
{
try
{
connection1.Open();
OleDbCommand command1 = new OleDbCommand();
command1.CommandText = "select * from cont_user where user_id=? and user_pwd=? and user_go=?";
OleDbParameter parameter1 = new OleDbParameter("@user_id", OleDbType.LongVarChar, 50);
parameter1.Direction = ParameterDirection.Input;
OleDbParameter parameter2 = new OleDbParameter("@user_pwd", OleDbType.LongVarChar, 50);
parameter2.Direction = ParameterDirection.Input;
OleDbParameter parameter3 = new OleDbParameter("@user_state

", OleDbType.LongVarChar, 50);
parameter3.Direction = ParameterDirection.Input;

command1.Parameters.Add(parameter1);
command1.Parameters.Add(parameter2);
command1.Parameters.Add(parameter3);

parameter1.Value = username;
parameter2.Value = userpass;
parameter3.Value = state;

command1.Connection = connection1;
Int32 count = (Int32)command1.ExecuteNonQuery();

return count;

}
catch (Exception ex)
{
string ErrMsg = ex.Message.Replace("\n", "");
connection1.Close();
return -1;
}
}


}
}

[powerzy]

你在catch里面把获取到的异常输出来看看

[panzi667]

怎么输出？
偶是菜鸟