这个必须记录一下, 起因是李甫要我改一个东西 把原来的DAO 改成用JADE写的 我就改啊改 改的很2b
比如这样
@SQL("select id, owner, type, appId, appName, sender, senderName, body, button, readFlag, time, block from " + TABLE_NAME + " where id = :id and owner = : owner ")
public AppRequestModel get(
@SQLParam("id")int id,
@SQLParam("owner")int owner
);
还有这样
@SQL("select id, owner, type, appId, appName, sender, senderName, body, button, readFlag, time, block from " + TABLE_NAME + " where owner =:owner and type=:type and app_id=25049 order by id desc limit offset,limit")
public List getPaoPaoRequestList(
@SQLParam("owner")int owner,
@SQLParam("type")int type,
@SQLParam("offset")int offset,
@SQLParam("limit")int limit
);
但是李甫修改后的 就用了一个字符串常量:
public static String FIELDS = " id, owner, type, app_id, app_name, sender, sender_name, body, button, readflag, time, expire_flag ";
很easy 不是吗 以后的每一个就清爽很多了 也不怕漏掉哪一个了 为什么我没想到 为什么我没做到 这么简单的事情 虚心谨慎好好学!!!