查询的时候怎么把数据库存的null值这个字段显示出来,现在好像是直接给过滤掉了
13 回复
@wendal 我现在@ok返回的是页面,怎么在加@Ok("json:full")
@Ok("vel:work/vdo/list.html")
@wendal vel是velocity模板,不是jax的时候null字段,是查某一张表,这张表里有一个字段是null值,在查询的时候直接把这个字段给过滤了,这个和模板语法没关系吧。
看我返回的两条记录里 第一条exportvotescore这个字段有值就显示,第二条exportvotescore字段值为null 直接就给过滤掉了,压根就没显示这个字段,这个咋搞?
02-06 10:00:35.073 DEBUG - [LoggingMethodInterceptor.http-bio-8080-exec-9] [afterInvoke] Obj = [com.brt.vplan.service.work.impl.VdoService$$NUTZAOP] , Return = {{
"id" :41,
"likeid" :"微计划2018",
"num" :"c751778cd9db4401b18b64c2f486f60b",
"mid" :36,
"username" :"王二小",
"name" :"这是标题哦",
"vtype" :1,
"addtime" :"2018-02-02 09:43:21",
"updatetime" :"2018-02-05 15:50:44",
"cover" :"",
"intro" :"这是主题介绍哦,呵呵呵",
"playcount" :0,
"diggcount" :3,
"duration" :120,
"subject" :"这是拍摄对象",
"place" :"大别山",
"status" :2,
"verifysubmittime" :"2018-02-05 15:50:44",
"verifyfailreason" :"",
"originalurl" :"",
"original" :"",
"v720p" :"",
"imgs" :"",
"audiencevote" :8,
"exportvote" :1,
"exportvotescore" :86.00,
"bechosen" :0
}, {
"id" :40,
"likeid" :"微计划2018",
"num" :"a6779f02b7bd4d2fa39ca4e3c26cf1cd",
"mid" :36,
"username" :"王二小",
"name" :"",
"vtype" :1,
"addtime" :"2018-02-02 09:41:39",
"updatetime" :"2018-02-02 09:41:39",
"cover" :"",
"intro" :"",
"playcount" :0,
"duration" :0,
"subject" :"",
"place" :"",
"status" :0,
"verifysubmittime" :"2018-02-02 09:41:39",
"verifyfailreason" :"",
"originalurl" :"http://www.domain.com/123.jpg",
"original" :"",
"v720p" :"",
"imgs" :"",
"bechosen" :0
}
@wendal 我debug返回的数据也没有那个字段,这应该就是查询的结果吧
public Pager<Record> listByPage(int page) {
Pager<Record> pager = new Pager<Record>(PAGESIZE, page);
Condition cnd = Cnd.NEW();
Sql sql = dao.sqls().create("find.vdo.list.by.admin.id");
Sql sql1 = dao.sqls().create("find.vdo.count.by.admin.id");
cnd = Cnd.where("v.v_del", "=", 0).orderBy("v.v_id", "desc");
sql.setCondition(cnd);
sql1.setCondition(cnd);
sql.params().set("pageStart", (page - 1) * PAGESIZE);
sql.params().set("pageSize", PAGESIZE);
pager.setEntities(SqlActuator.runReport(sql, dao));
pager.setCount(SqlActuator.runUnq(sql1, dao));
return pager;
}
/*find.vdo.list.by.admin.id*/
SELECT
v.v_id AS id,
v.v_likeid AS likeid,
v.v_num AS num,
v.m_id AS mId,
m.m_realname AS userName,
v.v_name AS name,
v.v_type AS vtype,
v.v_addtime AS addtime,
v.v_updatetime AS updatetime,
v.v_cover AS cover,
v.v_intro AS intro,
v.v_playcount AS playcount,
v.v_diggcount AS diggcount,
v.v_duration AS duration,
v.v_subject AS subject,
v.v_place AS place,
v.v_status AS status,
v.v_verify_submit_time AS verifysubmittime,
v.v_verify_time AS verifytime,
v.v_verify_fail_reason AS verifyfailreason,
v.v_original_url AS originalurl,
v.v_original AS original,
v.v_720p AS v720p,
v.v_imgs AS imgs,
v.v_audience_vote AS audiencevote,
v.v_export_vote AS exportvote,
v.v_export_vote_score AS exportvotescore,
v.v_bechosen AS bechosen
FROM
zc_wjh_vdo v
LEFT JOIN zc_member m ON m.m_id = v.m_id
$condition limit @pageStart,@pageSize;
/*find.vdo.count.by.admin.id*/
SELECT
count(*)
FROM
zc_wjh_vdo v
LEFT JOIN zc_member m ON m.m_id = v.m_id
$condition
嗯, 不知道了, debug一下org.nutz.dao.entity.Record.create(Map<String, Object>, ResultSet, ResultSetMetaData)看看吧
@wendal 好 我在试试
@wendal 我也debug了一下 这是返回Record里的数据,exportvotescore是null
"id" :29,
"likeid" :"微计划2018",
"num" :"25ba18bd46044d74b1fca31cacea645b",
"mid" :36,
"username" :"王二小",
"name" :"这是标题哦",
"vtype" :1,
"addtime" :"2018-02-02 08:32:09",
"updatetime" :"2018-02-02 08:32:09",
"cover" :"http://www.domain.com/1233.jpg",
"intro" :"这是主题介绍哦,呵呵呵",
"playcount" :0,
"diggcount" :null,
"duration" :0,
"subject" :"这是拍摄对象",
"place" :"大别山",
"status" :2,
"verifysubmittime" :"2018-02-02 08:32:09",
"verifytime" :null,
"verifyfailreason" :"",
"originalurl" :"http://www.domain.com/123.jpg",
"original" :"",
"v720p" :"",
"imgs" :"",
"audiencevote" :null,
"exportvote" :null,
"exportvotescore" :null,
"bechosen" :0
添加回复
请先登陆