public static bool login(string username, string passwd)
{
string sql = string.Format("update user set fingerprint =1 where username='******' and passwd= '{1}'", username, passwd);
int num = MySQLTool.runSql(sql);
DataSet ds = DBhelper.getDS(sql);
if (ds.Tables[0].Rows.Count > 0)
{
return(true);
}
return(false);
}
public static bool reg(UserModel user)
{
string sql = string.Format("insert into user (username,passwd) values ('{0}','{1}')", user.Username, user.Passwd);
try
{
int num = MySQLTool.runSql(sql);
return(true);
}catch (Exception e)
{
return(false);
}
}
public static bool login(string username, string passwd)
{
string sql = string.Format("update user set fingerprint =- fingerprint where username='******' and passwd= '{1}'", username, passwd);
int num = MySQLTool.runSql(sql);
if (num > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool usernameExist(UserModel user)
{
string sql = string.Format("select * from user where username ={0}", user.Username);
int num = MySQLTool.runSql(sql);
if (num > 0)
{
return(true);
}
else
{
return(false);
}
}