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); }