新手求帮助,小弟我写的数据库操作类出有关问题了
新手求帮助,我写的数据库操作类出问题了
public String getByIdAndPassword(String username, string password)
{
string sql = "select * from d_user where username=:username and password=:password";
List<OracleParameter> list = new List<OracleParameter>();
list.Add(new OracleParameter("username", username));
list.Add(new OracleParameter("password", password));
DataTable dt = GetDataTable(sql, list);
if (dt!=null&&dt.Rows.Count > 0)
{
return "ok";
}
else
{
return "false";
}
}
/// <summary>
/// 公有方法,获取数据,返回一个DataTable。
/// </summary>
/// <param name="SqlString">Sql语句</param>
/// <returns>DataTable</returns>
static public DataTable GetDataTable(string cmdText, List<OracleParameter> cmdParms)
{
try
{
DataSet dataset = GetDataSet(cmdText, cmdParms);
if (dataset == null || dataset.Tables.Count == 0)
{
return null;
}
dataset.CaseSensitive = false;
if (dataset.Tables.Count > 0)
return dataset.Tables[0];
else return new DataTable();
}
catch (System.Exception e)
{
return null;
}
}
/// <summary>
/// 数据库的链接
/// </summary>
/// <returns></returns>
static protected OracleConnection connection()
{
string ConnectionString = "Data Source=orcl;user=scott;password=root;";
return new OracleConnection(ConnectionString);
}
/// <summary>
/// 公有方法,获取数据,返回一个DataSet。
/// </summary>
/// <returns>DataSet</returns>
static public DataSet GetDataSet(string cmdText, List<OracleParameter> cmdParms)
{
OracleConnection conn = connection();