7
gf版本v1.9.6
2019-09-27 16:35:32.471 [DEBU] [28 ms] SELECT t.id,t.user_id as userId,t.role_id as roleId FROM sys_user_role t WHERE 1 = 1 and user_id = 11
2019-09-27 16:35:32.472 [ERRO] sys_user_role list error sql: no rows in result set
Stack:
1. gmanager/module/system.SysUserRole.List
当数据为空是,必须独立判断一下,代码如下
err := model.dbModel("t").Fields(model.columns()).Where(where, params).OrderBy(form.OrderBy).Structs(&resData)
if err == sql.ErrNoRows {
return []SysUserRole{}
} else if err != nil {
glog.Error(model.TableName()+" list error", err)
return []SysUserRole{}
}
return resData
个人建议:java没有数据直接返回空对象或者列表长度为0,不需要独立判断异常 而gdb正常查询每次还需要独立判断sql.ErrNoRows,感觉比较麻烦