go使用sqlx查询一串值存入slice中的两种写法对比

同样都是取已一串值,存入slice中

此处SQL查询的值如下图:都是一系列的userId(故不需纠结SQL)

方法一:取出的值赋给每个userId ,再进行append到useidlist 列表中

func changedUserlist() ([]int64, error){
	changed_user_sql := `select distinct l.objectid from log l
 			where type IN ('fissionpidchange', 'fission_pid_change')`
	rows, err := db.Queryx(changed_user_sql)
	if err != nil {
		fmt.Printf("select failed, err:%v\n", err)
		return nil, err
	}
	defer rows.Close()

	useidlist := make([]int64, 0)
	for rows.Next() {
		var userId int64
		err := rows.Scan(&userId)
		if err != nil {
			fmt.Printf("scan failed, err:%v\n", err)
			return nil, err
		}
		useidlist = append(useidlist,userId)
	}
	return useidlist, err
}

方法二:直接根据地址赋值到changeduserIdLists 列表中,省去了给每个查出的值进行赋值再append的操作

//返回修改过绑定关系的userid列表
func changedUserlist()[]int64{
	changed_user_sql := `select distinct l.objectid from log l 
			where type IN ('fissionpidchange', 'fission_pid_change')`
	changeduserIdLists := make([]int64, 0)
	err := db.Select(&changeduserIdLists, changed_user_sql)
	if err != nil {
		fmt.Printf("objectid select failed, err:%v\n", err)
		return nil
	}
	return changeduserIdLists
}