MyBatis查询不到数据
数据库中有数据,但是查询不到
2015-09-29 09:17:24,118 DEBUG [modules.sys.dao.OperatorDao.getByOpid] - ==> Preparing: SELECT a.id, a.company_id AS "company.id", a.office_id AS "office.id", a.opid, a.password, a.name, a.email, a.phone, a.mobile, a.optype AS opType, a.login_ip, a.login_time, a.remarks, a.login_flag, a.create_by AS "createBy.id", a.create_date AS createDate, a.update_by AS "updateBy.id", a.update_date AS updateDate, c.name AS "company.name", c.parent_id AS "company.parent.id", c.parent_ids AS "company.parentIds", ca.id AS "company.area.id", ca.name AS "company.area.name", ca.parent_id AS "company.area.parent.id", ca.parent_ids AS "company.area.parentIds", o.name AS "office.name", o.parent_id AS "office.parent.id", o.parent_ids AS "office.parentIds", oa.id AS "office.area.id", oa.name AS "office.area.name", oa.parent_id AS "office.area.parent.id", oa.parent_ids AS "office.area.parentIds", cu.id AS "company.primaryPerson.id", cu.name AS "company.primaryPerson.name", cu2.id AS "company.deputyPerson.id", cu2.name AS "company.deputyPerson.name", ou.id AS "office.primaryPerson.id", ou.name AS "office.primaryPerson.name", ou2.id AS "office.deputyPerson.id", ou2.name AS "office.deputyPerson.name" FROM sys_operator a JOIN sys_office c ON c.id = a.company_id JOIN sys_area ca ON ca.id = c.area_id JOIN sys_office o ON o.id = a.office_id JOIN sys_area oa ON oa.id = o.area_id LEFT JOIN sys_operator cu ON cu.id = c.primary_person LEFT JOIN sys_operator cu2 ON cu2.id = c.deputy_person LEFT JOIN sys_operator ou ON ou.id = o.primary_person LEFT JOIN sys_operator ou2 ON ou2.id = o.deputy_person WHERE a.opid = ? AND a.is_valid = ?
2015-09-29 09:17:24,118 DEBUG [modules.sys.dao.OperatorDao.getByOpid] - ==> Parameters: 12345(String), 0(String)
2015-09-29 09:17:24,149 DEBUG [modules.sys.dao.OperatorDao.getByOpid] - <== Total: 0