语句：
INSERT INTO sdy_connectors(id,name,intro,type,power,appkey,appsecret,interval,creator,createtime,editor,edittime,delete)
VALUES(4,'22','22',2,2,'22','22',3,'22','2016-02-18 16:37:00','22','1900-01-01 00:00:00',0)
查询的时候 字段 interval 和 delete 查出来的数据就是默认值 ，这个该怎么处理？
之前 就是这样 @Column("·interval·'") 就是esc下面那个键，我也不想用关键字做字段啊 坑自己这属于，但是这字段都是总监定的 之前用SqlServer 加[] 转义的 都好用 但是用mysql 转义之后就出现问题了 ，不转义的话 只能做查询操作，不能添加，修改， 转义的话 添加，修改没问题 但是查询 查出来的值就是默认值 ，而不是修改后的值
测试代码
@Test
public void test_query_sp_mysql() {
if (!dao.meta().isMySql())
return;
dao.create(BadFieldName.class, true);
BadFieldName bfn = new BadFieldName();
bfn.interval = 1000;
dao.insert(bfn);
assertEquals(1, dao.count(BadFieldName.class));
assertNotNull(dao.fetch(BadFieldName.class));
assertEquals(1000, dao.fetch(BadFieldName.class).interval);
System.out.println(Json.toJson(dao.fetch(BadFieldName.class)));
}
public static class BadFieldName {
@Id
public int id;
@Column("·interval·")
public int interval;
}
能pass呢, 最后的toJson输出
{
"id" :1,
"interval" :1000
}
@Column("`interval`")
private int interval;
@At
@GET
@Ok("vel:connectors/list.html")
@RequiresRoles(value = { "regionAdmin", "admin" }, logical = Logical.OR)
public Result list(@Param(value = "page", df = "1") int page) {
Pager<Connectors> pager = connectorsService.listByPage(page);
pager.setUrl(_base() + "/connectors/list");
return Result.success().addData("pager", pager);
}
返回数据 还是为0 但是数据库有值
name :"12",
intro :"12",
type :2,
power :2,
appKey :"2342348204",
appsecret :"",
interval :0,
creator :"admin",
createTime :"2016-02-18 16:37:00",
editor :"admin",
editTime :"2016-02-18 17:31:14",
delete :0,
id :4
@At
@Test
public void test_query_sp_mysql() {
if (!dao.meta().isMySql())
return;
/*dao.create(Connectors.class, true);
Connectors bfn = new Connectors();
bfn.interval = 1000;
dao.insert(bfn);*/
System.out.println(Json.toJson(dao.fetch(Connectors.class)));
assertEquals(1, dao.count(Connectors.class));
assertNotNull(dao.fetch(Connectors.class));
assertEquals(1000, dao.fetch(Connectors.class).interval);
System.out.println(Json.toJson(dao.fetch(Connectors.class)));
}
信息：
SELECT * FROM sdy_connectors LIMIT 0, 1
{
"type" :12,
"power" :12,
"interval" :0,
"delete" :0,
"id" :1
}
02-19 16:43:41.439 DEBUG - [NutDaoExecutor.http-bio-8070-exec-6] SELECT COUNT(*) FROM sdy_connectors
02-19 16:43:43.628 DEBUG - [LoggingMethodInterceptor.http-bio-8070-exec-6] [whenError] Obj = [com.brt.museum.module.connectors.ConnectorsModule$$NUTZAOP] , Throwable = java.lang.NoClassDefFoundError: org/junit/Assert , Method = public void com.brt.museum.module.connectors.ConnectorsModule.test_query_sp_mysql() , args = []
02-19 16:43:43.629 DEBUG - [LoggingMethodInterceptor.http-bio-8070-exec-6] [afterInvoke] Obj = [com.brt.museum.module.connectors.ConnectorsModule$$NUTZAOP] , Return = null , Method = public void com.brt.museum.module.connectors.ConnectorsModule.test_query_sp_mysql() , args = []
02-19 16:43:43.632 WARN - [FailProcessor.http-bio-8070-exec-6] Error@/connectors/test_query_sp_mysql :
java.lang.RuntimeException: java.lang.NoClassDefFoundError: org/junit/Assert
at org.nutz.lang.Lang.wrapThrow(Lang.java:148)
at org.nutz.aop.interceptor.LoggingMethodInterceptor.filter(LoggingMethodInterceptor.java:66)
at org.nutz.aop.InterceptorChain.doChain(InterceptorChain.java:60)
at com.brt.museum.module.connectors.ConnectorsModule$$NUTZAOP.test_query_sp_mysql(ConnectorsModule.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)