22,209
社区成员
发帖
与我相关
我的任务
分享Java mysql 存储过程 优化
@Query(nativeQuery = true, value = "call proc_sys_bps_user (?1,?2,?3,?4,?5,?6,?7,?8,?9,'',?10)")
List<SysBpsUserDto> findUserList(String userId, String idNumber, String userName, String userPhone, String isActive, String deptName, String areaName, int firstLimit, int secondLimit, String roleId);
@Query(nativeQuery = true, value = "call proc_sys_bps_user (?1,?2,?3,?4,?5,?6,?7,?8,?9,'sum',?10)")
int findUserListCount(String userId, String idNumber, String userName, String userPhone, String isActive, String deptName, String areaName, int firstLimit, int secondLimit, String roleId);
如上代码，查询速度太慢，求大神帮忙修改一下，加快查询速度。目前这两个查询，数据库是四千数据左右，查询用了15秒左右
List<SysBpsUserDto> findUserList(String userId, String idNumber, String userName, String userPhone, String isActive, String deptName, String areaName, int firstLimit, int secondLimit, String roleId);
@Query(nativeQuery = true, value = "call proc_sys_bps_user (?1,?2,?3,?4,?5,?6,?7,?8,?9,'sum',?10)")
int findUserListCount(String userId, String idNumber, String userName, String userPhone, String isActive, String deptName, String areaName, int firstLimit, int secondLimit, String roleId);
如上代码，查询速度太慢，求大神帮忙修改一下，加快查询速度。目前这两个查询，数据库是四千数据左右，查询用了15秒左右
...全文
请发表友善的回复…
发表回复
mengba2736496153 2016-11-24
- 打赏
- 举报
有建立索引，现在更改了查询了，不适用那个查询，时间快了很多了
gw6328 2016-11-23
- 打赏
- 举报
代码也不复杂，有建索引吗？
mengba2736496153 2016-11-23
- 打赏
- 举报
木有了啊，就之后这个了，impl调用了上面的代码就直接得到数据了[/quote]
List<SysBpsUserDto> list = sysBpsUserDtoRepository.findUserList(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);
int total = sysBpsUserDtoRepository.findUserListCount(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);这个是调用的地方，然后其他的我就没有找到哪里还有拼接的sql语句了[/quote]
你这个是java的代码，也不知道你sql语句是什么样的。
不管如何，你只有贴出来了sql语句才能帮你分析。[/quote]
我是小菜鸟，没找到你时候的那个sql语句[/quote]
debug后输出[/quote]
SELECT
`a`.`id` AS `id`,
`a`.`user_id` AS `user_id`,
`a`.`user_name` AS `user_name`,
`a`.`user_pwd` AS `user_pwd`,
`a`.`create_time` AS `create_time`,
`a`.`id_number` AS `id_number`,
`a`.`user_sex` AS `user_sex`,
`a`.`user_email` AS `user_email`,
`a`.`user_work_number` AS `user_work_number`,
`a`.`user_image_url` AS `user_image_url`,
`a`.`user_phone` AS `user_phone`,
`a`.`is_delete` AS `is_delete`,
`a`.`is_active` AS `is_active`,
`b`.`group_name` AS `area_name`,
`c`.`group_name` AS `dept_name`
FROM
(
(
`pj002`.`vw_sys_bps_user_true` `a`
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'zz'
)
) `b` ON (
(
`a`.`user_id` = `b`.`user_id`
)
)
)
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'bm'
)
) `c` ON (
(
`a`.`user_id` = `c`.`user_id`
)
)
)[/quote]
找到的代码就是这个 了，这个查询时间是9秒多。还不到四千的数据量[/quote]
先把两个 left join的subselect合并起来，用in （‘zz’, 'bm'）试试先
再慢的话，用CTE表，将pj002.vw_sys_bps_group_user中的数据先取出来，再用来join
[/quote]
好的，我试试[/quote]
木有了啊，就之后这个了，impl调用了上面的代码就直接得到数据了[/quote]
List<SysBpsUserDto> list = sysBpsUserDtoRepository.findUserList(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);
int total = sysBpsUserDtoRepository.findUserListCount(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);这个是调用的地方，然后其他的我就没有找到哪里还有拼接的sql语句了[/quote]
你这个是java的代码，也不知道你sql语句是什么样的。
不管如何，你只有贴出来了sql语句才能帮你分析。[/quote]
我是小菜鸟，没找到你时候的那个sql语句[/quote]
debug后输出[/quote]
SELECT
`a`.`id` AS `id`,
`a`.`user_id` AS `user_id`,
`a`.`user_name` AS `user_name`,
`a`.`user_pwd` AS `user_pwd`,
`a`.`create_time` AS `create_time`,
`a`.`id_number` AS `id_number`,
`a`.`user_sex` AS `user_sex`,
`a`.`user_email` AS `user_email`,
`a`.`user_work_number` AS `user_work_number`,
`a`.`user_image_url` AS `user_image_url`,
`a`.`user_phone` AS `user_phone`,
`a`.`is_delete` AS `is_delete`,
`a`.`is_active` AS `is_active`,
`b`.`group_name` AS `area_name`,
`c`.`group_name` AS `dept_name`
FROM
(
(
`pj002`.`vw_sys_bps_user_true` `a`
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'zz'
)
) `b` ON (
(
`a`.`user_id` = `b`.`user_id`
)
)
)
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'bm'
)
) `c` ON (
(
`a`.`user_id` = `c`.`user_id`
)
)
)[/quote]
找到的代码就是这个 了，这个查询时间是9秒多。还不到四千的数据量[/quote]
先把两个 left join的subselect合并起来，用in （‘zz’, 'bm'）试试先
再慢的话，用CTE表，将pj002.vw_sys_bps_group_user中的数据先取出来，再用来join
[/quote]
好的，我试试[/quote]
没啥作用
mengba2736496153 2016-11-23
- 打赏
- 举报
木有了啊，就之后这个了，impl调用了上面的代码就直接得到数据了[/quote]
List<SysBpsUserDto> list = sysBpsUserDtoRepository.findUserList(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);
int total = sysBpsUserDtoRepository.findUserListCount(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);这个是调用的地方，然后其他的我就没有找到哪里还有拼接的sql语句了[/quote]
你这个是java的代码，也不知道你sql语句是什么样的。
不管如何，你只有贴出来了sql语句才能帮你分析。[/quote]
我是小菜鸟，没找到你时候的那个sql语句[/quote]
debug后输出[/quote]
SELECT
`a`.`id` AS `id`,
`a`.`user_id` AS `user_id`,
`a`.`user_name` AS `user_name`,
`a`.`user_pwd` AS `user_pwd`,
`a`.`create_time` AS `create_time`,
`a`.`id_number` AS `id_number`,
`a`.`user_sex` AS `user_sex`,
`a`.`user_email` AS `user_email`,
`a`.`user_work_number` AS `user_work_number`,
`a`.`user_image_url` AS `user_image_url`,
`a`.`user_phone` AS `user_phone`,
`a`.`is_delete` AS `is_delete`,
`a`.`is_active` AS `is_active`,
`b`.`group_name` AS `area_name`,
`c`.`group_name` AS `dept_name`
FROM
(
(
`pj002`.`vw_sys_bps_user_true` `a`
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'zz'
)
) `b` ON (
(
`a`.`user_id` = `b`.`user_id`
)
)
)
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'bm'
)
) `c` ON (
(
`a`.`user_id` = `c`.`user_id`
)
)
)[/quote]
找到的代码就是这个 了，这个查询时间是9秒多。还不到四千的数据量[/quote]
先把两个 left join的subselect合并起来，用in （‘zz’, 'bm'）试试先
再慢的话，用CTE表，将pj002.vw_sys_bps_group_user中的数据先取出来，再用来join
[/quote]
好的，我试试
shoppo0505 2016-11-23
- 打赏
- 举报
木有了啊，就之后这个了，impl调用了上面的代码就直接得到数据了[/quote]
List<SysBpsUserDto> list = sysBpsUserDtoRepository.findUserList(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);
int total = sysBpsUserDtoRepository.findUserListCount(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);这个是调用的地方，然后其他的我就没有找到哪里还有拼接的sql语句了[/quote]
你这个是java的代码，也不知道你sql语句是什么样的。
不管如何，你只有贴出来了sql语句才能帮你分析。[/quote]
我是小菜鸟，没找到你时候的那个sql语句[/quote]
debug后输出[/quote]
SELECT
`a`.`id` AS `id`,
`a`.`user_id` AS `user_id`,
`a`.`user_name` AS `user_name`,
`a`.`user_pwd` AS `user_pwd`,
`a`.`create_time` AS `create_time`,
`a`.`id_number` AS `id_number`,
`a`.`user_sex` AS `user_sex`,
`a`.`user_email` AS `user_email`,
`a`.`user_work_number` AS `user_work_number`,
`a`.`user_image_url` AS `user_image_url`,
`a`.`user_phone` AS `user_phone`,
`a`.`is_delete` AS `is_delete`,
`a`.`is_active` AS `is_active`,
`b`.`group_name` AS `area_name`,
`c`.`group_name` AS `dept_name`
FROM
(
(
`pj002`.`vw_sys_bps_user_true` `a`
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'zz'
)
) `b` ON (
(
`a`.`user_id` = `b`.`user_id`
)
)
)
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'bm'
)
) `c` ON (
(
`a`.`user_id` = `c`.`user_id`
)
)
)[/quote]
找到的代码就是这个 了，这个查询时间是9秒多。还不到四千的数据量[/quote]
先把两个 left join的subselect合并起来，用in （‘zz’, 'bm'）试试先
再慢的话，用CTE表，将pj002.vw_sys_bps_group_user中的数据先取出来，再用来join
mengba2736496153 2016-11-23
- 打赏
- 举报
木有了啊，就之后这个了，impl调用了上面的代码就直接得到数据了[/quote]
List<SysBpsUserDto> list = sysBpsUserDtoRepository.findUserList(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);
int total = sysBpsUserDtoRepository.findUserListCount(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);这个是调用的地方，然后其他的我就没有找到哪里还有拼接的sql语句了[/quote]
你这个是java的代码，也不知道你sql语句是什么样的。
不管如何，你只有贴出来了sql语句才能帮你分析。[/quote]
我是小菜鸟，没找到你时候的那个sql语句[/quote]
debug后输出[/quote]
SELECT
`a`.`id` AS `id`,
`a`.`user_id` AS `user_id`,
`a`.`user_name` AS `user_name`,
`a`.`user_pwd` AS `user_pwd`,
`a`.`create_time` AS `create_time`,
`a`.`id_number` AS `id_number`,
`a`.`user_sex` AS `user_sex`,
`a`.`user_email` AS `user_email`,
`a`.`user_work_number` AS `user_work_number`,
`a`.`user_image_url` AS `user_image_url`,
`a`.`user_phone` AS `user_phone`,
`a`.`is_delete` AS `is_delete`,
`a`.`is_active` AS `is_active`,
`b`.`group_name` AS `area_name`,
`c`.`group_name` AS `dept_name`
FROM
(
(
`pj002`.`vw_sys_bps_user_true` `a`
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'zz'
)
) `b` ON (
(
`a`.`user_id` = `b`.`user_id`
)
)
)
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'bm'
)
) `c` ON (
(
`a`.`user_id` = `c`.`user_id`
)
)
)[/quote]
找到的代码就是这个 了，这个查询时间是9秒多。还不到四千的数据量
mengba2736496153 2016-11-23
- 打赏
- 举报
木有了啊，就之后这个了，impl调用了上面的代码就直接得到数据了[/quote]
List<SysBpsUserDto> list = sysBpsUserDtoRepository.findUserList(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);
int total = sysBpsUserDtoRepository.findUserListCount(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);这个是调用的地方，然后其他的我就没有找到哪里还有拼接的sql语句了[/quote]
你这个是java的代码，也不知道你sql语句是什么样的。
不管如何，你只有贴出来了sql语句才能帮你分析。[/quote]
我是小菜鸟，没找到你时候的那个sql语句[/quote]
debug后输出[/quote]
SELECT
`a`.`id` AS `id`,
`a`.`user_id` AS `user_id`,
`a`.`user_name` AS `user_name`,
`a`.`user_pwd` AS `user_pwd`,
`a`.`create_time` AS `create_time`,
`a`.`id_number` AS `id_number`,
`a`.`user_sex` AS `user_sex`,
`a`.`user_email` AS `user_email`,
`a`.`user_work_number` AS `user_work_number`,
`a`.`user_image_url` AS `user_image_url`,
`a`.`user_phone` AS `user_phone`,
`a`.`is_delete` AS `is_delete`,
`a`.`is_active` AS `is_active`,
`b`.`group_name` AS `area_name`,
`c`.`group_name` AS `dept_name`
FROM
(
(
`pj002`.`vw_sys_bps_user_true` `a`
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'zz'
)
) `b` ON (
(
`a`.`user_id` = `b`.`user_id`
)
)
)
LEFT JOIN (
SELECT
`vw_sys_bps_group_user`.`id` AS `id`,
`vw_sys_bps_group_user`.`group_code` AS `group_code`,
`vw_sys_bps_group_user`.`group_name` AS `group_name`,
`vw_sys_bps_group_user`.`group_type` AS `group_type`,
`vw_sys_bps_group_user`.`group_class` AS `group_class`,
`vw_sys_bps_group_user`.`parent_id` AS `parent_id`,
`vw_sys_bps_group_user`.`sort_id` AS `sort_id`,
`vw_sys_bps_group_user`.`is_delete` AS `is_delete`,
`vw_sys_bps_group_user`.`user_id` AS `user_id`
FROM
`pj002`.`vw_sys_bps_group_user`
WHERE
(
`vw_sys_bps_group_user`.`group_class` = 'bm'
)
) `c` ON (
(
`a`.`user_id` = `c`.`user_id`
)
)
)
shoppo0505 2016-11-23
- 打赏
- 举报
木有了啊，就之后这个了，impl调用了上面的代码就直接得到数据了[/quote]
List<SysBpsUserDto> list = sysBpsUserDtoRepository.findUserList(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);
int total = sysBpsUserDtoRepository.findUserListCount(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);这个是调用的地方，然后其他的我就没有找到哪里还有拼接的sql语句了[/quote]
你这个是java的代码，也不知道你sql语句是什么样的。
不管如何，你只有贴出来了sql语句才能帮你分析。[/quote]
我是小菜鸟，没找到你时候的那个sql语句[/quote]
debug后输出
mengba2736496153 2016-11-23
- 打赏
- 举报
木有了啊，就之后这个了，impl调用了上面的代码就直接得到数据了[/quote]
List<SysBpsUserDto> list = sysBpsUserDtoRepository.findUserList(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);
int total = sysBpsUserDtoRepository.findUserListCount(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);这个是调用的地方，然后其他的我就没有找到哪里还有拼接的sql语句了[/quote]
你这个是java的代码，也不知道你sql语句是什么样的。
不管如何，你只有贴出来了sql语句才能帮你分析。[/quote]
我是小菜鸟，没找到你时候的那个sql语句
shoppo0505 2016-11-23
- 打赏
- 举报
木有了啊，就之后这个了，impl调用了上面的代码就直接得到数据了[/quote]
List<SysBpsUserDto> list = sysBpsUserDtoRepository.findUserList(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);
int total = sysBpsUserDtoRepository.findUserListCount(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);这个是调用的地方，然后其他的我就没有找到哪里还有拼接的sql语句了[/quote]
你这个是java的代码，也不知道你sql语句是什么样的。
不管如何，你只有贴出来了sql语句才能帮你分析。
mengba2736496153 2016-11-23
- 打赏
- 举报
木有了啊，就之后这个了，impl调用了上面的代码就直接得到数据了[/quote]
List<SysBpsUserDto> list = sysBpsUserDtoRepository.findUserList(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);
int total = sysBpsUserDtoRepository.findUserListCount(userId, idNumber, userName, userPhone, isActive, deptName, areaName, firstNumber, secondNumber, roleId);这个是调用的地方，然后其他的我就没有找到哪里还有拼接的sql语句了
mengba2736496153 2016-11-23
- 打赏
- 举报
木有了啊，就之后这个了，impl调用了上面的代码就直接得到数据了
shoppo0505 2016-11-23
- 打赏
- 举报
把拼接完成的sql贴出来吧。
