在实现类中拼接了一条sql
select * from form1 f1 right join form2 f2 on f1.code = f2.code
1)从页面经controller进去获取数据的时候,获取不到左表的数据
2)使用控制台测试:
GenericApplicationContext appContext =
new AnnotationConfigApplicationContext(AppConfig.class);
CircuitCnmsFeatureService service = appContext.getBean(CircuitCnmsFeatureService.class);
service.getCircuitCnmsFeatureCodeAndFeatureCodeByCircuitId(String.valueOf(3));
这种方式就能得到左表的数据。
这是什么原因呢?
这是从页面进入的时候glassfish显示的提示:
preparing:select a.feature_code,b.code,b.description from (select feature_code from form1 WHERE ( ID = ? ) ) a right join form2 b on a.feature_code = b.code
Parameters: 3(Long)
这是控制台测试显示的提示:
preparing:select a.feature_code,b.code,b.description from (select feature_code from form1 WHERE ( ID = ? ) ) a right join form2 b on a.feature_code = b.code
Parameters: 3(Long)