请问一下，哪位大神帮忙解答一下，通过service对象，怎么设置动态表名吗？按照教程来好像不生效

        Ksb_user user = ksbuser.fetch(Cnd.where("wxOpenId", "=", wxid));
        TableName.set(1);
        List<Ksb_customer> customerlist = ksbcustomer.query(Cnd.where("wxOpenId", "=", wxid));
        TableName.clear();
        return Result.success("success").addData(customerlist);

按上面这样写，查询时表名并没有动态变化，报错如下

java.lang.RuntimeException: org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT * FROM ksb_customer_  WHERE wxOpenId='oJYgp4_CQlHIcvccd2HBB7HDEkjQ''
PreparedStatement: 
'SELECT * FROM ksb_customer_  WHERE wxOpenId=?'
CaseMessage=Table 'kbs.ksb_customer_' doesn't exist
org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT * FROM ksb_customer_  WHERE wxOpenId='oJYgp4_CQlHIcvccd2HBB7HDEkjQ''
PreparedStatement: 
'SELECT * FROM ksb_customer_  WHERE wxOpenId=?'
CaseMessage=Table 'kbs.ksb_customer_' doesn't exist
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:110)

哪位大神有空帮忙解答一下，该怎么写，非常感谢~

wendal

1楼•1710天前

TableName.run，文档有吧

米底底(yangchidy)

2楼•1710天前

如果用TableName.run，我怎么能在一个接口的方法里，正常返回查询结果呢？

    @POST
    @At("/getcustomerlist")
    @Ok("json")
    public Object getcustomerlist(@Param("wxid") String wxid) {
        Ksb_user user = ksbuser.fetch(Cnd.where("wxOpenId", "=", wxid));
        //ksbcustomer.setTableName(user.getRandomTabNum());
        TableName.run(1, new Runnable() {
            @Override
            public void run() {

            }
        });
        List<Ksb_customer> customerlist = ksbcustomer.query(Cnd.where("wxOpenId", "=", wxid));
        return Result.success("success").addData(customerlist);
    }

像这样，感觉没办法实现了

米底底(yangchidy)

3楼•1710天前

试过用TableName.run了，也不行

wendal

4楼•1710天前

你真的看文档了吗?

wendal

5楼•1710天前

http://nutzam.com/core/dao/dynamic_table_name.html

wendal

6楼•1710天前