public MySqlCommand GetAddCommand(User obj)
{
MySqlCommand cmd = new MySqlCommand();
string sql="insert into testdb.user(username,password) values(?username, ?password)";
cmd.CommandText = sql;
cmd.Parameters.Add(new MySqlParameter("?username", SqlDataUtil.ToDBNullValue(obj.Username)));
cmd.Parameters.Add(new MySqlParameter("?password", SqlDataUtil.ToDBNullValue(obj.Password)));
return cmd;
}
public MySqlCommand GetUpdateCommand(User obj)
{
MySqlCommand cmd = new MySqlCommand();
string sql="update testdb.user set username=?username,password=?password where id=?id ";
cmd.CommandText = sql;
cmd.Parameters.Add(new MySqlParameter("?id", SqlDataUtil.ToDBNullValue(obj.Id)));
cmd.Parameters.Add(new MySqlParameter("?username", SqlDataUtil.ToDBNullValue(obj.Username)));
cmd.Parameters.Add(new MySqlParameter("?password", SqlDataUtil.ToDBNullValue(obj.Password)));
return cmd;
}
public static int Add(User obj)
{
return helper.Add(obj);
}
public User FindByKey(int id)
{
MySqlCommand cmd = GetFindCommand(id);
DataSet dataSet = SqlUtil.ExecuteQuery(cmd);
if (dataSet.Tables[0].Rows.Count < 1)
{
return null;
}
DataRow dr = dataSet.Tables[0].Rows[0];
User obj = new User();
DataUtil.DataRowToObject(dr,obj);
return obj;
}
public int Update(User obj)
{
MySqlCommand cmd = GetUpdateCommand(obj);
return (int)SqlUtil.ExecuteNonQuery(cmd);
}
