int l = Integer.parseInt(request.getParameter("limit"));
int s = Integer.parseInt(request.getParameter("start"));
String sql=" select * from ( select eei.*,cui.unit_name,cmuc.part_name,cuti.team_name,cui.unit_short_name,cbc.name status_name " +
" ,eei.birth_date as age,eei.manager_type as manager_type_name,eei.work_date as work_years,eei.enter_date as enter_years " +
",cafl.attach_file_position as photo_src" +
" from ag_employee_info eei "+
" left join com_unit_info cui on eei.unit_id=cui.unit_id" +
" left join com_unit_team_info cuti on eei.team_id=cuti.team_id and eei.unit_id = cuti.unit_id " +
" left join com_manage_unit_code cmuc on eei.unit_id=cmuc.unit_id and cmuc.team_id = eei.team_id and eei.part_code = cmuc.part_code " +
" left join com_base_code cbc on eei.status=cbc.no" +
" left join com_attach_group_lst cagl on cagl.attach_group_id = eei.photo_id "+
" left join com_attach_file_info cafl on cagl.attach_file_id = cafl.attach_file_id ) a where 1=1";
通过后台,查询sql,显示结果如下但是前端UI未显示结果,发生该错误的可能有哪些?
int s = Integer.parseInt(request.getParameter("start"));
String sql=" select * from ( select eei.*,cui.unit_name,cmuc.part_name,cuti.team_name,cui.unit_short_name,cbc.name status_name " +
" ,eei.birth_date as age,eei.manager_type as manager_type_name,eei.work_date as work_years,eei.enter_date as enter_years " +
",cafl.attach_file_position as photo_src" +
" from ag_employee_info eei "+
" left join com_unit_info cui on eei.unit_id=cui.unit_id" +
" left join com_unit_team_info cuti on eei.team_id=cuti.team_id and eei.unit_id = cuti.unit_id " +
" left join com_manage_unit_code cmuc on eei.unit_id=cmuc.unit_id and cmuc.team_id = eei.team_id and eei.part_code = cmuc.part_code " +
" left join com_base_code cbc on eei.status=cbc.no" +
" left join com_attach_group_lst cagl on cagl.attach_group_id = eei.photo_id "+
" left join com_attach_file_info cafl on cagl.attach_file_id = cafl.attach_file_id ) a where 1=1";
通过后台,查询sql,显示结果如下但是前端UI未显示结果,发生该错误的可能有哪些?
解决方案 »
- 关于连接数据库的驱动总是报错好急啊
- java 做网站
- 谁有电子商务(交易系统)这方面的资料或者源码
- 30分急求求适用于JSP的在线编辑器
- 急急急死了!关于request.getRemoteAddr()和request.getRemoteHost()的问题
- 我想下载tomcat,哪位能提供些站点。好用的
- 偶刚开始做web这一块,请教几个关于web应用的问题
- 关于jsp聊天室自动滚屏的问题!!!
- 读取SQL Server的numeric字段用什么函数?
- 我是刚开始学习JSP,想得到大家的帮助。谢谢。
- 请问一下我这个算是实现了webservice功能吗?
- zTree怎么判断树有节点展开或者完全关闭的
var me = this;
var unitId = me.cboUnit.getValue();
var employeeName = me.txtEmployeeName.getValue();
var duty = me.cboDuty.getValue();
var education = me.cboEducation.getValue();
me.employeeS.reload({params:{start: 0,
limit :me.safetyMangerGrid.toolbars[1].items.items[12].value,
unitId:unitId,employeeName:employeeName,duty:duty,education:education}
});
}
查询参数含自定义参数,直接查询链表报错的。上面的查询结果时调试的时候,测试查询事件时获得的,事件应该没错,就是想问下出现查询结果是不是说明后台事件一定有返回值,如果是的话,那就是前台代码出错的问题了